Oracle Learning (I.)

Oracle database installation to reserve 5G space, Oracle Common version
· Oracle8, oracle8i: where "I" means the Internet, which means that Oracle is starting to evolve to the network,
· Oracle9i: Is the stable version of Oracle8i, but also now see the most version, 3CD;
· ORACLE10G: Indicates that Oracle started the database based on grid computing;
· ORACLE11G: Is the stable version of oracle10g, is the mainstream version of the promotion,
· ORACLE12C: "C" represents the concept of cloud computing and is now the latest version.
　　 Note: The @ file name (@mldn, if the suffix is "*.sql" can not be written). Conversely, the same is true
the file that is already on the running disk can be the "@ File name full path name"
Four main user information in the database:
• Super Administrator: Sys/change_on_install, the actual development can not use this password;
• General Administrator: System/manager, the actual development can not use this password;
• Normal User: Scott/tiger, need to unlock, this user is a very classic user;
• Big Data User (instance scheme database): sh/sh, need to unlock;

• After correctly installing Oracle, run the sqlplus command to enter the database username and password
One, the first command displays the format operation
• Set the length of data displayed per row: Set Linesize 300;
• Set the number of data rows displayed per page: Set PAGESIZE30;
Second, Switch User command
Oracle has a total of four users, the switch between the four users:
· conn username/password [as SYSDBA]
If you log in with the "SYS" account, you must write "as SYSDBA", and you can log in
The "Show user" command to see which is the current logged-on user.
Example
Login with "SYS": CONN Sys/change_on_install as SYSDBA;
Example
Login with "Scott": CONN Scott/tiger;
Third, call the native command
In the Sqlplus command, you can call the native Doc command directly, for example: Copy command:
Host Cpoy source file path destination file path
Host Copy D:\my.txt D:\hello.txt

Oracle Learning (I.)