Oracle 11g simplified version creates users by importing SQL

Environment: Oracle 11g R2 + SQLPlus

Problem: Oracle SQL Import

Solution:

Win + Run -------> Cmd -------> enter the following command:

1. -- Syntax: sqlplus user name/password @ SQL File 
2. Sqlplus system/manager @ H: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ RDBMS \ ADMIN \ scott. SQL

Note: scott under H: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ RDBMS \ ADMIN. the SQL file records the table and data of the SQL user. Importing this file is equivalent to creating the SCOTT user. The directory contains other user information.

Use the following command to log on to the user:

Conn SCOTT/TIGER;-- Case sensitive

Summary: Oracle 11g simplified version does not have scott, so it is impossible to unlock this user. You can create a scott user in this way and import the table and data of the scott user. However, we cannot know why the username becomes capitalized during connection. I think Oracle Enterprise Edition has this scott user by default. The creation method should be the method described in this article. scott User Logon for Enterprise Edition has a lower-case user name and password. However, you can change scott's username and password to lowercase by modifying the scott. SQL file. Welcome to shoot bricks.