Oracle 11G 创建scott用户

最新推荐文章于 2024-05-14 11:08:38 发布

「已注销」

最新推荐文章于 2024-05-14 11:08:38 发布

阅读量786

点赞数

分类专栏： Oracle Basic 文章标签：数据库

本文链接：https://blog.csdn.net/bellwethercoo/article/details/84484598

版权

Oracle Basic 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

新装完Oracle 11GR2数据库后准备使用scott登录

$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 29 15:29:41 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: scott
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

Omg~ 居然没有,不得己建立一个scott用户.

Oracle 11G中建立scott用户使用utlsampl.sql脚本

SQL> !echo $ORACLE_HOME
/u01/oracle

SQL> @/u01/oracle/rdbms/admin/utlsampl.sql

登录验证

SQL> conn scott/tiger
Connected.
SQL> select * from cat;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
BONUS                          TABLE
DEPT                           TABLE
EMP                            TABLE
SALGRADE                       TABLE

顺便给scott用户指定一个单独的表空间

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 29 15:51:36 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>  CREATE TABLESPACE SCOTT_TBS DATAFILE '/u01/oradata/leadercoo/scott_tbs01.dbf' size 100m;

Tablespace created.

SQL> ALTER USER SCOTT DEFAULT TABLESPACE SCOTT_TBS QUOTA UNLIMITED ON SCOTT_TBS;

User altered.

SQL> REVOKE UNLIMITED TABLESPACE FROM SCOTT;

Revoke succeeded.