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.
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: 4642
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.
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.
Previous Topic: ORA-31684 with datapump for sequences
Next Topic: Date formatting in SQL Loader
Goto Forum:
  


Current Time: Thu Dec 08 08:07:35 CST 2016

Total time taken to generate the page: 0.14634 seconds