imp with pipe and dd cmds

[venkat Rama]

 

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

Venkat

 

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software