Database DataWarehousing (MOSC)

MOSC Banner

Partition

edited Dec 17, 2012 5:28AM in Database DataWarehousing (MOSC) 2 commentsAnswered ✓
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center