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
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
Action: commit (or rollback) transaction, and re-execute
The question is why Oracle thinks that your export job is not a
I would try this to resolve the ORA-01456 error:
any invalid objects in the database.
Run the following as SYS to recompile all
invalid objects in the dictionary:
MOSC for known issues or bugs relating to the ORA-01456
Get the Complete
Oracle SQL Tuning Information
The landmark book
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
for 30% off directly from the publisher.