RE: Import Help

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 14 Nov 2001 22:58:39 -0800
Message-ID: <F001.003C569A.20011114224021@fatcity.com>

Hi Sujatha,

First you import the definitions into a logfile and then create the tablespaces by editing
the datafile locations.

Imp userid=system/manager full=y file=fulldump.dmp log=fulldump.log show=y

When you execute above command, the logfile fulldump.log would have all the tablespace definition
in the beginning. You can edit the definitions and execute them separately to create the tablespaces.

HTH,
Rajesh

-----Original Message-----
Madan
Sent: Thursday, November 15, 2001 3:38 AM

To:     Multiple recipients of list ORACLE-L
Subject:        Import Help

Hi,

I have an export file from an 8.0.6 database which I need to import into an
8.1.7 db. However, the locations of the tablespaces are different in the 8.1.7 db.

How can do the import?

Any help will be appreciated.

Thanks

Sujatha
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sujatha Madan
INET: sujatha.madan_at_cmc.cwo.net.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------