Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling constraints - in order
Chris,
You may have tried this already, but there is an option of export which allows you to export without constraints. I don't know if this will help you or if you've tried it already - just thought I'd throw in my .02 worth.
Gilbert
On Mon, 1 Jun 1998 19:22:05 +0800, "Chris Kempster" <c.kempster_at_cowan.edu.au> wrote:
>Dear all,
>
>I have a big problem, I need to disable the pk and fk constraints of over
>300 tables of a very poorly documented system in the correct order as to not
>get errors, and then have a reverse script to rebuild them again.
>
>The problem I have is that we were given a blank 'boot' DB, with all the
>tables, triggers, constraints enables with minimal data. We need to dump
>'our' data from the current version of this boot DB (may have changes) the
>users have been on for some time now. They want to transfer select tables
>(most of them) over to the new (v1.2.2) boot DB.
>
>Unfortunately for me, a straight import/export, even with various imp/exp
>parameter configs is not working for me.
>
>Any ideas/example scripts I can use would be great.
>
>
>Chris.
>
>
Received on Tue Jun 09 1998 - 08:15:25 CDT