Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-09982: skxfqddrg: Error Removing a page from the SDI buffer pool

1 Answers  


ORA-22878: duplicate LOB partition or subpartition specified

1 Answers  


ORA-22864: cannot ALTER or DROP LOB indexes

1 Answers  


ORA-29311: export dump file was not generated by this database, string does not match

1 Answers  


ORA-38762: thread string redo log with scn string could not be found

1 Answers  


ORA-22854: invalid option for LOB storage index

1 Answers  


ORA-36341: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)

1 Answers  


ORA-23438: missing refresh group template

1 Answers  


PCC-02201: Found syntax error

1 Answers  


QSM-02096: mv references a named view

1 Answers  


ORA-01350: must specify a tablespace name

1 Answers  


ORA-29509: incorrectly formed Java binary class definition

1 Answers  


Categories