Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Is a Directory Object
What Is a Directory Object? - Oracle DBA FAQ - Loading and Exporting Data
✍: 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.
2007-04-30, 5381👍, 0💬
Popular Posts:
What is effort variance? Effort Variance = (Actual effort – Estimated Effort) / Estimated Effort.
What are some advantages and disadvantages of Java Sockets? Advantages of Java Sockets: Sockets are ...
What will happen in these three cases? if (a=0) { //somecode } if (a==0) { //do something } if (a===...
What are the different elements in Functions points? The different elements in function points are a...
What are the standard ways of parsing XML document? XML parser sits in between the XML document and ...