Solution: SELECT name FROM v$parameter WHERE isdeprecated =’TRUE’ ORDER BY name;

The source database on Windows is PROD1 and the target database is a 11g RAC database RACDB1. 1) Create the tablespace and the test...

1. Create the environment SQL> connect / as sysdba Connected. SQL> drop user ebernal cascade; User dropped. SQL> purge dba_recyclebin;...

Note for 11g and newer installations: This procedure only works if ADR has been disabled in the listener.ora (addition of...

How to Rename or Move Datafiles and Logfiles: ============================================= NOTE: To rename or relocate datafiles in the...

Goal This article explains how you can check which options or features are used in the database. This is particularly useful for...

SOLUTION 1. Start with both OCR copies in the correct state: $ ls -l /ora10g/app/oracle/oradata/V10 lrwxrwxrwx  1 oracle  dba  14 Jul 25...