An Oracle question

Posted in 2000

Tom Grenier — Mon, 17 Apr 2000 14:02:45 -0400 — source: Informix-list mailing list archive (1991-1998)

I know -- this is the Informix list. But I am being forced to work with Oracle, and I have a question I either don't know how to word to find in Oracle -- or it doesn't exist. I am looking to get a database dump like dbschema -d xxx in Oracle. They have all these primitive views and such, but look as I may I can find nothing like dbschema (the describe command is the closest I've found -- and it's not even close). Does anyone that works with both know of a way to get a dbschema type output. Thanks, Tom

↪ replying to Tom Grenier

Art S. Kagel — Mon, 17 Apr 2000 14:26:37 -0400 — source: Informix-list mailing list archive (1991-1998)

Tom Grenier wrote: > I know -- this is the Informix list. But I am being forced to work with > Oracle, and I have a question I either don't know how to word to find in > Oracle -- or it doesn't exist. > > I am looking to get a database dump like dbschema -d xxx in Oracle. > They have all these primitive views and such, but look as I may I can > find nothing like dbschema (the describe command is the closest I've > found -- and it's not even close). Does anyone that works with both > know of a way to get a dbschema type output. > Oracle has no such utility like dbschema, no. Their graphical, PC based, administration tool (DBExplorer?? I forget, had to work at it!) is as close as you can come and can write out an SQL schema file for you. Art S. Kagel

↪ replying to Tom Grenier

Mister Creosote — Tue, 18 Apr 2000 09:28:22 GMT — source: Informix-list mailing list archive (1991-1998)

In article <38FB51C5.9350B4E1@sqlman.com>, Tom Grenier <tom@sqlman.com> wrote: > I know -- this is the Informix list. But I am being forced to work with > Oracle, and I have a question I either don't know how to word to find in > Oracle -- or it doesn't exist. > > I am looking to get a database dump like dbschema -d xxx in Oracle. > They have all these primitive views and such, but look as I may I can > find nothing like dbschema (the describe command is the closest I've > found -- and it's not even close). Does anyone that works with both > know of a way to get a dbschema type output. > > Thanks, > Tom > > Try www.embarcadero.co.uk - They have a product called ER/Studio available for download on eval which can reverse engineer databases including the big 'O'. (Aside - very useful to migrate from the big 'O' into Informix) Regards Mr Creosote -- "Just a waffer thin mint?" Sent via Deja.com http://www.deja.com/ Before you buy.