Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [SPAM] RE: Renaming a Tablespace in 8i & 9i
Online is definitely not the default. Try running DML heavy activity
and then try a rebuild w/o the 'online' keyword.....
-- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_il.proquest.com <mailto:mark.bobak_at_il.proquest.com> www.proquest.com <http://www.proquest.com> www.csa.com <http://www.csa.com> ProQuest...Start here. From: oracle-l-bounce_at_freelists.orgReceived on Wed Aug 29 2007 - 13:39:58 CDT
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Joel.Patterson_at_crowley.com Sent: Wednesday, August 29, 2007 1:31 PM To: sbecker6925_at_gmail.com Cc: godwin.ror_at_gmail.com; oracle-l_at_freelists.org Subject: [SPAM] RE: Renaming a Tablespace in 8i & 9i Importance: Low Isn't 'online' the default, or am I missing things? For two years I rebuilt indexes with alter index index_name rebuild tablespace new; left the online key work out. Joel Patterson Database Administrator joel.patterson_at_crowley.com x72546 904 727-2546 ________________________________ From: Sandra Becker [mailto:sbecker6925_at_gmail.com] Sent: Wednesday, August 29, 2007 1:29 PM To: Patterson, Joel Cc: godwin.ror_at_gmail.com; oracle-l_at_freelists.org Subject: Re: Renaming a Tablespace in 8i & 9i I've been fighting this issue for the past year with Standard One. You cannot build them online or in parallel. Tried it, always got "feature not enabled". Looked it up on Metalink--not a feature of Standard One. Sandy On 8/29/07, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com > wrote: I would double check that. I seem to remember rebuilding my indexes with Standard One regularly and without any issues. Joel Patterson Database Administrator joel.patterson_at_crowley.com x72546 904 727-2546 ________________________________ From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandra Becker
Sent: Wednesday, August 29, 2007 10:38 AM To: godwin.ror_at_gmail.com Cc: oracle-l_at_freelists.org Subject: Re: Renaming a Tablespace in 8i & 9i Everyone is assuming that you have Enterprise Edition. If you have Standard or Standard One, you cannot rebuild your indexes online or in parallel. These features are not available in those editions. Sandy On 8/27/07, Godwin vincent < godwin.ror_at_gmail.com <mailto:godwin.ror_at_gmail.com> > wrote: 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. -- http://www.freelists.org/webpage/oracle-l
![]() |
![]() |