Re: Import question

nilanjan_sarkar_at_hotmail.com (nilanjan) wrote in message news:<6c8b1f5.0308040938.364d8e0_at_posting.google.com>...
> FYI..The change I had to make is remove the "&" from the import
> command. ( not run in background). And it worked fine .
>
> uncompress > $DBEXPORT/temp_fifo_import_ipd.dmp <
> DBEXPORT/ipd_whse_export.dmp.Z &
>
> imp user/pass tables=tablename
> file=$DBEXPORT/temp_fifo_import_ipd.dmp fromuser=xxx touser=xyz
>
> Although the particular table import completed fine. The error
> "unexpected end of file" .. still shows up .. (the export file is fine
> though)
>
> Thanks for the responses and pointers !!!

Try doing a tail on what comes out of the pipe or uncompress. The last couple of lines should say the word EXIT on them. If they don't, you may have an export file truncated after the table you needed.

I think the fact that it worked by not putting it in the background means there is some sort of environment variable issue, which is the command export in the shell (or setenv in csh). Maybe you have something that resets things when you subshell?

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/mon/business/news_mz1b4smartho.html