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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
