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-14103: LOGGING/NOLOGGING may not be combined with
RECOVERABLE/UNRECOVERABLE



ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE..

Answer / guest

Cause: A statement contained both [NO]LOGGING and
[UN]RECOVERABLE clauses which is disallowed.

Action: Remove one of the offending clauses. [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

EXP-00077: multiple output files specified for unbounded export file

1 Answers  


ORA-29310: database is not open, or opened as a clone

1 Answers  


ORA-22294: cannot update a LOB opened in read-only mode

1 Answers  


ORA-15031: disk specification 'string' matches no disks

1 Answers  


KUP-03006: error initializing handle for character set string

1 Answers  


ORA-27157: OS post/wait facility removed

1 Answers  


NNL-00931: Requests refused, no cached meta-data: number

1 Answers  


ORA-07265: sppst: semop error, unable to increment semaphore.

1 Answers  


ORA-26527: local store callback init phase failed for 'string.string'

1 Answers  


DRG-12800: Attribute NESTED_TYPE must have owner name as prefix

1 Answers  


ORA-08231: smscre: unable to attach to SGA

1 Answers  


RMAN-06054: media recovery requesting unknown log: thread string seq string lowscn string

1 Answers  


Categories