Re: DBA access after import (SYS and SYSTEM passwords)

True, importing a FULL dataabse will overwrite the SYS and SYSTEM passwords.

First Question is if you need to do a full import or if you could just import one user (or set of users).
That way you will not import the sys and system users and their pwd will remain the same.

If you HAVE to do a full import you can use your solution. Create a user with DBA rights, import, connect as the user and alter the sys and system passwords
e.g. ALTER USER SYS IDENTIED BY <PWD>;
This will work, i have used it many times.

Greetz

Ron

"Noel P" <noelp1_at_hotmail.com> wrote in message news:530e4840.0203120856.1442f5a4_at_posting.google.com...
> Hi,
>
> I have a dump of a database on which I only have a user level access
> but no DBA access. I create a new database and have the SYS and SYSTEM
> access.
> However, once I import the dump of the other database, I can't login
> as SYS or SYSTEM because it changes the SYSTEM and SYS passwords.
>
> How can I overcome this, so that after the import, I still have SYSTEM
> and SYS passwords.
>
> Can I create a an account with DBA privilages before the import, and
> login using that DBA after the import and change the SYS and SYSTEM
> passwords?
>
> Your help is very much appreciated.
>
> Thanks
>
> -Noel
Received on Thu Mar 14 2002 - 14:37:44 CST