Re: Export Answer Welcome

From: tmgn <tmgn_at_excite.com>
Date: Tue, 03 Aug 1999 12:05:24 -0400
Message-ID: <37A71344.92B77E87@excite.com>

Zoran,
Export the Tables wth ROWS=N, Indexes=N options and Import with INDEXFILE=create_script.sql ROWS=N options.

create_script.sql will have all your Table/Index Creation Statements which you can edit to U'r needs..

-Thiru

zoran wrote:

> Hi,
>
> Does anyone know an easy way of exporting my sql script from an
> Oracle database
> into a ascii file?
>
> Export function of the Oracle do some things, but include it into dump
> file!
>
> For instance if I created my Customer Table using my sql script:
>
> Create table xxx
> (customerid char(5),
> customername varchar(35));
> .....................................................
>
> I'd like to export this script into same form using some export
> function!
>
> I didn't find an easy way!
>
>
>
> Thanks
>
> Zoran
>
Received on Tue Aug 03 1999 - 11:05:24 CDT