Oracle Export Question

From: <sheerfun_at_my-deja.com>
Date: 2000/05/29
Message-ID: <8gtv0g$l25$1@nnrp2.deja.com>#1/1

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 Mon May 29 2000 - 00:00:00 CDT