1、查看datafile信息(文件号、是否在线和路径名字) select file#,status,name from v$datafile; select file#,name,checkpoint_change# from v$datafile; select file#,