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-00200: controlfile could not be created

1 Answers  


AMD-00151: Creation of Custom Measure "string" in Workspace "string" failed

1 Answers  


TNS-01415: Listening Endpoints Summary...

1 Answers  


SQL*Loader-00253: DB2 partition number has no significance -- ignored

1 Answers  


ORA-32055: invalid file type

1 Answers  


ORA-07270: spalck: setitimer error, unable to set interval timer.

1 Answers  


NNL-00857: Total rename processing time: string

1 Answers  


ORA-04093: references to columns of type LONG are not allowed in triggers

1 Answers  


RMAN-02003: unrecognized character: string

1 Answers  


ORA-00217: controlfile could not be resized for migration from 9.0.1

1 Answers  


ORA-09808: Could not obtain user clearance.

1 Answers  


ORA-13527: invalid baseline name

1 Answers  


Categories