| Creating INDEX on a particular Partition of a table [message #52990] |
Thu, 22 August 2002 23:16  |
sivakumar.K
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
There is a table called as Hours_Archive which holds 5 years of archived data.
It is range partitioned on a column called Archive_Year (1998,1999,2000,2001,2002).
Data belonging to Archive_Year=2002 is the most used.
Is it possible to create index on Archive_Year only for this partition only ?
|
|
|
|
| Re: Creating INDEX on a particular Partition of a table [message #53004 is a reply to message #52990] |
Fri, 23 August 2002 06:49  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
NO.
It was a VERY interesting question so I went ahead and did a small test. I have partitioned tables so I was indeed very curious.
Created a partitioned table with year as partition (range). Then I did
create index y2002_idx1 on archive_year partition (y2002) (archive_year)
which gave me error 14052
ORA-14052: partition-extended table name syntax is disallowed in this context
ORA 14502 is
% oerr ora 14052
14052, 00000, "partition-extended table name syntax is disallowed in this context"
// *Cause: User attempted to use partition-extended table name syntax
// in illegal context (i.e. not in FROM-clause or INSERT, DELETE,
// or UPDATE statement)
// *Action: Avoid use of partition-extended table name in contexts other
// those mentioned above.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
