We have moved to a new website!

If you are not redirected within 3 seconds, click here to go my homepage.

DIRECTORY Objects in plsql

ALL_DIRECTORIES (OWNER, DIRECTORY_NAME, DIRECTORY_PATH)
This view describes all directories accessible to the user.

SELECT * FROM ALL_DIRECTORIES;

DBA_DIRECTORIES(OWNER, DIRECTORY_NAME, DIRECTORY_PATH)
This view describes all directories specified for the entire database.

SELECT * FROM DBA_DIRECTORIES;
References

Oracle Doc


Read More