OraFAQ Forum: Server Administration » Issue in adding LIST partition in a table

Home » RDBMS Server » Server Administration » Issue in adding LIST partition in a table (10.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue in adding LIST partition in a table [message #433422]

Wed, 02 December 2009 05:01

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 )

Report message to a moderator

Re: Issue in adding LIST partition in a table [message #433439 is a reply to message #433422]

Wed, 02 December 2009 05:39

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Issue in adding LIST partition in a table [message #433446 is a reply to message #433422]

Wed, 02 December 2009 05:56

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

How to partition a non-partitioned table?

DBMS_REDEFINITION

sriram Smile

Smile

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 07:01:20 CST 2025