Re: PROBLEM : Compressed Export Import With Named Pipes !!

Hi Ashish,

... stuff deleted...

You used the system account to restore your table!? You might want to try the original user. You should never use sys or system.
I use an oracle-user with dba privs.
Per default the table should go to where it came from. If you don't want this, revoke priviliges.

Good luck,

Toni

> Thanks in advance. :))
> Ashish
>
> #!/bin/ksh
> ORACLE_SID=mydb;
> ORACLE_HOME=/opt/oracle/product/7.1.4;
> PATH=$PATH:$ORACLE_HOME/bin;
>
> exp_dir=/opt/oracle/admin/mydb/exp
>
> export FILE_NAME=$exp_dir/testexp
> mknod $FILE_NAME.dmp p
> uncompress <$FILE_NAME.dmp.Z> $FILE_NAME.dmp &
>
> imp system/blablabla \ #######################################
> BUFFER=10000 \
> FILE=$FILE_NAME.dmp \
> GRANTS=Y \
> INDEXES=Y \
> ROWS=Y \
> LOG=imp.log \
> TABLES=PS_ACT_ARCHIVE_MED
>
>
>
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |