Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Informix to Oracle migration

Re: Informix to Oracle migration

From: Obnoxio The Clown <obnoxio_at_hotmail.com>
Date: Tue, 02 Mar 2004 00:32:51 +0000
Message-ID: <c20l7s$1ngndb$2@ID-64669.news.uni-berlin.de>


Daniel Morgan wrote:

> Steven Hauser wrote:

>> A detailed data dictionary of the schema. Would be a good thing to have.

>
> Your hiku needs a little work.

"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"
- Coluche 
Received on Mon Mar 01 2004 - 18:32:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US