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-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices



ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices..

Answer / guest

Cause: CREATE TABLE/INDEX statement used to create a
partitioned table/index contained RECOVERABLE or
UNRECOVERABLE clause which is illegal

Action: Remove offending clause. [UN]RECOVERABLE is being
deprecated in V8 and will be obsoleted in V9. To duplicate
semantics of UNRECOVERABLE clause, create an object with
NOLOGGING option and then ALTER it specifying LOGGING. To
duplicate semantics of RECOVERABLE clause, create an object
with LOGGING option.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02214: duplicate BACKUP option specification

1 Answers  


ORA-16953: Type of SQL statement not supported.

1 Answers  


ORA-13908: Invalid combination of metrics id and object type parameters.

1 Answers  


ORA-12204: TNS:received data refused from an application

1 Answers  


DRG-13000: error while adding or removing a sub lexer

1 Answers  


ORA-31001: Invalid resource handle or path name "string"

1 Answers  


ORA-30695: JDWP message format problem

1 Answers  


ORA-23600: cannot create PROPAGATION, string already exists

1 Answers  


ORA-39700: database must be opened with UPGRADE option

2 Answers  


SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)

2 Answers  


ORA-27043: unable to seek to beginning of file

1 Answers  


ORA-02852: Invalid critical-section time out value

1 Answers  


Categories