Re: Full Export/Import

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 19 Nov 2001 20:24:46 +1100
Message-ID: <3bf8cf4b$0$13483$afc38c87@news.optusnet.com.au>

I'm confused. What's wrong with exp system/manager file=blah.dmp full=y?

Use the lower version of export to produce a 7.3-compatible dump file. Use the 9i version of import to read it and import into the higher version of the database. Import will be imp system/manager file=blah.dmp, too.

(I think what Sybrand was trying subtly to suggest is that, on the face of things, there's nothing terribly subtle about your request: it's basic export and import, because, by default, export does a full database export, and import does a full database import... so therefore, it seems that what you don't understand or know how to do is basically to use either utility at all. Which is not a crime, but his answer is understandable nontheless.)

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"S-marty" <monkey_at_ludo.aa> wrote in message
news:9tahq9$dv432_at_ns4.bih.net.ba...


>

> Sybrand Bakker wrote in message

> <1sk9vt4po9of89kdhvqqjovvbs3pic5tur_at_4ax.com>...

> >On Fri, 16 Nov 2001 09:11:00 +0100, "S-marty" <monkey_at_ludo.aa> wrote:

> >

> >>Hi friends

> >>

> >>I have to make a export of whole Oracle 7.3 database and then import it

in


> >>Oracle 9.0.1 database.

> >>Can someone guide me how to do that.

> >>Some tips etc..

> >>

> >>Thanx

> >>

> >Tip: Read the Oracle Server Utilities Manual

> >

>

>

> Thanx

>

> But, there is nothing about full export/import.

>

>

Received on Mon Nov 19 2001 - 03:24:46 CST