How to list database registered in Oracle8 catalog

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!

Quote:

---

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;

---

Quote:

---

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

Thanks SAM!!!