SYSTEM account

[chz013]

Hi
Is there a way to find out in sqlplus what
the password for SYSTEM account is ?
Or is there a default password used during installation ?
What would it be ?
I cant create user using SYS account.

 

[sem]

SYS user is an owner of Oracle internal objects. It's created as a part of installation process. Try change_on_install or oracle as password. BTW, why do you need to connect as SYS?

Regards, Dima

 

[nbateman]

The default password for the system account is manager.

You can't find out what a password is, but another dba can reset it - presumably you do have one user that you can log into?

 

[chz013]

Dima,
I dont know much about oracle.
I didnt know SYSTEM password to create users but I knew
SYS, so I tried with it to create users.

nbateman,
Thanks alot! I could create some users now.

My next question is:
What's the difference between Mysql's
create database;
and Oracle's tablespace.
I like to create some tables but they have to belong
somewhere.
Is it ok that I create tables under tablespace after
typing command
connect internal ?

What am I not understanding here ? Am I asking the right questions ?

 

[Turkbear]

See my reply to your other posting...
Meanwhile it is not a good idea to use sys to do anything
- use system ( default password=manager , change it)
to manage the database and then
create a user with dba privs to manage users, etc