Database Utilities (MOSC)

MOSC Banner

ORA-02069: global_names parameter must be set to TRUE for this operation, while using SQL loader via

edited May 3, 2013 3:47AM in Database Utilities (MOSC) 5 commentsAnswered ✓
 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: 

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