又备份吗? 如果没有,数据就丢了打开可以 1. STARTUP MOUNT PFILE='<location_of_pfile>'; 2. Offline drop the datafile. SQL> ALTER DATABASE DATAFILE '<full_path_file_name>' OFFLINE DROP; 3. If the database is at mount point, open it. SQL> ALTER DATABASE OPEN; 4. Drop the user tablespace. SQL> DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS;
如果没有,数据就丢了打开可以
1. STARTUP MOUNT PFILE='<location_of_pfile>';
2. Offline drop the datafile.
SQL> ALTER DATABASE DATAFILE '<full_path_file_name>' OFFLINE DROP;
3. If the database is at mount point, open it.
SQL> ALTER DATABASE OPEN;
4. Drop the user tablespace.
SQL> DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS;