Re: 9iR2 exp -> 10g imp
Date: Fri, 13 Jun 2008 00:54:10 +1000
Message-ID: <g2rdah$eeu$1@registered.motzarella.org>
Arch wrote,on my timestamp of 12/06/2008 11:43 PM:
>
> Excellent! This is a plan that I can follow.
NO! Don't just "follow"! Use it as a base to adapt for your own needs, but don't follow: it does NOT cover all possibilities, mainly your specific case!
> One question - to import schema by schema, I think the owners will
> need to be created in advance. Is there a way to import the owners
> (with passwords, profiles, roles, etc)?
Not that I know of. You might of course try to use the option to make imp full=y list all the statements it'd run without actually running anything (look it up, can't remember), then filter out the stuff you need with a judicious editing session and run the output as a script.
Another option is to investigate DBMS_METADATA.
There is an example in the 10g manual about
getting all granted ddl for good ole SCOTT:
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','SCOTT')
FROM DUAL;
This:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_metada.htm#BGBIEDIA
gives an idea what else you can get.
Nifty little package. I use it a lot. Received on Thu Jun 12 2008 - 09:54:10 CDT