OracleDB12c New Feature: RMAN Describe

Similar to SQL*Plus DESCRIBE command, RMAN now supports DESCRIBE.

If you are connected using the SYSDBA privilege, you can view tables in other schemas, but with SYSBACKUP connection you will not be able to view user tables. SYSBACKUP is new privilege in 12c. [Administrative privileges began with SYSDBA and SYSOPER in 8i, then SYSASM in 11g, now SYSBACKUP, SYSDG and SYSKM in 12c]

RMAN also supports most SQL statements, without the SQL prefix (and messing with quotes around the SQL!!).

 

 

Leave a Reply

%d bloggers like this: