When using dblink in Oracle 11.2.04, we get ORA-04052 error when we want to create an object with the query result from dblink.
To avoid this error, we need to run the following script before creating the object.
1 |
alter session set events '22824 trace name context forever, level 1'; |