OraFAQ Forum: Server Utilities » Importing full database from the exported backup

Home » RDBMS Server » Server Utilities » Importing full database from the exported backup (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing full database from the exported backup [message #202944]

Mon, 13 November 2006 07:01

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.

Report message to a moderator

Re: Importing full database from the exported backup [message #202945 is a reply to message #202944]

Mon, 13 November 2006 07:05

Mahesh Rajendran
Messages: 10707
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

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.

Report message to a moderator

Re: Importing full database from the exported backup [message #203181 is a reply to message #202944]

Tue, 14 November 2006 03:47

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

Report message to a moderator

Re: Importing full database from the exported backup [message #203215 is a reply to message #202944]

Tue, 14 November 2006 06:20

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 1966 times)

Report message to a moderator

Re: Importing full database from the exported backup [message #203310 is a reply to message #202944]

Tue, 14 November 2006 13:50

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

Report message to a moderator

Re: Importing full database from the exported backup [message #203384 is a reply to message #202944]

Wed, 15 November 2006 00:04

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 20:42:17 CDT 2024