RE: An Oracle question
Posted in 2000
You have to use "exp" command plus its options to get the db structure. I
think it is -
exp user/passwd file=output file name full=Y rows=N
> -----Original Message-----
> From: Tom Grenier [SMTP:tom@sqlman.com]
> Sent: Tuesday, April 18, 2000 4:03 AM
> To: informix-list@iiug.org
> Subject: An Oracle question
>
> 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
CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Siemens Ltd., ACN 004 347 880, or Siemens (NZ) Limited immediately.