Disclaimer
The views expressed here do not reflect the views of the company(ies) I work for (or have worked with) neither Oracle Corporation's. The opinions expressed by visitors on this blog are theirs. You are free to use this information but I am not responsible if you ever happen to suffer a loss/inconvenience/damage using it.Top Posts in the last 48 hours
Category Archives: Backup & Recovery
Benefits and consequences of the NOLOGGING option
I still find confusion out there about the LOGGING and NOLOGGING clauses when performing DML and DDL operations, the reality is that the NOLOGGING clause will work only on particular conditions, but all regular inserts,updates and deletes will still log … Continue reading
Posted in Backup & Recovery, Oracle Server, SQL
Tagged create table as select, ctas, Database, logging, nologging, ORA-26040, Oracle, recoverable
9 Comments
expdp error: 31623 and ORA-12805 in cluster 10.2.0.4
I was getting an error with expdp in our cluster 10.2.0.4 running on Red-Hat UDE-00008: operation generated ORACLE error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA-06512: at “SYS.DBMS_DATAPUMP”, line 2772 ORA-06512: at … Continue reading
Posted in Backup & Recovery, Linux/Unix, Oracle Server
Tagged 31623, cluster, expdp, ORA-12805
1 Comment