oracle 10 i password

[sql]

Hi all,
I want to learn Oracle, I install oracle on win xp. when I try to log in oracle Sql * Plus I got invalid login Name and password. where to find my login name and password?
Thank you.
________
F2003-GA

[Rawhide]

I'm not an Oracle dba, but if it is like SQL Server in this respect, then you tell Oracle what the system login username and password is during the installation.

[rmiao]

Oracle comes with default id and password, you can find them in Oracle manual.

[Rawhide]

Wow!! That's surprising. It seems like that would be a very high security risk unless Oracle forces you to change the password the first time you log in.

[skhanal]

These are default password for pre 10g era. Try if it works in 10g.

system - manager
sys - change_on_install

But 10g installation asks you for password.

[stecal]

I believe the difference is that DBCA prompts you for the passwords, but if you use a CREATE DATABASE script, then the default passwords are automatically used unless you explicitly set them in the script/statement.

[sql]

Hi all,
I found the password which I install orcale,
can any one tell me how can I add some new use and login name to oracle. some like in MS sql login -> new user , or use sample code!
by the way I can create table on oracle SQl* Plus, but not in
SQL Plus worksheet, every time when I try to run some sample cod ein there, I got error connected is die, at beginning is connected to database. what is wrong?
thank you
________
Digital Vaporizers

[skhanal]

Install Oracle Enterprise Manger and you can do it using graphical interface.

[sql]

Hi Skhanal,
do I need to download any thing , I will check it when I go home.
________
Nevada Dispensary

[sql]

Hi ,
are you talking about oracle Enterprise manager Console, I choose Standalone, and successful add one user to it .
thank you
________
Jeep-eagle specifications

[sql]

Hi all,
1) create some table on SQL Plus , can select, but can't found on oracle enterprise Manager, what is the table hidden?
2)why SQl plus worksheet only can run select stament not allow to creat table?
thank you
________
7

[rmiao]

1. Did you look at correct schema?
2. Does the id you used have permission to create table?

[sql]

Which Schema , I Should Go ?
It Seems I Look All Of Schema, And Found Nothing.
________
Subaru History

[skhanal]

run this query in sql plus

select owner, object_name from dba_objects where object_name = 'YOURTABLE';

This will tell you where it exists.

[sql]

no row selected, I even try to creat a new table , I can sleect it , but still can' tfound where is the table.
________
Dodge Coronet