Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create range partition

807285Jan 8 2011 — edited Jan 8 2011
hi ,

Oracle 10.2.0.1.0
I'm getting error while creating a range partition to already existing table (method employed : partition swap method ) .
PF screen shot of error

SQL> ed
Wrote file afiedt.buf

  1  create table employee_details_temp partition by range (eid) (
  2  partition eid_1r values less than (1000)
  3  partition eid_2r values less than (20000)
  4  partition eid_3r values less than (40000)
  5  partition eid_3r values less than (maxvalue)
  6* )
SQL> /
partition eid_2r values less than (20000)
*
ERROR at line 3:
ORA-14020: this physical attribute may not be specified for a table partition
also ,
SQL> ed
Wrote file afiedt.buf

  1  create table employee_details_temp partition by range (eid) (
  2  partition eid_1r values less than (1000)
  3  partition eid_2r values less than (20000)
  4  partition eid_3r values less than (40000)
  5  partition eid_3r values less than (maxvalue)
  6  ) as select * from employee_details where 1=1;
  7* /
SQL> /
partition eid_2r values less than (20000)
*
ERROR at line 3:
ORA-14020: this physical attribute may not be specified for a table partition
please help .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2011
Added on Jan 8 2011
1 comment
140 views