手动建库 - scott 创建

最新推荐文章于 2022-09-07 13:13:12 发布

shenghuiping2001

最新推荐文章于 2022-09-07 13:13:12 发布

阅读量561

点赞数

分类专栏：数据库开发 Oracle - 测试 oracle - 手动建库文章标签： oracle database user sql c

本文链接：https://blog.csdn.net/shenghuiping2001/article/details/6799721

版权

数据库开发同时被 3 个专栏收录

63 篇文章 1 订阅

订阅专栏

Oracle - 测试

5 篇文章 0 订阅

订阅专栏

oracle - 手动建库

2 篇文章 0 订阅

订阅专栏

手动建库发现scott 用户没有，下面来建一下：

step1：
Check user:

SQL> select username,password from dba_users;

USERNAME                       PASSWORD
------------------------------ ------------------------------
OUTLN                          4A3BA55E08595C81
SYS                            8A8F025737A9097A
SYSTEM                         2D594E86F93B17A1
EZHOUDG                        8A92EDCB3A36EBD7
DBSNMP                         E066D214D5421CCC
TSMSYS                         3DF26A8B17D0F29F
DIP                            CE4A36B8E06CA59C

total 7 users.

Step2: create user from utlsampl.sql

[oracle@aoracle admin]$ sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 22 09:43:55 2011

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show user;
USER is "SYS"
SQL> @?/rdbms/admin/utlsampl
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@aoracle admin]$ sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 22 09:44:48 2011

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select username ,account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
OUTLN                          OPEN
SYS                            OPEN
SYSTEM                         OPEN
EZHOUDG                        OPEN
SCOTT                          OPEN
DBSNMP                         EXPIRED & LOCKED
TSMSYS                         EXPIRED & LOCKED
DIP                            EXPIRED & LOCKED

8 rows selected.

发现scott 么有被lock, 如果lock 的话：
SQL> alter user scott account unlock;

User altered.