Re: Oracle Export Question

Your job is much bigger than you imagine...

You can not simply export some data in an existing format and then magically have it reload into a new format... Where will each field go? Presumably you have changed the schema for some logical reason... do you need to populate primary keys while reloading data? This kind of effort usually involves a large effort of data migration from one (or many) original formats into the new schema with many data integrity checks and construction of new data as required...

randy

sheerfun_at_my-deja.com wrote:

> I need to upgrade the existing schema on my
> database and i want to be able to back up just
> the data and current value of sequences.
> Then,create a new database, run the script for
> the new schema and then import the data. Also, i
> want to able to use, maybe, SQLLoader or PL/SQL
> to read the data file and insert the data in to
> some new tables.
>
> Is there any way in Oracle to export just the
> data from the tables and sequenes in ascii format
> and then i can use SQLLoader to import the data?
> Or is export in Oracle always binary format using
> exp?
>
> Can anyone suggest a plan?
>
> Thank you in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jun 01 2000 - 00:00:00 CDT