Forum Stats

  • 3,813,695 Users
  • 513,246 Discussions
  • 1,634,780 Comments

Discussions

ODA file system access for external tables

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

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: "Oracle Database Appliances have some restrictions. Using external tables and mapping  Windows shares on ODA is not recommended." 

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