ORA-23502: valid directory for offline instatiation is not
specified



ORA-23502: valid directory for offline instatiation is not specified..

Answer / guest

Cause: An attempt was made to offline instantiate to a
directory which is not specified or null.

Action: There are two ways to specify the directory: o As a
parm offline_dirpath to the API o As an init.ora parm named
utl_file_dir Make sure you have specified an appropriate
directory in which the offline file can be created.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-03028: fatal error code for command string : number

1 Answers  


ORA-36958: (XSFCAST26) The OFFSET value for cycle number cannot be greater than the cycle's PERIODICITY, which is number. You specified number.

1 Answers  


ORA-16612: string value too long for attribute "string"

1 Answers  


PROT-00013: Oracle Cluster Registry is in current version

1 Answers  


RMAN-06402: Oracle instance shut down

1 Answers  






PLS-00150: found: string but expected : INTEGER

1 Answers  


PCC-01501: Your Pro*Ada authorization is about to expire

1 Answers  


KUP-11002: unable to read data chunk string

1 Answers  


PCB-00231: Host and indicator variables may not have the same name.

1 Answers  


ORA-14007: missing LESS keyword

1 Answers  


SQL*Loader-00653: XML data set to NULL in column string, row number, table string

1 Answers  


ORA-01634: rollback segment number 'string' is about to go offline

1 Answers  


Categories