Re: Oracle 10g database control export/import questions

zigzagdna_at_yahoo.com wrote:
> I am using Oracle 10.2.0.3 on HP UNIX 11i. I have created database
> control using dbca command in a database instance, e.g., db1. If I do
> full export of db1 and recreate the database using full import, do I
> need to rerun emca command. I know during full import/export Oracle
> does not create sys objects. Are db control's objects created from
> sys or using system?
>

DB Control's objects should be owned by SYSMAN in the database, so a full export will get these objects. You shouldn't have to run emca.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com