Workarounds for Scott users that do not exist in Oracle database

Scott users are a very important experiment in our process of learning Oracle, and when we build a database, the Scott user does not appear by default if we choose a custom mode, but we can make this user appear by using a few simple commands. The following are the workarounds (Windows-based):

     1. Start-run--cmd        input: Sqlplus/as sysdba connect to Database        sql>conn Scott/tiger If Scott does not exist, it will report a ORA-01017 error and will disconnect the connection        2. We re-connect        sql>conn sys/password as SYSDBA with SYS user          then after we follow the Oracle catalog F:\oracle\product\10.2.0\db_1\RDBMS\ Admin (Take my directory for example) find this file of Scott.sql         run Sql>@f:\oracle\product\10.2.0\ db_1\rdbms\admin\scott.sql        so Scott users are added, the default password is tiger        sql>conn Scott/tiger Connection Successful        sql>show User;        user is "SCOTT"      3. If you want to modify Scott's default password, you can execute the following command (log in with the SYS permission: Sqlplus/as sysdba)         change Scott's login password      &nbsP; sql> alter user Scott identified by GG; you can get      4 by logging in Scott/gg. If the Scott.sql file does not exist, we can build one manually.         Create a new text document copy the following to the file, and then save it as Scott.sql, put it in the folder in 2, and then follow the steps in 2

Workarounds for Scott users in the Oracle database do not exist