Home » RDBMS Server » Server Utilities » Data Pump import
Data Pump import [message #229837] Tue, 10 April 2007 02:45 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
I am using Data Pump to perform export/import in the tablespace mode.
I have created the tablespace in the target database. Do we have to precreate the users in the target database before we perform the import?
Re: Data Pump import [message #229856 is a reply to message #229837] Tue, 10 April 2007 03:19 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, no - import will create all users.

But you'd perhaps better wait for a DBA to answer your question.
Re: Data Pump import [message #229863 is a reply to message #229856] Tue, 10 April 2007 03:30 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
I just tried the import. But it complained saying the user does not exist. So we might have to pre-create the users.
Re: Data Pump import [message #229868 is a reply to message #229863] Tue, 10 April 2007 03:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You have to create user first. after you can import.
check below link for more information

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1004941


regards
Taj
Re: Data Pump import [message #230043 is a reply to message #229868] Tue, 10 April 2007 13:19 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right ... I told you to wait for a DBA Smile

I apologize; I should have checked it first and then reply to your question.
Previous Topic: SQL*Loader input file directory and data file dynamic - ?
Next Topic: File name validation
Goto Forum:
  


Current Time: Thu Dec 08 14:19:08 CST 2016

Total time taken to generate the page: 0.09766 seconds