EXPDP/IMPDP [message #650578] |
Wed, 27 April 2016 21:34 |
|
manishdba007
Messages: 27 Registered: September 2014 Location: India
|
Junior Member |
|
|
Hi All,
I am doing a schema refresh . This schema contains some views and indexes. Now i have taken expdp backup of this schema and now i will import it into target .
These will be my steps on target -
1. Drop user with cascade;
2. Drop users's tablespace;
3. Create user and tablespace;
4. Give all privileges as before;
5. Initiate the import through IMPDP.
Now i want to know that IMPDP will import all views and indexes also as it was before right ? or do i have to create them manually ?
Regards
[Updated on: Wed, 27 April 2016 21:52] Report message to a moderator
|
|
|
|
|
Re: EXPDP/IMPDP [message #650585 is a reply to message #650578] |
Thu, 28 April 2016 00:51 |
martijn
Messages: 286 Registered: December 2006 Location: Netherlands
|
Senior Member |
|
|
manishdba007 wrote on Thu, 28 April 2016 04:34Hi All,
I am doing a schema refresh . This schema contains some views and indexes. Now i have taken expdp backup of this schema and now i will import it into target .
These will be my steps on target -
1. Drop user with cascade;
2. Drop users's tablespace;
This is probably not necessary. You just dropped all objects from the schema. If the only schema which has objects in this tablespace is just dropped, the tbs is empty. I other schema's also have objects in this tbs. you don't want to drop it.
Quote:
3. Create user and tablespace;
See 2.
Quote:
4. Give all privileges as before
5. Initiate the import through IMPDP.
Now i want to know that IMPDP will import all views and indexes also as it was before right ? or do i have to create them manually ?
Regards
|
|
|