Re: estimate progress of constraint creation?
Date: Tue, 24 Jan 2012 17:35:55 +0000
Message-ID: <W2647226469224041327426555_at_webmail101>
How about ENABLE NOVALIDATE and then create queries to validate them yourself?
-----Original Message-----
From: Adric Norris [mailto:landstander668_at_gmail.com]
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--http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 24 2012 - 11:35:55 CST