View Single Post

   
  #9 (permalink)  
Old 04-19-2008, 09:36 PM
Daniel Morgan
 
Posts: n/a
Default Re: Informix to Oracle migration

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


Your hiku needs a little work.

SELECT object_name, object_type
FROM user_objects;

SELECT object_name, object_type
FROM all_objects
WHERE owner = <schema_name>;

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Reply With Quote