| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
Index > Database Admin
|
In Oracle 10G one can UNDROP a table without having to restore the entire database. If a table a dropped, Oracle moves it to a Recycle Bin. Starting with Oracle release 9.0.1, Oracle doesn't ship with a svrmgrl utility. One should migrate all svrmrgl scripts to SQL*Plus. Svrmgrl STARTUP keywords EXCLUSIVE, SHARED and PARALLEL have no effect from Oracle8. Set INIT.ORA parameter PARALLEL_SERVER=FALSE to start in EXCLUSIVE mode. From Oracle8 you can use the file number instead of the name in commands. Eg. ALTER DATABASE DATAFILE 40 OFFLINE; From Oracle8 the Advanced Replication Option is included with Oracle8 Enterprise Edition for free. |
![]() |
![]() |