Database Administration (MOSC)

MOSC Banner

why only sys user can read external table?

edited May 25, 2021 8:58AM in Database Administration (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center