PROBLEM : Compressed Export Import With Named Pipes !!
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
exp_dir=/opt/oracle/admin/mydb/exp
export FILE_NAME=$exp_dir/testexp
ORACLE_SID=mydb;
ORACLE_HOME=/opt/oracle/product/7.1.4;
PATH=$PATH:$ORACLE_HOME/bin;
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
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Received on Mon Jul 15 1996 - 00:00:00 CEST
|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 ! :> |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++