louis wrote:

> Is there another way to move ownership of all the structures to user
> "XXX"?

Yes.

> If we backup the existing database (as SYSDBA) and restore it as "XXX"
> would this achieve our objective?

AFAIK, It should.

> I am asking this as the user site is remote and we have no active
> connection and we don't have the luxury of trial and error.

You can make test db with 2 tables on your machine and test it in few
minutes, no?

Milan.