Re: Getting SQL Scripts

From: Doug Barnes <dwb_at_rell. <dwb_at_rell.">
Date: 1998/01/16
Message-ID: <69o828$ctm_at_ux1005.rell.com>#1/1


ShivKumar wrote:
>
> Hi all,
>
> I've created a set of tables using Oracle Schema Manager. Now I need the
> SQL Scripts to create those tables. We want to provide the SQL scripts as
> part of a demo, so that the users can create similar database and tables
> on their Server and run the demo.
>
> Also is there any option to EXPORT data from tables to a TEXT file , so
> that I can use those text files to Load data again into the tables using
> SQL Loader ?
>
> Thanx for any help
>
> shiv
> vihs_at_rocketmail.com
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

Export can do this, A full export first exports the STRUCTURE of the database (tablespaces, users, tables, grants, etc), then the data-all in ascii form!!

-- 
Remove the NOSPAM to E-mail me.  Tired of the MLM schemes.
Received on Fri Jan 16 1998 - 00:00:00 CET

Original text of this message