Re: Upgrade Oracle 9i to 10g from 4096 to 8192 db block size

I tried to exp/imp Create your 10.2.0.3 database with an 8k block size
and import your 9.2 data.

and during the imp i got these error mesgs:

ORA-29339: tablespace block size 4096 does not match configured block sizes

And

there are many roles, privs, username, tablespaces not created with the exp/imp. I already specified the exp/imp option with full=y

Below is my exp and imp script:

exp script --

nohup exp user/passwd buffer=5000000 log=fulexp.log file=exp_pipe full=y &

imp script --

nohup imp \'user/passwd AS SYSDBA\' full=y file=imp_pipe log=imp_fin1.log buffer=5000000 ignore=y &

any advise? thanks! Received on Fri Dec 05 2008 - 15:39:31 CST