Skip to Main Content

Database Software

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!

Partition XMLType column ORA-14020

202770Jun 16 2003 — edited Jun 17 2003
I am trying to range-partition a table that have an XMLType column. I would like to specify storage characteristics for this column for each partition. The documentation does not have examples on how to do this.

When I run create table statement I am getting
ORA-14020: this physical attribute may not be specified for a table partition

Example:
----------

sql> drop table xmltst
2 /
drop table xmltst
*
ERROR at line 1:
ORA-00942: table or view does not exist

sql> create table xmltst (
2 timestamp date default sysdate not null,
3 xmlinfo xmltype,
4 constraint pk_xmltst primary key (timestamp)
5 using index tablespace users
6 )
7 partition by range (timestamp) (
8 partition MAY2003 values less than (to_date('01-JUN-2003'))
9 tablespace users
10 xmltype column xmlinfo store as clob (tablespace users),
11 partition JUN2003 values less than (to_date('01-JUL-2003'))
12 tablespace users
13 xmltype column xmlinfo store as clob (tablespace users),
14 partition JUL2003 values less than (to_date('01-AUG-2003'))
15 tablespace users
16 xmltype column xmlinfo store as clob (tablespace users)
17 )
18 /
xmltype column xmlinfo store as clob (tablespace users),
*
ERROR at line 10:
ORA-14020: this physical attribute may not be specified for a table partition

Could you give me an example on how this can be done?

Regards,

Alexander Miroshnikov

Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit
Sun Solaris (SPARC) (64-bit) 5.8
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2003
Added on Jun 16 2003
6 comments
717 views