Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
I'm looking for: Advanced options

Index > Database Admin

Presenting DBAs in Black...
"The degree of normality in a database is inversely proportional to that of its DBA"

Did you know:

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.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US