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

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
> 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!

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