check properly :select file_name ,tablespace_name,bytes,blocks,status from dba_data_files                                

解决方案 »

  1.   

    mv xxx.dat xxx.dat.bak
    试一下
      

  2.   

    列表中有!
    怎么去掉?
    TABLESPACE_NAME                     BYTES     BLOCKS STATUS
    ------------------------------ ---------- ---------- ---------
    /oradisk/oracle/app/oracle/oradata/ems/system01.dbf
    SYSTEM                          183500800      11200 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/oemrep01.dbf
    OEM_REPOSITORY                    5242880        320 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/rbs01.dbf
    RBS                              12582912        768 AVAILABLE
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                     BYTES     BLOCKS STATUS
    ------------------------------ ---------- ---------- ---------
    /oradisk/oracle/app/oracle/oradata/ems/temp01.dbf
    TEMP                             12845056        784 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/users01.dbf
    USERS                          5253038080     320620 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/indx01.dbf
    INDX                             10485760        640 AVAILABLE
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                     BYTES     BLOCKS STATUS
    ------------------------------ ---------- ---------- ---------
    /oradisk/oracle/tabspace/datafile1.dat
    EMS_TB_SP                      1048576000      64000 AVAILABLE/oradisk/oracle/tabspace/rollbk.dat
    ROLLBACK                         52428800       3200 AVAILABLE/oradisk/oracle/tabspace/EMS_RB.data
    RB_EMS                           52428800       3200 AVAILABLE
    9 rows selected.
      

  3.   

    搞定了!!!
    多谢sun9989(一品黄山)