|
-
What i am doing wrong with following script:
CREATE TABLE MYTABLE_PARTN ("COL1" CHAR(31), "COL2" CHAR(31), "COL3" CHAR(31))
partition by range (to_date(COL3,'dd-mon-yyyy'))
(
partition p1 values less than (to_date('28-jul-2004','dd-mon-yyyy')) tablespace my_data,
partition p2 values less than (to_date('29-jul-2004','dd-mon-yyyy')) tablespace my_data,
);
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|