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.org


[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