Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a question - Is it possible to load data in pre-existing tables in target database(oracle) with - do nothing(if table exists) function with the same names as source database, as a note the target database has some pre-existing data already there.
Reason asking is when I try to do this I get:
Stream component 'st_1_TARGET' terminated
Stream component failed at subtask 1, component st_1_TARGET
Error executing data handler
Endpoint is disconnected
Direct Path error
ORA-00604: error occurred at recursive SQL level 1 ORA-01031: insufficient privileges
As for the missing permissions, I cannot seem to trace what its missing as Im running session trace and it does not pop any lacking permissions during stream.
Thanks!
@Aegis did you test with not using direct full path load?