Oninit cdi / Archive
Talk to an expert →

Re: Informix to Oracle migration

Posted in 2004

Summary

Nominally about migrating from Informix to Oracle, this fragment of the thread contains almost no technical content. One poster remarks that a detailed data dictionary of the schema would be useful, and Daniel Morgan replies with two simple Oracle queries (SELECT object_name, object_type FROM user_objects, and the same from all_objects filtered by owner) as a way to list schema objects. The remaining posts are jokes about the terse haiku-like phrasing, spelling corrections and limericks. No actual migration problem is stated and no resolution is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Migration, Import/Export & Data Conversion

Steven Hauser — — source: Usenet: comp.databases.informix

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

↪ replying to Steven Hauser
Captain Pedantic — — source: Usenet: comp.databases.informix

"Steven Hauser" <hause011@tc.umn.edu> wrote in message news:c1vu6h$adn$1@lenny.tc.umn.edu... > A detailed data dictionary of the schema. Would be a good thing to have. Were you asked To write A poem Today?

↪ replying to Steven Hauser
Daniel Morgan — — source: Usenet: comp.databases.informix

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@x.washington.edu (replace 'x' with a 'u' to reply)

↪ replying to Captain Pedantic
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Captain Pedantic wrote: > "Steven Hauser" <hause011@tc.umn.edu> wrote in message > news:c1vu6h$adn$1@lenny.tc.umn.edu... >> A detailed data dictionary of the schema. Would be a good thing to have. > > Were you asked > To write > A poem > Today? A witty young poster named Steven liked making his sentences even. The grumpiest Captain went round there and slapped him and left with his chest all a-heavin' ... -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche

↪ replying to Daniel Morgan
Obnoxio The Clown — — source: Usenet: comp.databases.informix

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

↪ replying to Obnoxio The Clown
Daniel Morgan — — source: Usenet: comp.databases.informix

Obnoxio The Clown wrote: > 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>; Well at least you didn't correct my SQL. Thanks for catching the typo. -- 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@x.washington.edu (replace 'x' with a 'u' to reply)

↪ replying to Captain Pedantic
Andrew Hamm — — source: Usenet: comp.databases.informix

Captain Pedantic wrote: > "Steven Hauser" <hause011@tc.umn.edu> wrote in message > news:c1vu6h$adn$1@lenny.tc.umn.edu... >> A detailed data dictionary of the schema. Would be a good thing to >> have. > > Were you asked > To write > A poem > Today? Perhaps this is best answered in MIME.