Partition XMLType column ORA-14020
202770Jun 16 2003 — edited Jun 17 2003I 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