Import question

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 30 Jul 2003 13:06:24 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703F8D61E@lnewton.leeds.lfs.co.uk>

-----Original Message-----
From: nilanjan_sarkar_at_hotmail.com (nilanjan) [mailto:nilanjan_sarkar_at_hotmail.com]
Posted At: Wednesday, July 30, 2003 12:58 AM Posted To: server
Conversation: Import question
Subject: Import question

>> So here is what I am doing :

>> mkfifo $DBEXPORT/temp_fifo_import
>> uncompress > $DBEXPORT/temp_fifo_import < $DBEXPORT/big_export.dmp.Z
&
>> import user/pass tables=xyz file=$DBEXPORT/temp_fifo_import &

What is 'import' - oracle uses 'imp'.
I don't think you need the final '&' on your imp command line, run it in the foreground.

This is what I do for a full import, but you get the picture, obviously, the environment variables have been set up earlier in my script :

...
/usr/sbin/mknod $TO_USER.pipe p
gunzip -c $DUMP_FILE.dmp.gz > $TO_USER.pipe & imp $TO_USER/$TO_PASSWORD file=$TO_USER.pipe buffer=2048000 log=$TO_USER.log fromuser=$FROM_USER
touser=$TO_USER grants=no commit=yes ignore=yes ...

>> Pl let me know if you have used any of these similar methods to
import
>> and any resolution...

HTH Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Wed Jul 30 2003 - 07:06:24 CDT