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/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)