Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Orcale database 12c book chapter 1 - SQLPLUS- need help with creating user and also running the stor

JackofNoneJan 1 2016 — edited Jan 2 2016

Hi guys,

I am reading the 1st chapter of the book and I really need the help to get started.

I have gotten the Orcale database 12c installed but I cannot even run a a script... I am able to connect through the SQL developer but cannot run the script through SQLPLUS

In the book, page 11 of chapter 1, it ask you to start the sql plus, and log in as an admin user. I logged in as the system user. I do not have a pluggable database PDORC1 - it says it does not exist.

The next step tells me to use this line to locate the script which I do have in my c drive. @ C:\sql_book\SQL\store_schema.sql;

store schema.PNG

After I run this, I get that I am no longer connected to oracle and i get this sp2-0640 not connected.

What do i do from here and how do I make this work?

I am running windows 10.

Also when I try to create a user I get this invalid common user or role name. What is the logic and what am i missing?

Please and thank you

invalid common user.PNG

*********Moderator action (Timo): moved this from to *********

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2016
Added on Jan 1 2016
11 comments
2,676 views