How to disabled all constraints when importing data (urgent)

From: Paul <jiacheng_work_at_yahoo.com>
Date: 8 Sep 2003 03:23:17 -0700
Message-ID: <f294310c.0309080223.62b22c2a_at_posting.google.com>


Hi:

I am not sure whether somebody can sort it out for me.

I am doing data transfer from one oracle database to another. Both of them has the same structure (like same tables etc).the only thing i need to do is data transfering.

i designed a vb program to do this, What i am worrying is when I run this program it might fire some constrants. Anybody can give me some ideas on how to avoid these constraints when data import?? I have to disable all the constrainsts first or i can do it in another way?

Millions thanks in advance!
Paul Received on Mon Sep 08 2003 - 12:23:17 CEST

Original text of this message