Skip to Main Content

Oracle Database Discussions

How to connect to the human_resources schemas in 12c?

9a8s7d6f5g4h3j2k1lJan 28 2014 — edited Jan 29 2014

Hi, i didnt have hr user, i didnt have schemas, so i download the example schemas from oracle downloads. Installed them to F:\app\product\12.1.0\dbhome_1\demo\schema\human_resources

Here goes the question, do i have now HR user? or must create the new one? And, if i must create new one, how can i grant him privilege to acces those schemas

In SQL Developer for user SYSTEM, show me other tables that i dont need right now. So how can i solve this problem?
Please write commands for SQL plus because i am new in this. Thank you.

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

PL/SQL Release 12.1.0.1.0 - Production

"CORE 12.1.0.1.0 Production"

TNS for 64-bit Windows: Version 12.1.0.1.0 - Production

NLSRTL Version 12.1.0.1.0 - Production

This post has been answered by Richard Harrison . on Jan 29 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2014
Added on Jan 28 2014
42 comments
18,369 views