-
oracle 10 i password
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
Last edited by sql; 03-06-2011 at 01:53 AM.
-
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.
-
Oracle comes with default id and password, you can find them in Oracle manual.
-
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.
-
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.
-
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.
-
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
Last edited by sql; 03-06-2011 at 01:54 AM.
-
Install Oracle Enterprise Manger and you can do it using graphical interface.
-
Hi Skhanal,
do I need to download any thing , I will check it when I go home.
________
Nevada Dispensary
Last edited by sql; 03-06-2011 at 01:54 AM.
-
Hi ,
are you talking about oracle Enterprise manager Console, I choose Standalone, and successful add one user to it .
thank you
________
Jeep-eagle specifications
Last edited by sql; 03-06-2011 at 01:55 AM.
-
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
Last edited by sql; 03-06-2011 at 01:55 AM.
-
1. Did you look at correct schema?
2. Does the id you used have permission to create table?
-
Which Schema , I Should Go ?
It Seems I Look All Of Schema, And Found Nothing.
________
Subaru History
Last edited by sql; 03-06-2011 at 01:55 AM.
-
run this query in sql plus
select owner, object_name from dba_objects where object_name = 'YOURTABLE';
This will tell you where it exists.
-
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
Last edited by sql; 03-06-2011 at 01:55 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|