OraFAQ Forum: Server Administration » Tables need to move from one Tablespace to another

Home » RDBMS Server » Server Administration » Tables need to move from one Tablespace to another (11g, 11.2.0.1, windows server2008)

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

Tables need to move from one Tablespace to another [message #602387]

Tue, 03 December 2013 23:19

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Dear All,

Developer user has create some tables and assigned them to USERS tablespace. Now, we need to move it to its respective owners's tablespaces.

Kindly provide me the steps to change tablespace. Also let me know what are all do I need to execute (like rebuilt indexes etc).

Waiting for your kind response...

Regards,
Ishika

Report message to a moderator

[Message index]

		Tables need to move from one Tablespace to another By: ishika_20 on Tue, 03 December 2013 23:19
		Re: Tables need to move from one Tablespace to another By: ishika_20 on Tue, 03 December 2013 23:24
		Re: Tables need to move from one Tablespace to another By: BlackSwan on Tue, 03 December 2013 23:34
		Re: Tables need to move from one Tablespace to another By: John Watson on Wed, 04 December 2013 01:13
		Re: Tables need to move from one Tablespace to another By: ishika_20 on Wed, 04 December 2013 01:35

Previous Topic:	Quota assigned to user
Next Topic:	How to use Oracle Swap (Extended Buffer Cache Support)?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:16:48 CDT 2024