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

ORA-14319: DEFAULT cannot be specified with other values

1 Answers  


PLS-00570: different number of columns in the multiset and cast expressions

1 Answers  


ORA-07571: szrfc: $FIND_HELD failure

1 Answers  


ORA-22315: type "string" does not contain a map or order function

1 Answers  


NNL-00545: Displays query request statistics

1 Answers  






ORA-31509: publication does not exist

1 Answers  


ORA-12094: error during online redefinition

1 Answers  


RMAN-06031: could not translate database keyword

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


ORA-07401: sptrap: cannot restore user exception handlers.

1 Answers  


ORA-23337: priority or value not in priority group string

1 Answers  


ORA-27418: syntax error in repeat interval

1 Answers  


Categories