ORA-14085: partitioned table cannot have column with LONG
datatype



ORA-14085: partitioned table cannot have column with LONG datatype..

Answer / guest

Cause: User tried to create a partitioned table with a LONG
datatype or tried to add a LONG datatype column to a
partitioned table.

Action: LONG data types are not supported with partitioned
tables. Create table without LONG column or change table to
not partitioned. If adding column, do not use LONG datatype.
If modifying attributes of a column to change data type to
LONG, it has to be a non partitioned table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19208: parameter string of function string must be aliased

1 Answers  


ORA-25464: ROWID not specified for table alias: string

1 Answers  


ORA-14619: resulting List subpartition(s) must contain at least 1 value

1 Answers  


ORA-06743: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-01224: group number in header string does not match GROUP string

1 Answers  






QSM-02129: join or filter condition(s) are complex

1 Answers  


SQL*Loader-00123: specified value for bindsize(number) less than readsize(number)

1 Answers  


ORA-02422: missing or invalid schema element

1 Answers  


TNS-12612: TNS:connection is busy

1 Answers  


NNL-00344: Save_config_on_stop is currently ON

1 Answers  


ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.

1 Answers  


ORA-04065: not executed, altered or dropped string

1 Answers  


Categories