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.




Reply With Quote