View Single Post
  #1 (permalink)  
Old October 12th, 2004, 05:07 PM
combo combo is offline
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default (oracle 8i)Alter Table <table> coalesce partition

Hi all,
    Need assistance in solving a problem. I have a possibly large fragemented table. I tried to run a coalese command ALTER TABLE EMPTY_COPY COALESCE PARTITION
got an error: 'ora -14501 - object is not partitioned'

NOt sure how to proceed, I am working in oracle 8i environment.

Should I do :

ALTER TABLESPACE MY_DATA COALESCE
ALTER INDEX EMPTY_COPY_PK COALESCE
ALTER INDEX EMPTY_COPY_PK REBUILD
ALTER TABLE MY_DATA.EMPTY_COPY MOVE TABLESPACE NEW_DATA

Not sure if the syntax is correct or which to use, are there any redundancies in the commands above.

Thanks kindly for any input you may provide.