Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A Primary Key and Foreign key
be aware that in 7.3.4 when you diable a pk constraint the index gets dropped. When you re-enable the constraint, the index gets created in the default tablespace, not where you created it originally. Possible headache...
In article <365AD764.C8E6E1EF_at_us.oracle.com>,
Diego Pafumi <dpafumi_at_us.oracle.com> 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
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 04 1998 - 00:00:00 CST