OraFAQ Forum: Server Utilities » schema import using impdp

Home » RDBMS Server » Server Utilities » schema import using impdp (11.2.0.3)

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

schema import using impdp [message #613285]

Fri, 02 May 2014 17:08

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
I have taken an export of schema CPP from my dev server using expdp.

Now i want to import CPP in test server where this schema does not exist.

Do i need to create schema first and assign it a tablespace in test server
before importing or Impdp itself will create schema and associated tablespace
as created in dev server?

Since name of schema is same,do i still need to use remap_schema?

Thanks,
Varun

[Updated on: Fri, 02 May 2014 17:29]

Report message to a moderator

Re: schema import using impdp [message #613286 is a reply to message #613285]

Fri, 02 May 2014 18:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Do i need to create schema first
yes

Some, many, most folks would actually test using a small "test" schema to observe what works & what throws errors.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Report message to a moderator

Re: schema import using impdp [message #613288 is a reply to message #613285]

Sat, 03 May 2014 00:36

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Impdp itself will create schema...

Yes.

Quote:

... and associated tablespace

No.

Quote:

Since name of schema is same,do i still need to use remap_schema?

No.

But better read the documentation and make test by yourself than just trust forum answers.

[Updated on: Sat, 03 May 2014 00:37]

Report message to a moderator

Re: schema import using impdp [message #613470 is a reply to message #613288]

Wed, 07 May 2014 07:58

Solomon Yakobson
Messages: 3303
Registered: January 2010
Location: Connecticut, USA

Senior Member

Also, if OP wants objects to be imported into different tablespaces, OP should use REMAP_TABLESPACE.

SY.

[Updated on: Wed, 07 May 2014 08:00]

Report message to a moderator

Previous Topic:	SQLLDR80 Insertion problem
Next Topic:	problem Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:39:39 CST 2025