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-08       - By genegurevich@(protected)

Reply:     1     2     3     4     5     6     7     8     9     10     >>  

Alfonso, what version of the database are you using? 9 or 10?

thank you

Gene Gurevich
Oracle Engineering
224-405-4079


                                                                         
            "Alfonso Le?n"                                                
            <aleon68@(protected)                                            
            m>                                                         To
                                      Mark.Bobak@(protected)          
            06/08/2006 04:35                                           cc
            PM                        "Alex Gorbachev"                    
                                      <gorbyx@(protected)>,                
                                      genegurevich@(protected),
                                      "Schultz, Charles"                  
                                      <sac@(protected)>, oracle-l      
                                      <oracle-l@(protected)>,          
                                      erichjenkinson@(protected)            
                                                                  Subject
                                      Re: disable pk works differently in
                                      oracle 9 and oracle 10?            
                                                                         
                                                                         
                                                                         
                                                                         
                                                                         
                                                                         




I create the primary key and let the database create the index, then
disable the primary key and the index was gone.

Then I drop the PK, create the unique index and create the PK with the
existing index. When I disable the PK the index remains.

So it is clear that if you create the index before the PK then the
index will be respected as a prior object and will not be dropped

On 6/8/06, Bobak, Mark <Mark.Bobak@(protected)> wrote:
> Yep, I checked for that.
>
>
> --
> 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
>
>
> -- --Original Message-- --
> From: Alex Gorbachev [mailto:gorbyx@(protected)]
> Sent: Thursday, June 08, 2006 3:46 PM
> To: genegurevich@(protected)
> Cc: Schultz, Charles; Bobak, Mark; oracle-l; erichjenkinson@(protected)
> Subject: Re: disable pk works differently in oracle 9 and oracle 10?
>
> Is index still valid after disabling constraint?
>
> 2006/6/8, genegurevich@(protected)
> <genegurevich@(protected)>:
> > Charles, Mark and Erich
> >
> > Thank you for your help.
> >
> > Charles, thanks for the reference to the 139666.1 note. My case is
> > close to the case 3, but not exactly because I build a unique index
> > (and in the Note the index built as a nonunique which makes a
> > difference according to Mark's Email).
> > so I have opened a SR with Oracle and will hope to get some definite
> > answer from them. Erich, my case seems to contradict the info you have
>
> > found in the  admin guide. So may be I have done something incorrectly
>
> > . I'll post whatever answer I will get from oracle
> >
> > thank you
> >
> > Gene Gurevich
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Best regards,
> Alex Gorbachev
>
> http://oracloid.blogspot.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


--
Alfonso Leon




--
http://www.freelists.org/webpage/oracle-l