Insert with Query hint Append Issues
Hello All,
Issue: Insert query with query hint append does not end
I have been working on this issue since 3 days
Query
Insert /*+ append */ into dest_tab select * from x.tab@remotedb
dest_tab is in nologging
The same query without the query hint does the job in say approx: 1 - 5 mins
The same query with rownum<=32000 ie : Insert /*+ append */ into dest_tab select * from user.tab@remotedb where rownum<=32000 works
Once i increase the rownum to <=33000 it remains stuck.
Thought is an index issue hence tried altering index to unusable before the insert statement but no change.
I have about 30-40 staging tables to be pumped in with data, all from remote tables.
I have been working on this issue since 3 days
Query
Insert /*+ append */ into dest_tab select * from x.tab@remotedb
dest_tab is in nologging
The same query without the query hint does the job in say approx: 1 - 5 mins
The same query with rownum<=32000 ie : Insert /*+ append */ into dest_tab select * from user.tab@remotedb where rownum<=32000 works
Once i increase the rownum to <=33000 it remains stuck.
Thought is an index issue hence tried altering index to unusable before the insert statement but no change.
I have about 30-40 staging tables to be pumped in with data, all from remote tables.
0