Question:
I am getting this error while full export for one table daily
and export is terminated successfully with errors. No other table is
giving this error.
EXP-00056: ORACLE error 604 encountered
ORA-00604: error
occurred at recursive SQL level 2
ORA-01456: may not perform
insert/delete/update operation inside a READ ONLY transaction
ORA-06512: at line 3
Individual export of the same table is fine, but a FULL export
gives the ORA-01456 error.
What causes the ORA-01456 error in the export utility?
Answer: The export utility is a read-only transaction. This
smells like a bug. Check MOSC
first, searching for ORA-01456 and export.
You start by using the
oerr utility to see the content of the error:
ORA-01456: may not perform insert/delete/update operation inside a
READ ONLY transaction
Cause: A non-DDL insert/delete/update or select for update operation
was attempted
Action: commit (or rollback) transaction, and re-execute
The question is why Oracle thinks that your export job is not a
read-only transaction!
I would try this to resolve the ORA-01456 error:
-
Recompile
any invalid objects in the database.
-
Run the following as SYS to recompile all
invalid objects in the dictionary:
$ORACLE_HOME/rdbms/admin./utlrp.sql
-
Check
MOSC for known issues or bugs relating to the ORA-01456
error.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
