How to create a private synonym for directory
414264Oct 23 2004 — edited Nov 4 2004Hi,
I have several different directories created.
What I need is to create a synonym for the directory object. For some reason it doesn't work. Please look at the log.
SQL> CREATE OR REPLACE DIRECTORY TEST_VPOOUTBOUND_QC AS '/thishost/proj/fast/chunk3/vpo/data'
Directory created.
SQL> create or replace synonym TEST_VPOOUTBOUND for TEST_VPOOUTBOUND_QC
Synonym created.
SQL> GRANT READ,WRITE ON DIRECTORY TEST_VPOOUTBOUND_QC TO CK3DV_SRC
Grant succeeded.
SQL> GRANT READ,WRITE ON DIRECTORY TEST_VPOOUTBOUND TO CK3DV_SRC
2 /
GRANT READ,WRITE ON DIRECTORY TEST_VPOOUTBOUND TO CK3DV_SRC
*
ERROR at line 1:
ORA-22930: directory does not exist