最新要闻

广告

手机

iphone11大小尺寸是多少?苹果iPhone11和iPhone13的区别是什么?

iphone11大小尺寸是多少?苹果iPhone11和iPhone13的区别是什么?

警方通报辅警执法直播中被撞飞:犯罪嫌疑人已投案

警方通报辅警执法直播中被撞飞:犯罪嫌疑人已投案

家电

当前视点!Oracle数据库中没有scott账户的方法

来源:博客园


(资料图)

Oracle数据库中没有SCOTT用户解决办法:

一.问题出现

1.新装好oracle-11G先连接管理员账户

2.然后切换到Scott账户

每当这时候对于我这种新手来说头就有点大,怎么解决呢!不要紧张其实不难!

二.解决问题

1.出现上面问题是因为scott账户不存在数据库会自动断开连接,我们现在以管理员账户重新登录.

口令不显示输入的是:ss2.参考我的目录找到oracle安装目录下的scott.sql文件我的oracle安装目录:C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql如果找不到scott.sql文件的话我们可以自己创建一个scott.sql文件保存到

C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin下

我们自己新建一个文本文档复制下面代码到文本文档中,然后保存为scott.sql。

Rem Copyright (c) 1990 by Oracle CorporationRem NAMEREM UTLSAMPL.SQLRem FUNCTIONRem NOTESRem MODIFIEDRem gdudey 06/28/95 - Modified for desktop seed databaseRem glumpkin 10/21/92 - Renamed from SQLBLD.SQLRem blinden 07/27/92 - Added primary and foreign keys to EMP and DEPTRem rlim 04/29/91 - change char to varchar2Rem mmoore 04/08/91 - use unlimited tablespace privRem pritto 04/04/91 - change SYSDATE to 13-JUL-87Rem Mendels 12/07/90 - bug 30123;add to_date calls so language independentRemremrem $Header: utlsampl.sql 7020100.1 94/09/23 22:14:24 cli Generic $ sqlbld.sqlremSET TERMOUT OFFSET ECHO OFF

rem CONGDON Invoked in RDBMS at build time. 29-DEC-1988rem OATES: Created: 16-Feb-83

GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER;ALTER USER SCOTT DEFAULT TABLESPACE USERS;ALTER USER SCOTT TEMPORARY TABLESPACE TEMP;CONNECT SCOTT/TIGERDROP TABLE DEPT;CREATE TABLE DEPT (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,DNAME VARCHAR2(14) ,LOC VARCHAR2(13) ) ;DROP TABLE EMP;CREATE TABLE EMP (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,ENAME VARCHAR2(10),JOB VARCHAR2(9),MGR NUMBER(4),HIREDATE DATE,SAL NUMBER(7,2),COMM NUMBER(7,2),DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);INSERT INTO DEPT VALUES(10,"ACCOUNTING","NEW YORK");INSERT INTO DEPT VALUES (20,"RESEARCH","DALLAS");INSERT INTO DEPT VALUES(30,"SALES","CHICAGO");INSERT INTO DEPT VALUES(40,"OPERATIONS","BOSTON");INSERT INTO EMP VALUES(7369,"SMITH","CLERK",7902,to_date("17-12-1980","dd-mm-yyyy"),800,NULL,20);INSERT INTO EMP VALUES(7499,"ALLEN","SALESMAN",7698,to_date("20-2-1981","dd-mm-yyyy"),1600,300,30);INSERT INTO EMP VALUES(7521,"WARD","SALESMAN",7698,to_date("22-2-1981","dd-mm-yyyy"),1250,500,30);INSERT INTO EMP VALUES(7566,"JONES","MANAGER",7839,to_date("2-4-1981","dd-mm-yyyy"),2975,NULL,20);INSERT INTO EMP VALUES(7654,"MARTIN","SALESMAN",7698,to_date("28-9-1981","dd-mm-yyyy"),1250,1400,30);INSERT INTO EMP VALUES(7698,"BLAKE","MANAGER",7839,to_date("1-5-1981","dd-mm-yyyy"),2850,NULL,30);INSERT INTO EMP VALUES(7782,"CLARK","MANAGER",7839,to_date("9-6-1981","dd-mm-yyyy"),2450,NULL,10);INSERT INTO EMP VALUES(7788,"SCOTT","ANALYST",7566,to_date("13-JUL-87")-85,3000,NULL,20);INSERT INTO EMP VALUES(7839,"KING","PRESIDENT",NULL,to_date("17-11-1981","dd-mm-yyyy"),5000,NULL,10);INSERT INTO EMP VALUES(7844,"TURNER","SALESMAN",7698,to_date("8-9-1981","dd-mm-yyyy"),1500,0,30);INSERT INTO EMP VALUES(7876,"ADAMS","CLERK",7788,to_date("13-JUL-87")-51,1100,NULL,20);INSERT INTO EMP VALUES(7900,"JAMES","CLERK",7698,to_date("3-12-1981","dd-mm-yyyy"),950,NULL,30);INSERT INTO EMP VALUES(7902,"FORD","ANALYST",7566,to_date("3-12-1981","dd-mm-yyyy"),3000,NULL,20);INSERT INTO EMP VALUES(7934,"MILLER","CLERK",7782,to_date("23-1-1982","dd-mm-yyyy"),1300,NULL,10);DROP TABLE BONUS;CREATE TABLE BONUS(ENAME VARCHAR2(10) ,JOB VARCHAR2(9) ,SAL NUMBER,COMM NUMBER) ;DROP TABLE SALGRADE;CREATE TABLE SALGRADE ( GRADE NUMBER,LOSAL NUMBER,HISAL NUMBER );INSERT INTO SALGRADE VALUES (1,700,1200);INSERT INTO SALGRADE VALUES (2,1201,1400);INSERT INTO SALGRADE VALUES (3,1401,2000);INSERT INTO SALGRADE VALUES (4,2001,3000);INSERT INTO SALGRADE VALUES (5,3001,9999);COMMIT;

SET TERMOUT ONSET ECHO ON

3.目录前面加@运行

4.这样Scott账户就被添加进来了!但是我们这时候去连接Scott账户还是连接不上去,是因为我们还没有为Scott账户解锁.下来为scott账户解锁。

注意要以管理员身份去为Scott账户解锁不然会权限不足。

关键词: