Topic: Database Administration >> User HR & Scott
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Kaiz |
Posted: Jan 16, 2008 12:08:38 PM |
Total Post: 104
Joined: Sep, 2007
|
When created database manually and connect / as sysdba and then seeing the list of usersname select * from dba_users --Scott and Hr user is not their but when created using DBCA and Connected in the same manner and when dispaying the list of username hr and Scott is there….
Can some one please explain what is the concept behind it...
Thanks & Regards |
|
|
MOH_DBA |
| Posted: Jan 16, 2008 02:42:48 PM | |
|
Total Post: 133
Joined: Nov, 2007
|
when create a database, their is a sample users like, HR and scott.
and they are created using the dbca when you check the (create sample schemas check box) and when you do so the dbca execute the scripts that are responsible for creating these sample users. and if you create the database manual, you can create the sample users from scripts in your $ORACLE_HOME Directory.
The Concept behind these users are educational, how?
HR User Contain tables and logic for sample HR System.
PM User Contain tables and logic for sample Oracle Object Oriented and Large Object Programming.
scott User Contain tables and logic for sample Educational Oracle Programming.
I hope that answer your question.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 816 |
| Mohammed Taj | 746 |
| Jayanta Sur | 479 |
| positive fanatic | 418 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 250 |
| Ramesh Jois | 245 |
| neeraj sharma | 243 |
| Bishal Khetan | 207 |
|
|