|
 |
|
ORA-14004: missing PARTITION keyword
Oracle Tips by Burleson Consulting |
Question on error "ORA-14004:
missing PARTITION keyword":
I have a question concerning ORA-14004: missing PARTITION keyword. Here's what I'm doing: alter table xx move
tablespace yy
but when I tested this solution I found that oracle 8.0.6 doesn't
support this DML request (alter .... move ......)
and this error message is being thrown in Oracle 8.0.6
SQL> alter table sami move tablespace
alter table sami move tablespace use
*
ERROR at line 1:
ORA-14004: missing PARTITION keyword
Answer by Edward
Stoever:
If this table is
partitioned then you will have to move each partition individually
...
alter table my_table move partition my_partition tablespace my_ts
/
As far as I know,
Oracle 8 does not support the "alter table
tablename move" command.
You can either
export the table and indexes, then drop it, then import it
or
upgrade the database.
Assuming you choose to export/import.... be sure to do this on a
test database a few times before trying it in production. You want
to make sure the indexes, triggers and constraints get rebuilt. There
may be an impact on other objects that depend on the table in
question. It is your responsibility to do the job properly, and that
includes testing it out enough times so that you are comfortable
with the results.
|
