Re: Oracle 10g database control export/import questions

On Tue, 23 Oct 2007 11:12:45 -0700, zigzagdna_at_yahoo.com wrote:

>On Oct 23, 10:33 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
>> zigzag..._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
>> d...@nospam.peasland.nethttp://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 fromhttp://www.teranews.com
>
>I get mixed up with AWR tables and database control. AWR tables - are
>they created using system or sys. Do they get tranferred usng full
>export/mport,

Find out which user owns them. Try to be self-reliant, instead of doing nothing yourself, and running to Usenet for every question you can easily lookup and answer yourself.

-- 
Sybrand Bakker
Senior Oracle DBA