Is there a easy way to import the full database without messing up the sys/system schema ? I can export all the scema users and the non schema users except for all system users and then do a full import to 10G. This way I will not have to create all the DB users with proper privileges.
Just wondering if there is any other better way. This is asmall db and I don't want to do the 9i - 10G upgrade
No where did you mention that you were changing platforms. In that case, I'd setup my db, create the users & roles, assign system privs and roles, create public objects, and import on a schema by schema basis.
I'm not a big fan of imp. Even less of a fan of imp full=y.
Since oracle full database exp/imp don't exp/imp sys objects and any grants related with sys objects. So some objects may be invalid after import. just get these missinh grants from source and add it to target manualy.