Re: Easy question

Hugo Juan Jordan wrote:
>
> 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

You must export whole database without data. You can copy this *.dmp file and open it in an editor. With change/replace you can get sql text file of your database. Don't forget, If you want to create the database you should simply import this *.dmp file.

Hakan Eren
InfoPower International Inc.
ERP/MRPII/DBMS Consulting and Software

Phone:905-507-2100
Fax:905-507-2108
E-mail:hakan_at_infopwr.com

       prabir_at_infopwr.com Received on Tue Jun 24 1997 - 00:00:00 CDT