Similar to SQL*Plus DESCRIBE command, RMAN now supports DESCRIBE.<\/p>\n
RMAN> desc hr.jobs\nusing target database control file instead of recovery catalog\nName Null? Type\n----------------------------------------- -------- ----------------------------\nJOB_ID NOT NULL VARCHAR2(10)\nJOB_TITLE NOT NULL VARCHAR2(35)\nMIN_SALARY NUMBER(6)\nMAX_SALARY NUMBER(6)\nRMAN><\/pre>\nIf 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]<\/p>\n
RMAN also supports most SQL statements, without the SQL prefix (and messing with quotes around the SQL!!).<\/p>\n
RMAN> SELECT user from dual;\nUSER\n------------------------------\nSYS\nRMAN><\/pre>\n<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Similar to SQL*Plus DESCRIBE command, RMAN now supports DESCRIBE. RMAN> desc hr.jobs using target database control file instead of recovery catalog Name Null? Type —————————————– ——– —————————- JOB_ID NOT NULL VARCHAR2(10) JOB_TITLE NOT NULL VARCHAR2(35) MIN_SALARY NUMBER(6) MAX_SALARY NUMBER(6) RMAN> If you are connected using the SYSDBA privilege, you can view tables in other schemas, … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[40],"class_list":["post-123","post","type-post","status-publish","format-standard","hentry","category-oracledb","tag-oracle-12c"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":3038,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/123\/revisions\/3038"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}