1. To Create Oracle Directory

CREATE OR REPLACE DIRECTORY TMP_DIR AS ‘/tmp';
GRANT READ ON DIRECTORY TMP_DIR TO IDMOIM;
GRANT WRITE ON DIRECTORY TMP_DIR TO IDMOIM;
GRANT READ ON DIRECTORY TMP_DIR TO SYS;
GRANT WRITE ON DIRECTORY TMP_DIR TO SYS;

2. To verify

10g:

SELECT grantor, grantee, table_schema, table_name, privilege
FROM all_tab_privs
WHERE table_name = ‘TMP_DIR';

9i:

column directory_path format a30
SELECT * FROM DBA_DIRECTORIES;