Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 27th, 2005, 12:48 AM
cherry1 cherry1 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2005
Posts: 15 cherry1 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 21 m
Reputation Power: 0
integrity constraint: DISABLE VALIDATE

in oracle 9i documentation i have read that DISABLE clause can be:
DISABLE NOVALIDATE (default. i understand vat it means) or
DISABLE VALIDATE:
disables the constraint and drops the index on the
constraint, but keeps the constraint valid. This feature is most useful in data warehousing situations, because it lets you load large amounts of data while also saving space by not having an index. All other modifications to the table (inserts, updates, and deletes) by other SQL statements are disallowed.

question1 if this means that data which violates the constraint is not allowed in the table, then vat is the difference between disable validate and an enabled constraint?
question2 is this only a 9i feature or is it available in oracle8 as well? because i dont find it in my oracle8 book (which we r following in school)

Reply With Quote
  #2  
Old April 27th, 2005, 04:19 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 7th Plane (8000 - 8499 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 8,073 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 4 Weeks 4 h 9 m 58 sec
Reputation Power: 281
In short:
Quote:
ENABLE ensures that all incoming data conforms to the constraint
DISABLE allows incoming data, regardless of whether it conforms to the
constraint
VALIDATE ensures that existing data conforms to the constraint
NOVALIDATE means that some existing data may not conform to the constraint
...
DISABLE VALIDATE disables the constraint, drops the index on the constraint,
and disallows any modification of the constrained columns.

Reply With Quote
  #3  
Old April 27th, 2005, 11:18 PM
cherry1 cherry1 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2005
Posts: 15 cherry1 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 21 m
Reputation Power: 0
Quote:
Originally Posted by cherry1
DISABLE VALIDATE:
disables the constraint and drops the index on the
constraint, but keeps the constraint valid.

question2 is this only a 9i feature or is it available in oracle8 as well? because i dont find it in my oracle8 book (which we r following in school)

im sorry i must be particularly dense coz i still dont get it. vat does it mean by keeping the constraint valid?
also, is this only a 9i feature?

Reply With Quote
  #4  
Old April 28th, 2005, 04:11 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 7th Plane (8000 - 8499 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 8,073 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 4 Weeks 4 h 9 m 58 sec
Reputation Power: 281
question 1:
Quote:
DISABLE VALIDATE disables the constraint, drops the index on the constraint,
and disallows any modification of the constrained columns.

It basically means that the index used to enforce the constraint is dropped and you can not modify the table data.
It's used to freeze the table for:
Quote:
For a UNIQUE constraint, the DISABLE VALIDATE state enables you to load data efficiently from a nonpartitioned table into a partitioned table using the EXCHANGE PARTITION option of the ALTER TABLE command.
as you can read here which is also an example of the official docs coming with Oracle.
question2:
No, the feature is available in 8i also.

Last edited by pabloj : April 28th, 2005 at 04:24 AM.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > integrity constraint: DISABLE VALIDATE


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT