Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Informix to Oracle migration
Daniel Morgan wrote:
> Steven Hauser wrote:
>> A detailed data dictionary of the schema. Would be a good thing to have.
"Haiku".
> SELECT object_name, object_type
> FROM user_objects;
>
> SELECT object_name, object_type
> FROM all_objects
> WHERE owner = <schema_name>;
-- "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - ColucheReceived on Mon Mar 01 2004 - 18:32:51 CST