Re: Renaming a Tablespace in 8i & 9i
- From: "Godwin vincent" <godwin.ror@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 27 Aug 2007 16:37:44 -0400
Hi all,
I am working on renaming a tablespace. I am working on Oracle
versions 8i & 9i (HP-UX) and would like to request your help in this
regard. I have an idea as what process needs to be followed,
1. Create new tablespace
2. Move all objects in the old tablespace to the new tablespace
3. Drop the old tablespace.
The main step here is implementing the 2nd process, that is moving objects.
I have tables, indexes, and other objects stored in the same tablepsace
(USERS). Suppose, I want to rename the USERS tablespace to PERSONAL. How can
i move all the objects (tables, indexes, views, materialized views,
packages, procedures, etc) from the old tablespace to new tablespace? For
tables, we can issue "Alter table <table_name> move tablespace
<tablespace_name>" but how can i move all other objects like indexes, views,
etc.., which reside in this tablespace?
Any information will be of great help.
Thank you,
Godwin.
Other related posts:
