How to disabled all constraints when importing data (urgent)

From: paul sun <jsun_at_staffordbc.gov.uk>
Date: 8 Sep 2003 03:30:50 -0700
Message-ID: <78223844.0309080230.44633e6b_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:30:50 CEST

Original text of this message