When the user didn't add success, table space also have no, only DBF file, originally is the asm storage, DATA, but DBF in local; The
Directory is no this file, but can a database query, shut down many times, start the database, all can find the file
SQL> The alter in tablespace users drop datafile '/u01/app/oracle/product/12.1.0/dbhome_1oradataccdata. DBF';
ORA - 03284: datafile or tempfile as expected
/u01/app/oracle/product/12.1.0/dbhome_1oradataccdata. DBF is not a member of
In tablespace USERS
SQL> Select distinct TABLESPACE_NAME from tabs
TABLESPACE_NAME
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
SYSAUX
The SYSTEM
CodePudding user response:
Shown above is not a member of in tablespace USERS,You look at the record dba_data_files inside is what circumstance
CodePudding user response:
You login to another node to try, because you create data files may no longer current login nodes, on the other hand, if the data has been written about the data files can't drop, suggest moving the file from the local file system into the ASM