Home » RDBMS Server » Server Utilities » Importing full database from the exported backup  () 1 Vote
Importing full database from the exported backup [message #202944] Mon, 13 November 2006 07:01 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

I have exported etire database using FULL=Y.

1. Now, I want to import the dump into the same database. Do I need to drop all objects from all tables or just truncate will do.

2. What About system tablespace, do I need to drop/truncate all the objects here also???.

Regards,
Ronald.
Re: Importing full database from the exported backup [message #202945 is a reply to message #202944] Mon, 13 November 2006 07:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> into the same database
Why? did you loose some data?
>> Do I need to drop all objects from all tables or just truncate will do.
dropping is better.
If there are too many parent/child keys, you have truncate in particular order or run the truncate script multiple times.
>> What About system tablespace, do I need to drop/truncate all the objects here also???.
Do not even think about doing it. Just leave it as is.

Search forum!. There are about a zillion examples/pros & cons on this.
Regards

[Updated on: Mon, 13 November 2006 07:09]

Report message to a moderator

Re: Importing full database from the exported backup [message #203059 is a reply to message #202944] Mon, 13 November 2006 14:26 Go to previous messageGo to next message
gtcol
Messages: 5
Registered: October 2006
Junior Member

why worry about system ts? is it where you did the export from? it contains all of your system objects, so don't even touch that.
Re: Importing full database from the exported backup [message #203181 is a reply to message #202944] Tue, 14 November 2006 03:47 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

I'm doing this in testing server for testing purpose.

That means, I need to drop all objects except in system tablespace.

Last time when importing it did not import EXTERNAL TABLES which are stored in system tablespace.


Regards
Brian
Re: Importing full database from the exported backup [message #203215 is a reply to message #202944] Tue, 14 November 2006 06:20 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Since while exporting I've specified FULL=Y, it has exported objects of schema SYSTEM also..log attached.

Suppose if I do not truncate objects of SYSTEM, wont it duplicate the data..??

Please suggest.

Brian.
  • Attachment: devdwdb.log
    (Size: 199.12KB, Downloaded 851 times)
Re: Importing full database from the exported backup [message #203310 is a reply to message #202944] Tue, 14 November 2006 13:50 Go to previous messageGo to next message
gtcol
Messages: 5
Registered: October 2006
Junior Member

Since you've done export in Full=Y mode and you're doing the import into the same db, few things to consider:
1. Who will do the import and which is the default ts for the user doing the import?
2. If the importing user has the same ts, then be ready to face ora-00955. It won't duplicate objects.

thanx
gtcol
Re: Importing full database from the exported backup [message #203384 is a reply to message #202944] Wed, 15 November 2006 00:04 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi gtcol,

Since I have exported using full=Y, If I import using full=Y, I understand that while importing if the respective tablespaces are existing and the user objects are dropped , it will import to the respective schema and tablespace.

Brian.
Previous Topic: To avoid duplicate rows in oracle 8i
Next Topic: Data Pump good as it sound's ?
Goto Forum:
  


Current Time: Fri Dec 09 01:54:45 CST 2016

Total time taken to generate the page: 0.08526 seconds