Re: DBA user in Oracle conflicts during migration

<bdbafh_at_gmail.com> wrote in message
news:1108871104.998576.73720_at_c13g2000cwb.googlegroups.com...
> SQL> drop role dba;
>
> Role dropped.
>
> SQL> create user dba identified by badpractice;
>
> User created.
>
> Perhaps one might consider constructing a database that lacks the
> provided schemas like ctxsys, mdsys, ordsys, wksys that most likely
> rely on the granted dba role. Migrate the schema into that database
> using the workbench.
>
> After importing your objects into such a database into the schema
> 'DBA', export them (using exp or expdp) and then import them into a
> database that has the role dba, but use the fromuser/touser parameters
> to direct the objects into a different schema.
>
> I do not believe that the role "DBA" is required if you are not using
> oracle-provided schemas, but it sure would scare me, that something
> would rely on it and throw an error at 2 am someday that appears as an
> obscure ora-600 error ...
>
> hth.
>
> -bdbafh
>

do a search a couple of months back on thisvery subject, where it was concluded dba role is needed becuase it is special to the database Received on Sun Feb 20 2005 - 05:38:59 CST