Thursday, January 05, 2012

Oracle Query to find listing of Schema Owners


select distinct owner from dba_objects

In Oracle Schema defined as;

A schema is a collection of logical structures of data, or schema objects.
A schema is owned by a database user and has the same name as that user.

No comments: