DBA access after import (SYS and SYSTEM passwords)

From: Noel P <noelp1_at_hotmail.com>
Date: 12 Mar 2002 08:56:49 -0800
Message-ID: <530e4840.0203120856.1442f5a4_at_posting.google.com>

Hi,

[Quoted] [Quoted] 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 12 2002 - 17:56:49 CET

This message: [ Message body ]
Next message: Rick Wessman: "Re: UTL_FILE : invalid_path error"
Previous message: Aditya: "UTL_FILE : invalid_path error"
Next in thread: Kevin Gillins: "Re: DBA access after import (SYS and SYSTEM passwords)"
Reply: Kevin Gillins: "Re: DBA access after import (SYS and SYSTEM passwords)"
Reply: Ron van Zijl \(Prive\): "Re: DBA access after import (SYS and SYSTEM passwords)"
Reply: Frans Trip: "Re: DBA access after import (SYS and SYSTEM passwords)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message