Month: February 2007
-
EXP-00003: no storage definition found for segment(#,#)
nnnnnVERY IMPORTANT!!!!!! EXP ERROR CauseThis problem during export has been introduced with the 9.2.0.5 patchset. In that patchset, a fix has been included for Bug 2948717 “Queries against DBA_SEGMENTS can be slow accessing BYTES/BLOCKS/EXTENTS columns”. Note that this fix has also been implemented in Oracle10g Release 1 (10.1.0.2.0). As a result of that fix, an…
-
Bind Variable Peeking
nnnnnHappy New Peek By Jaromir D.B. Nemec It is 6 A.M. of the New Years day, some DBA recapitulate the resolutions while others are already sleeping. In neither of those situations an alerting call is welcome. Though, exactly that happens. “Our nightly Oracle job is hanging, but nothing was changed!”, is the plain message. “Nothing…