Home » RDBMS Server » Server Utilities » Tablespace refresh (10g)
Tablespace refresh [message #524822] Tue, 27 September 2011 02:16 Go to next message
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
Re: Tablespace refresh [message #524832 is a reply to message #524822] Tue, 27 September 2011 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does it work or no?

Regards
Michel
Re: Tablespace refresh [message #524834 is a reply to message #524832] Tue, 27 September 2011 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, what is the purpose of this?

Regards
Michel
Re: Tablespace refresh [message #524845 is a reply to message #524834] Tue, 27 September 2011 03:50 Go to previous messageGo to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

It is for moving tablespace from prod to devl environment.

Thanks
Re: Tablespace refresh [message #524855 is a reply to message #524845] Tue, 27 September 2011 04:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: indexes parameters original imp
Next Topic: How to update existing table using SQL Loader
Goto Forum:
  


Current Time: Thu Mar 28 16:17:02 CDT 2024