OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Data Pump import

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

Data Pump import [message #229837]

Tue, 10 April 2007 02:45

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?

Report message to a moderator

Re: Data Pump import [message #229856 is a reply to message #229837]

Tue, 10 April 2007 03:19

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Data Pump import [message #229863 is a reply to message #229856]

Tue, 10 April 2007 03:30

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.

Report message to a moderator

Re: Data Pump import [message #229868 is a reply to message #229863]

Tue, 10 April 2007 03:42

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

Report message to a moderator

Re: Data Pump import [message #230043 is a reply to message #229868]

Tue, 10 April 2007 13:19

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	SQL*Loader input file directory and data file dynamic - ?
Next Topic:	File name validation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 02:08:15 CST 2024