1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| SQL> startup
ORACLE instance started.
Total System Global Area 1476395008 bytes
Fixed Size 2084072 bytes
Variable Size 620757784 bytes
Database Buffers 838860800 bytes
Redo Buffers 14692352 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/data/ora/ORCL/test_01.dbf'
SQL> alter database datafile '/data/ora/ORCL/test_01.dbf' offline drop;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/data/ora/ORCL/test_02.dbf'
SQL> alter database datafile '/data/ora/ORCL/test_02.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> select file_name, tablespace_name from dba_data_files;
FILE_NAME TABLESPACE_NAME
---------------------------------------------------------------------- ------------------------------
....
/data/ora/ORCL/test_01.dbf TEST
/data/ora/ORCL/test_02.dbf TEST
SQL> drop tablespace test;
Tablespace dropped. |
Partager