Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g database control export/import questions
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, Received on Tue Oct 23 2007 - 13:12:45 CDT