Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Generate SQLScript

Re: Generate SQLScript

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Thu, 14 Sep 2000 07:12:44 -0400
Message-Id: <10619.116961@fatcity.com>


I"m working on the strip out of the DDL from a .dmp file, its close to be ready for testing.

Joe
Indra Harimurti wrote:
>
> u can do this :
> $ exp user/passwd full=y rows=n
> once the expdat.dmp created, u can then
> $ imp user/passwd full=y indexfile=struc
> u can view file struc to see the definition of
> table and index structures.
>
> -----Original Message-----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Thursday, September 14, 2000 11:20 AM
>
> >Dear All,
> >
> >Is there a way in Oracle to generate SQL script from the existing database
> >structure? How?
> >
> >TIA to you all
> >
> >Sincerely,
> >Yuzie Nozie
> >

-- 
Joe Testa  http://www.oracle-dba.com
Received on Thu Sep 14 2000 - 06:12:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US