Home » RDBMS Server » Performance Tuning » re: Oracle 8.0.6 - alter table move
re: Oracle 8.0.6 - alter table move [message #65163] Wed, 26 May 2004 02:40 Go to next message
Raymond
Messages: 30
Registered: September 2000
Member
Hi friend , i have try alter table move to change my table extend but look like my client db did't not support this command

                  

ALTER TABLE TESTTB MOVE STORAGE (INITIAL1 0M)                

                          *                                    

ERROR at line 1:                                                

ORA-14004: missing PARTITION keyword                           

Is there any way so that we can minimal the downtime ?

                                      

  

 

 
Re: re: Oracle 8.0.6 - alter table move [message #65168 is a reply to message #65163] Wed, 26 May 2004 19:36 Go to previous message
Sujit Sarkar
Messages: 40
Registered: September 2003
Member
I think there is a problem with the syntax.

you are missing tablespace name in the command

You can try this out:

ALTER TABLE
MOVE TABLESPACE
STORAGE(........
........);

Thanx & Regards

Sujit
Previous Topic: DBMS_STATS.GATHER_TABLE_STATS
Next Topic: how to measure a database performance?
Goto Forum:
  


Current Time: Sun Sep 27 02:55:52 CDT 2020