Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Modify table
Don't forget to rebuild the indexes. They will be invalid after a move.
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick
Sent: Tuesday, August 31, 2004 10:37 AM
To: oracle-l_at_freelists.org
Subject: RE: Modify table
Alter table move.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Jaehne, Richard S [mailto:JaehneRS_at_state.gov]
Sent: Tuesday, August 31, 2004 10:22 AM
To: 'Oracle-L (E-mail)
Subject: Modify table
All,
I'm running Oracle 8i on Solaris 8. I've got a table with some =3D
parameters that are really out of bounds (max_extents are HUGE). I know =
=3D
it's possible to reallocate on the fly w/ 9i, is it possible to =3D
reallocate in 8i as well? I'd like to redo this table w/out having to =
=3D
drop and recreate.
Thanks,=3D20
R. Jaehne
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |