Oracle DB Error ORA-23502 valid directory for offline instantiation is not specified

Oracle DB Error ORA-23502 valid directory for offline instantiation is not specified

The following is the cause of this error:

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

Action you can take to resolve this issue: There are two ways to specify the directory:

* As a parameter OFFLINE_DIRPATH to the API
* As an initialization parameter named UTL_FILE_DIR

Make sure you have specified an appropriate directory in which the offline file can be created.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution