Partition
Hello,version oracle 10g.
I need to partitionar a table, I have this script:
for example I have a table:
TableTest (This table hasn't partitions.
create table TableTes(
campo1,
campo2);
PARTITION BY RANGE (CAMPO2)
(PARTITION P1 VALUES LESS THAN (TO_DATE('01/04/2012', 'DD/MM/YYYY')) TABLESPACE TB00);
But I show a message table exist.
I try other way:
ALTER TABLE TableTest
ADD
PARTITION BY RANGE (CAMPO2)
(PARTITION P1 VALUES LESS THAN (TO_DATE('01/04/2012', 'DD/MM/YYYY')) TABLESPACE TB00);
But with this script I show me a message: invalid identificator.
I dont know who is the correct script.
I need to partitionar a table, I have this script:
for example I have a table:
TableTest (This table hasn't partitions.
create table TableTes(
campo1,
campo2);
PARTITION BY RANGE (CAMPO2)
(PARTITION P1 VALUES LESS THAN (TO_DATE('01/04/2012', 'DD/MM/YYYY')) TABLESPACE TB00);
But I show a message table exist.
I try other way:
ALTER TABLE TableTest
ADD
PARTITION BY RANGE (CAMPO2)
(PARTITION P1 VALUES LESS THAN (TO_DATE('01/04/2012', 'DD/MM/YYYY')) TABLESPACE TB00);
But with this script I show me a message: invalid identificator.
I dont know who is the correct script.
0