Re: 9iR2 exp -> 10g imp

From: Noons <>
Date: Fri, 13 Jun 2008 00:54:10 +1000
Message-ID: <g2rdah$eeu$>

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

Original text of this message