How to import without ruin the constraints?

From: Katarina Amender <katta.klos_at_home.se>
Date: 18 Apr 2002 04:55:58 -0700
Message-ID: <df2d2fc9.0204180355.e23b7ea@posting.google.com>

Hi there!

I have a major problem!

I have created a copy of my database on the same server. Now I have a copy which contains all the tables, definitions, users, indexes and so on but no actual data. What I want to do now is to import the rows in all tables from an export dump.

How do I do an import to my new database without ruin the constraints? I have tried to use the following for import:

userid=aaa/111_at_test
file=c:\dumpfile.dmp
fromuser=scott
touser=scott
tables=(*)
rows=y
ignore=y

Can anyone tell me whats wrong??

Using 8.1.5 on NT4

regards// Katta Received on Thu Apr 18 2002 - 06:55:58 CDT