Re: DESCRIBE schema???

Hi,

Systems and Programming <sysdev_at_adpsystems.mb.ca> wrote in article <32A869D4.55B9_at_adpsystems.mb.ca>...
> Speaking of which, is it true that schemas in Oracle are
> defined as all the tables that belong to a particular
> owner? Where can I find info on these concepts?

DESCRIBE and SQL commands search objects as following step when no schema is specified.

1. Table, view or private synonym
2. Public synonym.

You can check whom an object belong to, as following.

SELECT object_type, owner, object_name FROM ALL_OBJECTS

      WHERE object_name = 'object-name to descraibe';

-- 
Yasuhiro Ushitaki / Toyo Information Systems Co.,Ltd.