At 11:08 AM 27/01/2006, you wrote:

>
>
> > -----Original Message-----
> > Thomas Steinmaurer has a really good little (sophisticated)
> > tool for doing
> > this. You need to ask him directly for a copy. It's very good.
> > Alan
>
>Fortunately I don't need to change an owner, just wondered what the process
>was. I thought it was backup and restore under user to be the owner.

That's correct. But the caution is that being the owner of a
database doesn't make a user the owner of any objects created in the
database. The owner of an object is (and remains) the user that created it.

SYSDBA is like a "superowner", since it has full destructive rights
to all databases and all objects in all databases. Hence the
frequent advice seen here to make sure you create databases and
database objects while logged in as the user that you plan to have as
the owner.

./heLen