Home » RDBMS Server » Server Utilities » schema import using impdp (11.2.0.3)
icon4.gif  schema import using impdp [message #613285] Fri, 02 May 2014 17:08 Go to next message
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 Go to previous messageGo to next message
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/
Re: schema import using impdp [message #613288 is a reply to message #613285] Sat, 03 May 2014 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
Solomon Yakobson
Messages: 3267
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:
  


Current Time: Tue Mar 19 01:51:07 CDT 2024