Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Generate SQLScript
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.comReceived on Thu Sep 14 2000 - 06:12:44 CDT
![]() |
![]() |