sqlplus/nolog
SQL> conn sys as sysdba
在不确定是哪个文件的时候,先执行一下alter database open;
会有提示
alter database datafile 5 offline drop; alter database open; drop tablespace perfeval including contents and datafiles; drop user perfeval cascade; |
sqlplus/nolog
SQL> conn sys as sysdba
在不确定是哪个文件的时候,先执行一下alter database open;
会有提示
alter database datafile 5 offline drop; alter database open; drop tablespace perfeval including contents and datafiles; drop user perfeval cascade; |