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

[Message index]

		Tablespace refresh By: gir_sat on Tue, 27 September 2011 02:16
		Re: Tablespace refresh By: Michel Cadot on Tue, 27 September 2011 02:41
		Re: Tablespace refresh By: Michel Cadot on Tue, 27 September 2011 02:42
		Re: Tablespace refresh By: gir_sat on Tue, 27 September 2011 03:50
		Re: Tablespace refresh By: Michel Cadot on Tue, 27 September 2011 04:11

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: Thu Apr 25 19:25:36 CDT 2024