Oracle Database Appliance (MOSC)

MOSC Banner

Discussions

ODA file system access for external tables

edited Mar 28, 2014 3:20PM in Oracle Database Appliance (MOSC) 8 commentsAnswered ✓

I currently use Oracle Directories to read formatted files into external tables and log trace code from PL/SQL packages. I map a drive letter on my PC to a Linux directory on the database server where I can write and read files. I use 11g Enterprise Edition Release 11.2.0.3.0 on a Linux server.

As part of our migration to Oracle Database Appliance, my DBA (under guidance from a consultant) says that Oracle Directories are no longer recommended when using ODA. Due to restricted storage space in ODA, our DBA will not provide me with network access to a directory on the database server and will not map an Oracle Directory to a location on a network Windows file server. The complete justification I have been given for this change is: "

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center