Java EE (Java Enterprise Edition) General Discussion

Actually that was my mistake....
I specified the wrong clause.

oracle@NOBASE-oracle:~> imp system/manager@ora01 file=/home/oracle/FULL_EXP_BACKUP/imp_pipe log=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.log FROMUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS TOUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS

Import: Release 10.2.0.1.0 - Production on Wed Mar 4 22:22:10 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Cannot proceed from last 25 minutes

My /home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp.gz file is of 17G
Why is it so?

Please help

Edited by: user618704 on Mar 4, 2009 10:39 PM

Edited by: user618704 on Mar 4, 2009 10:41 PM

HI..

The file to be imported i suppose is FILE=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp.gz and when it will be unzipped the file name will be */home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp* until unless not altered.

SO,where does file=/home/oracle/FULL_EXP_BACKUP/imp_pipe comes from. Which file is imp_pipe.I think your imp command must be

oracle@globase-oracle:~> imp system/manager@ora01 file=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp log=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136_imp.log FROMUSER=GLOBASE,GBADM00301,GLOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS TOUSER=GLOBASE,GBADM00301,GLOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN feedback=100000 buffer=30000000 ignore=y


HTH
Anand

I used below script on new terminal and it works :)

mknod /home/oracle/FULL_EXP_BACKUP/imp_pipe p
gunzip < /home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp.gz > /home/oracle/FULL_EXP_BACKUP/imp_pipe &
imp system/manager@ora01 file=/home/oracle/FULL_EXP_BACKUP/imp_pipe log=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.log FROMUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS TOUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS


Thanks

Anand

This is compression on the fly in unix, You have to create a pipe and it will be redirected to write in a compressed format .Z or GZ where by the resultant dump will be in the compressed format at the end of export.

Similialy you have import using the same

Metalink 274109.1 has something for you

try deleting and recreate the pipe

Hey Maran,

Thanks a lot for the info... :) I haven't worked much on unix platform.But it was nice to know this.Just wanted to clarify that is it redirected automatically to write in a compressed format.

Thanks
Anand

This creates the pipe
This (>) redirects the output to FullDbexp_20090302_0136.dmp.gz file with gunzip

Best Regards
Maran