ORA-02069: global_names parameter must be set to TRUE for this operation, while using SQL loader via
Hello Experts,
I have staging table: CUSTOM_STAGING_TABLE in my staging database.
I have a view create in oracle apps schema like:
CREATE VIEW CUSTOM_STAGING_TABLE AS select * from stg_user.CUSTOM_STAGING_TABLE @DB_LINK;
I have a concurrent program which calls a SQL Loader script that inserts data into this view: CUSTOM_STAGING_TABLE . Earlier I was using a synonym in apps schema but I was getting the following error, changing the synonym to view resolved the below error.
SQL*Loader-606: Object CUSTOM_STAGING_TABLE in INTO TABLE clause is not a local table
But now I am getting another error:
0