Re: A Primary Key and Foreign key

Hello Diego:

    You should reverse engineer your database first using a tool like ERwin. Then you can see what the relationships are (and what they are named). You will not want to remove primary keys. You can remove foreign keys with an "alter table x drop constraint y". There is no real reason to drop other kinds of constraints and if you do you may put bad data into your tables. After loading the data you can reinstate the constraints in Oracle or with your modeling tool. If load time is a problem you may want to drop table indexes before loading and recreate them afterwards.

Van

Diego Pafumi wrote in message <365AD764.C8E6E1EF_at_us.oracle.com>...
>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
>
Received on Tue Nov 24 1998 - 00:00:00 CST