CODEWITHSUNDEEP
oracle-databaseexternal-tables
lightkeeper
lightkeeper

Reputation: 339

External tables and directory objects

Is there any way to define the location an external table that is in a subdirectory of a named directory object? Or must an external table always be defined only pointing to a directory object? When I include the subdirectory in the LOCATION specification I get the following error:

KUP-04076: file name cannot contain a path specification: OBIEE/GLPA_FY13.csv

Upvotes: 1

Views: 240

Answers (1)

BobC
BobC

Reputation: 4426

No, it cannot be sub-directory.

Upvotes: 2

Related Questions