What is the query to display all database in oracle server 9i?

Question

I like to know the query to get all database in oracle server 9i. Actually my requirement is to select all database in oracle and next to get all table , views , procedures , function in each database. Is their any way to get all these information? I am using oracle spl plus developer.

Answer 1

The database names you can get from server file system or check running Oracle Processes.

Then check select * from DBA_OBJECTS WHERE OBJECT_TYPE IN ('TABLE','VIEW','FUNCTION','PACKAGE','PROCEDURE')