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.
2016-10-15, 861👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...