estimate progress of constraint creation?
- From: Adric Norris <landstander668@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2012 11:31:24 -0600
Anyone know a good way to estimate the overall progress of a constraint
creation/validation? We're in the process of adding a number of NOT NULL
constraints that were inadvertently dropped from a large partitioned table
(during a database migration), and the process is taking a *very* long
time. The v$session_longops view isn't much help, because it simply shows
"Table Scan: (stale or locked) obj#134849" over and over... presumably
these are the individual partition scans.
Under normal circumstances I'd create these constraints as DISABLE
NOVALIDATE, and then alter them with RELY. Sadly, Oracle doesn't seem to
allow the use of RELY with NOT NULL constraints. :(
At this point, I don't think there's any way to speed the constraint
creation up. Learning of a way to estimate the percentage complete,
however, would make me very happy. Any suggestions?
Thanx!
--
"I'm too sexy for my code." -Awk Sed Fred
--
//www.freelists.org/webpage/oracle-l
Other related posts:
