Jared,
My database size is big i.e more than 150GB, so Iam using pipe(mknod) feed thru dd input and output to tape, same way Iam importing back thru tape as input and pipe as a file input to imp. So Iam geting no response..I hope you understood now!!
thanks
[EMAIL PROTECTED] wrote:
Perhaps you could include the export command line.
I'm having a difficult time understanding why you
would use dd with export.
Jared
venkat Rama <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]09/09/2003 05:49 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: imp with dd pipe
Hi Friends,
I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iam importing back with tables=mytable its just sitting there? with out any response. If I query os its showing its running..
Iam trying to import a particular table I did't see any response. My parfile options are
userid=u/p
tables=mytable
ignore=y
commit=y
buffer=4000000
indexes=n
I tried to change block_size for dd command, But some times it worked, some times not. I tried to import one row table giving block_size 32k, its imported!! But for mytable its big with 40Millon rows with avg row size 300bytes. But 0 block_size its gave error(pls remember I exported with bs=65536k) saying "read fail". Could you people suggest any ideas?
TIA
Peter.
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
