Today to learn Oracle, and then think about the next, the results have a lot of problems, here to share, crazy, too painful, learning the tutorial is Oracle 11g, I went to the official website to download the Oracle 12g, the file is very large, finally installed, think so use it, the result is full of problems, Summary below:
1, download the software, please go to the official website to download, because you need to register a user, so please have a valid mailbox
Here's how to register as an Oracle user
Http://jingyan.baidu.com/article/9c69d48f5c724413c9024ee6.html
2, install Oracle 12g, see Baidu This, write very detailed
Http://jingyan.baidu.com/article/f96699bbab21c0894e3c1bf8.html
3, the source of the problem, the new version of this Oracle does not have Scott users, but in the folder does exist, do not know why
In this path you can view C:\app\orcl\product\12.1.0\dbhome_1\RDBMS\ADMIN
4. Create your own Scott users, and then circle the corners to find the shadow area of the mind, connect with this command
(1) Create a Scott user
(2) Authorization
(3) Grant space
(4) Connect new user
(5) Delete data sheet
I don't have it, so I've been reporting it.
(6) Create a data table (note that there is a space between the parentheses, there is no space to write the error, between the brackets to have a space)
(7), inserting data into the table test
(8) Transaction submission
Note: Do not commit before the knock is obsolete, be sure to submit
(9) Effect after success
Double-click SQL Plus
I wish you success!
This article draws lessons from the http://blog.csdn.net/cfchengfei002/article/details/45582259, thanks greatly to share
Crazy Install Oracle 12c, this version does not have Scott this user