OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » EXPDP/IMPDP (10.2.0.5)

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

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 #650579 is a reply to message #650578]

Wed, 27 April 2016 22:34

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: EXPDP/IMPDP [message #650584 is a reply to message #650578]

Thu, 28 April 2016 00:51

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

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:34:18 CST 2025