Add IGNORE=Y into imp statement
JP
On Tuesday 10 December 2002 10:58, you wrote:
Hi all,
I have dump files (1 table 1 dump file, dump filename is tablename)
How to create imp scripts that will import all those dump files without any
referential problem
Something like this:
select 'imp
Most likely, you will have to run the imports to get the data and the
primary keys. Then run them again with ignore=y and rows=n to get the
foreign keys.
My problem is with referential
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL
I think the logic is wrong.
You could build the fact table first and then add lookup tables and the
constraints.
You have to know your data and order it by hand.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December
Maybe you can do this:
1) imp index=n constraint=n
2) imp ignore=y rows=no
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 11:58 AM
Hi all,
I have dump files (1 table 1 dump file, dump filename is
:
.net.il Subject: Re: imp table by table
Sent by:
root@fatcity