schema import using impdp [message #613285] |
Fri, 02 May 2014 17:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #613288 is a reply to message #613285] |
Sat, 03 May 2014 00:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|
|