Re: Generate SQLScript

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-----
From: Nosie <tekait11_at_bni.co.id>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thursday, September 14, 2000 11:20 AM Subject: Generate SQLScript

>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
>
>
>--
>Author: Nosie
> INET: tekait11_at_bni.co.id
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Wed Sep 13 2000 - 22:51:08 CDT