Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: A Primary Key and Foreign key

Re: A Primary Key and Foreign key

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1998/11/28
Message-ID: <365ED4ED.85DE27F5@hk.super.net>#1/1

ALTER TABLE DISABLE CONSTRAINT ..... Diego Pafumi wrote:

> Hi gurus !!!
> I have a little question. I received an application without any
> specificaton. Actually I have to insert in many tables some data
> manually.
> So my question is: How can I "suspend" for a moment all the Primary Keys
> and Foreign Keys?? Also I'd like to know if there is any eay to create
> something like a "Data Model". I think that I have to disable all the PK
> and FK before to insert. Is that right?? Or I have to disable more
> things??
>
> Thanks in advance
>
> Diego

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer
Received on Sat Nov 28 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US