Re: How to reset admin login account username & password in Oracle 8i?

"Patrick" <patrickmak_at_jos-applications.com> wrote in message news:<9gn7ds$add58_at_imsp212.netvigator.com>...
> Dear all,
>
> Can any body suggest me a means to do if I forgot the username and password
> of an Oracle 8i DB, I am not a DBA and not very familiar with Oracle. It
> just used up many space in harddisk and I want to have a configuration on
> the data file size.
>
> Thanks
>
> Patrick

In a proper config, just fire up server manager (can't specify which executable to use, the answer is version and platform dependent, and specifying which platform and version you are using is obviously asking too much of you) and issue the alter user <username> identified by <password> command.
You seem to know absolutely nothing about Oracle, I have a feeling that you are going to create havoc with your 'configuration on the datafile size'
Again, you don't specify any details, and I don't think you know which filesizes to expect and what you are doing. A typical Oracle installation without datafiles takes some 450 Mb, datafiles alone would easily take 200-300 Mb. You have just to live with that, or *hire* someone who knows what he is doing.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Jun 19 2001 - 14:19:58 CEST