Re: Import question

I do this all the time . I like to use parameter files and simple Bourne scripts. See below...

$ cat run_import_tables.sh
#!/bin/sh
#

rm -fr /tmp/named.pipe.for_import_tables
rm -fr run_imp.out1
rm -fr imp_tables.log

/etc/mknod /tmp/named.pipe.for_import_tables p

imp parfile=imp_tables.par > run_imp.out1 2>&1 &

uncompress -c < link_to_export_compressed_file > /tmp/named.pipe.for_import_tables

exit

.
.
.

$ cat imp_tables.par
userid=system/xxxxxxxx
file=/tmp/named.pipe.for_import_tables
show=n
ignore=y
grants=y
indexes=y
rows=y
log=imp_tables.log
destroy=n
full=n
fromuser=WHATEVER

touser=WHATEVER
tables=(MY_TABLE)
commit=y
buffer=2097152

-- 
"nilanjan" <nilanjan_sarkar_at_hotmail.com> wrote in message
news:6c8b1f5.0307291558.6dfcca82_at_posting.google.com...


> I am trying to import just one table from an export file which has the

> entire schema with a lot of other stuff, and since the file is big in

> size  more than the OS limit, it has been compressed. But I am running

> into an error trying to read from the unix pipe during import. The

> import waits for a while and then reports unexpected end-of-file.

>


> 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  &

>


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

> and any resolution...