No workarounds. You are violating one of the rules of partitioning. You will need to rebuild the
table and the indexes etc....
df2hp103 [IDST]: oerr ora 14060
14060, 00000, "data type or length of a table partitioning column may not be changed"
// *Cause: User issued ALTER TABLE statement attempting to modify
// data type and/or length of a column used to partition the
// table named in ALTER TABLE statement, which is illegal
// *Action: Avoid modifying data type and/or length of table
// partitioning column(s)
- Kirti
- A Joshi <ajoshi977_at_yahoo.com> wrote:
>
> Hi,
>
> I am getting this error ORA-14060 while modifying a column in partitioned table. The table is
> partitioned on that column. Is there a workaround or any other alternative. Thanks
>
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: kirtikumar_deshpande_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 15 2003 - 08:59:28 CDT
