PROBLEM : Compressed Export Import With Named Pipes !!

From: Ashish Trivedi <Ashish.Trivedi_at_medaphis.com>
Date: 1996/07/15
Message-ID: <31EB0283.7DE74F8D_at_medaphis.com>#1/1


Hi ! :)

Platform : RDBMS version 7.1.4 on Sun Solaris 2.4

We take full export of our production database every night. A little while ago the .dmp file reached the max size of the file permitted by the operating system and therefore we had to break down the export by tablespaces. Instead of 1 compressed file as we used to have, now we have 10 compressed files.

I read in some oracle magazine / faq or book that i could do a compressed export with the use of named pipes in unix, I tried it and it worked excellent !! I have a compressed dmp file with successful export.

THE PROBLEM :
The documentation said that I should do reverse of export for import trough named pipes. I wanted to test the import so I dropped a table from the database and tried importing it as per compressed import instructions. At the end of execution of the script it said that import successfully finished !! But UNFORTUNATELY when I went to database and did a describe on the table it says table does not exist. So like where did my table evaporate while getting imported ?? :)) Could someone please tell me what am i doing wrong while making selective import ?? or if selective import like this is possible at all with named pipes ?? I have enclosed the script below which I used for import.

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

|Ashish Trivedi, PeopleSoft DBA, Medaphis Corporation |
|2840 Cumberland Parkway, Atlanta, GA 30339 (O) 770 319 5288 |
|Ashish.Trivedi_at_medaphis.com http://web.medaphis.com |
|sare jahan se achcha hindusta humara ! :> |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Received on Mon Jul 15 1996 - 00:00:00 CEST

Original text of this message