Re: Upgrade Oracle 9i to 10g from 4096 to 8192 db block size
Date: Fri, 5 Dec 2008 13:55:37 -0800 (PST)
On Dec 5, 3:39 pm, Kaka <kaka...._at_gmail.com> wrote:
> I tried to exp/imp Create your 10.2.0.3 database with an 8k block
> 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
> 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!
I expected that you'd create your tablespaces BEFORE starting the import; do that, and specify ignore=y as an imp parameter and you shouldn't have these problems.
David Fitzjarrell Received on Fri Dec 05 2008 - 15:55:37 CST