Database Administration (MOSC)

MOSC Banner

Can't access a linked server from a job

Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

I have two databases on the same server db1 and db2.

I am using a link to insert data from db1 into a table in db2. This is being done from a stored procedure called PROC_DS_TEST_INSERT.

The syntax for the insert in this procedure is:

 Insert into DS_TESTDRIVES

Select * from DRIVES@DB1 where drive_date >= to_Date('2023-01-01','YYYY-MM-DD') and rownum <200;

The account (BECS_ANALYTICS) that I am running this under in DB2 has read permissions on DB1 and this ran correctly when I executed the stored procedure by hand, but when I ran a job that executed that procedure, it did not run, and I received an error message.

Tagged:

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