Home » RDBMS Server » Server Utilities » Import of a dump from a full database export (Win2k,10.2.0.1)
Import of a dump from a full database export [message #378695] Wed, 31 December 2008 07:33 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Hello,

This is just for practice but I might be helpful.

I just did a full export of my database and I would like to know what are the actions to take in order to prepare the target database for the import. What I mean is, in the case of an import of schema, a user has to be created in the target database, and connect,and resource privileges have to be granted to that user.

What to do in case of a full database import? How to the prepare the target database?

Thanks in advance.

Report message to a moderator

Re: Import of a dump from a full database export [message #378697 is a reply to message #378695] Wed, 31 December 2008 08:08 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Just have an empty database.
You may want to precreate the tablespaces to prevent failures due to different filesystem as far as location and sizes.

Report message to a moderator

Re: Import of a dump from a full database export [message #379349 is a reply to message #378697] Tue, 06 January 2009 03:00 Go to previous message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
This is surely not a simple work to do. I'll try that on a test database. Thanks.

Report message to a moderator

Previous Topic: ORA-31684 with datapump for sequences
Next Topic: Date formatting in SQL Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 13:43:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.