Re: Easy question

The question is not so silly you think ;-)  As far as I know the IMP utility for Oracle 7.3 still does not contain the possibility do have a runnable SQL-listing.

Though...

The simple answer is:

1. Do EXP to file
2. Do IMP SHOW=YES

If you use Unix I will provide you a Perl script which helps to prepare a CLEAN text file containing all the SQL right from alive database using an EXP-IMP "pipe".

Sergey Lukashevich
lukash_at_rosno.ru

 Hugo Juan Jordan wrote in article <01bc7575$b4054940$2f010b0a_at_-47->...
>In order to document the structure of a database, they have asked me to
>obtain a text file with all the SQL statements needed to build the same
>database that I am running in a Oracle server 7.3.. I'm sure it must be
>very easy to obtain, but I have no idea.
>Any suggestions?
>
>I'm very sorry to ask silly questions, but I'm still very far from really
>good ones.
>
>Thanks in advance.
>
>Hugo Juan
>
Received on Tue Jun 10 1997 - 00:00:00 CDT