OraFAQ Forum: Server Utilities » Tablespace refresh

Home » RDBMS Server » Server Utilities » Tablespace refresh (10g)

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

Tablespace refresh [message #524822]

Tue, 27 September 2011 02:16

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi,

I am trying to refresh tablespace containing indexes only.
Can you let me know whether i am on the right track.
Below is my query :

expdp directory=expdp DUMPFILE=user_index.dmp LOGFILE=user_index.log TABLESPACES=user_index

impdp directory=expdp dumpfile=user_index.dmp logfile=user_index_impdp.log tablespaces=user_index

Thanks in Advance

Report message to a moderator

Re: Tablespace refresh [message #524832 is a reply to message #524822]

Tue, 27 September 2011 02:41

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

Senior Member
Account Moderator

Does it work or no?

Regards
Michel

Report message to a moderator

Re: Tablespace refresh [message #524834 is a reply to message #524832]

Tue, 27 September 2011 02:42

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

Senior Member
Account Moderator

In addition, what is the purpose of this?

Regards
Michel

Report message to a moderator

Re: Tablespace refresh [message #524845 is a reply to message #524834]

Tue, 27 September 2011 03:50

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi,

It is for moving tablespace from prod to devl environment.

Thanks

Report message to a moderator

Re: Tablespace refresh [message #524855 is a reply to message #524845]

Tue, 27 September 2011 04:11

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

Senior Member
Account Moderator

Why do you try to move a tablespace and not the indexes themselves?
For indexes this is meaningless; do you think rowids will be the same ones on both databases?

Regards
Michel

Report message to a moderator

Previous Topic:	indexes parameters original imp
Next Topic:	How to update existing table using SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 21 01:30:31 CDT 2025