Home » RDBMS Server » Server Utilities » EXPDP/IMPDP (10.2.0.5)
EXPDP/IMPDP [message #650578] Wed, 27 April 2016 21:34 Go to next message
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 #650579 is a reply to message #650578] Wed, 27 April 2016 22:34 Go to previous messageGo to next message
BlackSwan
Messages: 26719
Registered: January 2009
Location: SoCal
Senior Member
users & tablespaces have NO inherent relationship to each other.
A User can have objects in multiple tablespaces.
A tablespace can contain objects from 1 or more users.

>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 ?
in my opinion impdp is a manual operation.

what do you observe after completing the impdp?
Re: EXPDP/IMPDP [message #650584 is a reply to message #650578] Thu, 28 April 2016 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67223
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just do point 1 (only if what you import has nothing to do with what is the current user) and point 5.

[Updated on: Thu, 28 April 2016 00:54]

Report message to a moderator

Re: EXPDP/IMPDP [message #650585 is a reply to message #650578] Thu, 28 April 2016 00:51 Go to previous message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
manishdba007 wrote on Thu, 28 April 2016 04:34
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;

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

Previous Topic: Dul - Data Unloader
Next Topic: Inputs to SQL Loader
Goto Forum:
  


Current Time: Thu Jul 02 16:08:33 CDT 2020