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

From: Frans Trip <tripf_at_vertis.nl>
Date: Tue, 26 Mar 2002 14:48:42 GMT
Message-ID: <3ca0895c.25996561_at_news.vertis.nl>


svrmgrl
connect internal
[Quoted] alter user system identified by password

works always !!!
There is no real problem, just normal Oracle.

Frans Trip
The Netherlands

On 12 Mar 2002 08:56:49 -0800, noelp1_at_hotmail.com (Noel P) wrote:

>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 Tue Mar 26 2002 - 15:48:42 CET

Original text of this message