How to list database registered in Oracle8 catalog
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to list database registered in Oracle8 catalog

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Dear Members/Gurus

    I have two questions regarding RMAN catalog in Oracle 8.0

    1) When connected to target and Catalog databases, what command do I use to list all the databases and their DB id's that are registered in the catalog?

    2) How can I also delete/unregistered unwanted database entries from the 8.0 catalog?

    Thanks in advance!
    roukie-dba

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by roukie_dba
    Dear Members/Gurus

    I have two questions regarding RMAN catalog in Oracle 8.0

    1) When connected to target and Catalog databases, what command do I use to list all the databases and their DB id's that are registered in the catalog?
    Code:
        sqlplus catalog_name/password@service_name
       
        SELECT * FROM RC_DATABASE;

    2) How can I also delete/unregistered unwanted database entries from the 8.0 catalog?
    http://technet.oracle.com/docs/produ...cat.htm#442604


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Thanks SAM!!!
    roukie-dba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width