Is it possible to access a file located in a subdirectory of the directory in an Oracle DIRECTORY?
-
In Oracle external tables access data stored on a file located in a directory, specified in the DDL of the table itself, using a SQL query.
-
Answer:
You COULD, but you SHOULD NOT. The COULD: You can set utl_file_dir system parameter to include the subdirectory, but this is firstly deprecated and also when using wildcards considered a security risk. The SHOULD: Just create a directory object for that subdirectory. If you're using external tables that probably won't happen that often.
Jure Kajzer at Quora Visit the source
Related Q & A:
- How to know if a file has 'access' monitor in linux?Best solution by Unix and Linux
- Is it possible to use a phone camera as a webcam?Best solution by Yahoo! Answers
- Is it possible to use a game controller as a mouse?Best solution by Yahoo! Answers
- Is it possible to do a live broadcast with a regular camera?Best solution by support.google.com
- Is it possible to have a chemical change without a physical change?Best solution by mcwdn.org
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.