why only sys user can read external table?
Hi team,
I have created external table under a user sirtest but only sys can read the external table.
Do you know how to fix that?
as user srtest:
select * from T1
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file test_in.csv in ORCL_SIR_INPUT not found
as user sys:
SQL> select * from sirtest.t1;
A B C
-------------------- -------------------- --------------------
10001 testrow helloworld
10002 testrow helloTaf
Thank You
Best regards