.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
disable pk works differently in oracle 9 and oracle 10?

disable pk works differently in oracle 9 and oracle 10?

2006-06-09       - By Bobak, Mark
Reply:     <<     11     12     13     14     15     16  




__ ____ ____ ____ ____ ____ ____

>From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Connor McDonald
>Sent: Friday, June 09, 2006 12:59 AM
>To: gogala@(protected)
>Cc: genegurevich@(protected); oracle-l
>Subject: Re: disable pk works differently in oracle 9 and oracle 10?




> I have to admit I like the new default...now if only I could set a
unique index to unusable I'd be a happy camper




Connor, you may not be able to mark a unique index unusable, but you can
get around that by making the index non-unique.  I've used this
technique before.

Create non-unique index, add unique constraint (which will utilize
non-unique index), then, when I want to, I can disable constraint, mark
index unusable, do data load, rebuild index nologging, and enable
constraint.


--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled.  --Richard P. Feynman, 1918-1988



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2></FONT>&nbsp;</DIV><FONT face=Arial
color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><FONT size=2><B><SPAN
class=546244514-09062006>&gt;</SPAN>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Connor
McDonald<BR><SPAN class=546244514-09062006>&gt;</SPAN><STRONG>Sent:</STRONG>
Friday, June 09, 2006 12:59 AM<BR><SPAN
class=546244514-09062006>&gt;</SPAN><STRONG>To:</STRONG>
gogala@(protected)<BR><SPAN
class=546244514-09062006>&gt;</SPAN><STRONG>Cc:</STRONG>
genegurevich@(protected); oracle-l<BR><SPAN
class=546244514-09062006>&gt;</SPAN><STRONG>Subject:</STRONG> Re: disable pk
works differently in oracle 9 and oracle 10?<BR></FONT></FONT><BR></DIV>
<DIV></DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial
color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><BR>
<DIV><SPAN class=546244514-09062006><FONT face=Arial color=#0000ff
size=2>&nbsp;&gt;&nbsp;</FONT></SPAN>I have to admit I like the new
default...now if only I could set a unique index to unusable I'd be a happy
camper<BR clear=all><BR></DIV>
<DIV><SPAN class=546244514-09062006><SPAN class=546244514-09062006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN>&nbsp;</DIV>
<DIV><SPAN class=546244514-09062006><SPAN class=546244514-09062006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN>&nbsp;</DIV>
<DIV><SPAN class=546244514-09062006><SPAN class=546244514-09062006><FONT
face=Arial color=#0000ff size=2>Connor, you may not be able to mark a unique
index unusable, but you can get around that by making the index
non-unique.&nbsp; I've used this technique before.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=546244514-09062006><SPAN class=546244514-09062006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN>&nbsp;</DIV>
<DIV><SPAN class=546244514-09062006><SPAN class=546244514-09062006><FONT
face=Arial color=#0000ff size=2>Create non-unique index, add unique constraint
(which will utilize non-unique index), then, when I want to, I can disable
constraint, mark index unusable, do data load, rebuild index nologging, and
enable constraint.</FONT></SPAN></DIV>
<DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT>&nbsp;</DIV><!-- Converted
from text/rtf format -->
<P><B><FONT face="Century Gothic" size=2>--</FONT></B> <BR><B><FONT
face="Century Gothic" size=2>Mark J. Bobak</FONT></B> <BR><B><FONT
face="Century Gothic" size=2>Senior Oracle Architect</FONT></B> <BR><B><FONT
face="Century Gothic" color=#000000 size=2>P</FONT><FONT face="Century Gothic"
size=2>ro</FONT><FONT face="Century Gothic" color=#ff0000 size=2>Q</FONT><FONT
face="Century Gothic" size=2>uest Information &amp; Learning</FONT></B> </P>
<P><FONT face="Courier New" size=2>For a successful technology, reality must
take precedence over public relations, for Nature cannot be fooled.&nbsp;
--Richard P. Feynman, 1918-1988</FONT></P>&nbsp;</SPAN></DIV></BODY></HTML>