Re: Oracle Export Question

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/29
Message-ID: <hIyY4.215995$Tn4.1940285@news1.rdc2.pa.home.com>#1/1

export full,

imp show=y log=logfile.sho

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
<sheerfun_at_my-deja.com> wrote in message news:8gtv0g$l25$1_at_nnrp2.deja.com...


> 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