Collections:
What Is a Directory Object in Oracle
What Is a Directory Object in Oracle?
✍: FYIcenter.com
A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples:
>sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> CREATE DIRECTORY test_dir AS '/oraclexe/test'; Directory created. SQL> GRANT READ ON DIRECTORY test_dir TO hr; Grant succeeded. SQL> GRANT WRITE ON DIRECTORY test_dir TO hr; Grant succeeded. SQL> CREATE DIRECTORY temp_dir AS '/oraclexe/temp'; Directory created. SQL> DROP DIRECTORY temp_dir; Directory dropped.
⇒ Define External Table in a Text File in Oracle
⇐ Restrictions on External Table Columns in Oracle
2016-10-15, 1476👍, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...