| Moving objects to a new tablespace [message #335654] |
Wed, 23 July 2008 02:51  |
saharookiedba
Messages: 56
Registered: September 2007
Location: PUNE
|
Member |
|
|
Hi,
I have created a new tablespace say X and assined all the users in system other than sys, to X.
now i have to move the objects under these users to X and rebuild the indexes..
i will move the tables unser these user using
ALTER TABLE <<table_name>> MOVE TABLESPACE <<tablespace_name>>
what should be done with objects like VIEWS, SYNONYMS, PROCEDURES.
|
|
|
|
|
|
|
|
| Re: Moving objects to a new tablespace [message #338012 is a reply to message #338011] |
Sat, 02 August 2008 05:37  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
| malikjee wrote on Sat, 02 August 2008 10:49 | Hi there!
When you move tablespace then all its object automatically move to new location mostly.
Regards,
Malik
|
Well for a start, the OP is not asking about 'moving a tablespace'
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
How we can move a tablespace?