When you want to partition a table be careful about the datatype and length of tahat column, because you can not issue an ALTER command to modify it.
For example, when trying to change the partition column data type from data to timestamp, following error appears:
ALTER TABLE PARTITION_TABLE MODIFY (create_time TIMESTAMP)
Error report:
SQL Error: ORA-14060: data type or length of a table partitioning column may not be changed
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)
No comments:
Post a Comment