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 ?

                                      

  

 

 

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:06:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.