"Dave" <JustShutUp_at_azwhole.com> wrote in message
news:big56r$4opm$1_at_netnews.upenn.edu...
>
> >"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F4B8FB9.FD002DB0_at_exxesolutions.com...
>
> >
> > Databases can not be deleted.
> >
> > Seems you are a SQL Server person with little background in Oracle. In
> Oracle a
> > user account with objects is a SCHEMA ... not a database. If you want to
> drop
> > the database ... just shut it down and delete the physical files.
> >
> > If you can log on as sys then you have the Internal account password. If
> you
> > wish to change it log on as SYS and:
> >
> > ALTER USER sys IDENTIFIED BY <new_password>;
> >
> > Then get yourself a book and learn some Oracle.
>
> You're right, I do have little experience in Oracle. But, I actually used
> the Database Configuration Assistant and 'deleted' the database instead of
> dropping all the files from sqlplus. But in order to use that tool, you
> need the INTERNAL account's password. I did have the SYS and SYSTEM
> passwords, but the INTERNAL password was changed by a previous system
admin.
> Using the ALTER USER command cannot be used on the INTERNAL account.
Using
> orapwd utility worked for changing the INTERNAL and SYSTEM accounts'
> passwords.
If you are using dbca you must be using 8.1.7 or higher, which means
INTERNAL is a deprecated account and the equivalent is any account with
SYSDBA privilege.
Received on Tue Aug 26 2003 - 13:19:52 CDT
