Menu
I created the following Oracle Directory csvDir:
create or replace directory csvDir as 'd:\oracle\oradata\external_data\downloadedFiles'; Now, how can I retrieve the path from this csvDir alias?
There should be some system table that stores this path.
905
An Oracle directory is a database object pointing to a operating system directory on the database server machine for reading and writing files.
From the Start menu, select All Programs, then Oracle - HOMENAME, then Oracle Installation Products, then Universal Installer. In the Welcome window, click Installed Products to display the Inventory dialog box. To check the installed contents, find the Oracle Database product in the list.
The data pump directory is used in the backup and restore process for the Oracle database. Connect to the Oracle database as the sysdba. Copy. cd $ORACLE_HOME/bin ./sqlplus '/ as sysdba' Change the directory location of the data pump files to your desired directory.
After you create a directory alias, grant users and groups access rights to the files contained in that directory, using the following PL/SQL syntax: GRANT permission ON DIRECTORY alias TO {user | role | PUBLIC};
That would be the ALL_DIRECTORIES view:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/statviews_1075.htm#i1576965
125
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
