Home » RDBMS Server » Server Administration » Issue in adding LIST partition in a table (10.2.0)
Issue in adding LIST partition in a table [message #433422] Wed, 02 December 2009 05:01 Go to next message
rawat_me
Messages: 45
Registered: September 2005
Member
Hi All,
I am adding an LIST partion in a existing table.

It is giving Error :
ORA-14020: this physical attribute may not be specified for a table partition

I am giving command as :

alter table tbl_trade add PARTITION XT LIST (archive_flag)
(PARTITION No_Archive VALUES ('N') TABLESPACE FICCTM18_DATA,
PARTITION Yes_Archive VALUES ('Y') TABLESPACE FICCTM18_ARCHIVE )

Re: Issue in adding LIST partition in a table [message #433439 is a reply to message #433422] Wed, 02 December 2009 05:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot add partitions to a non-partitioned table.
You cannot specify "PARTITION XT LIST (archive_flag)" on alter table.

Regards
Michel
Re: Issue in adding LIST partition in a table [message #433446 is a reply to message #433422] Wed, 02 December 2009 05:56 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
How to partition a non-partitioned table?

DBMS_REDEFINITION

sriram Smile

Previous Topic: Do not alter user's Trigger ?
Next Topic: Scope of privileges (and PLUSTRACE role) (merged)
Goto Forum:
  


Current Time: Sun Dec 11 04:16:04 CST 2016

Total time taken to generate the page: 0.04903 seconds