Re: estimate progress of constraint creation?
- From: "Tim Gorman" <tim@xxxxxxxxx>
- To: landstander668@xxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2012 17:35:55 +0000
How about ENABLE NOVALIDATE and then create queries to validate them yourself?
-----Original Message-----
From: Adric Norris [mailto:landstander668@xxxxxxxxx]
Sent: Tuesday, January 24, 2012 10:31 AM
To: 'oracle-l'
Subject: estimate progress of constraint creation?
Anyone know a good way to estimate the overall progress of a
constraintcreation/validation? We're in the process of adding a number of NOT
NULLconstraints that were inadvertently dropped from a large partitioned
table(during a database migration), and the process is taking a *very*
longtime. The v$session_longops view isn't much help, because it simply
shows"Table Scan: (stale or locked) obj#134849" over and over...
presumablythese are the individual partition scans.Under normal circumstances
I'd create these constraints as DISABLENOVALIDATE, and then alter them with
RELY. Sadly, Oracle doesn't seem toallow the use of RELY with NOT NULL
constraints. :(At this point, I don't think there's any way to speed the
constraintcreation 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
