oracle19c主目录用户,oracle 19c 添加 scott用户与表

对于熟悉Oracle或者接触过Oracle的人，scott这个用户大家一定相当的熟悉。12c推出了可插拔数据库，在一个容器cdb中以多租户的形式同时存在多个数据库pdb。pdb中默认不包含scott用户。

为了做数据泵的实验，需要一个测试用户，因此需要在pdb中添加scott用户。

oracle 12c自带了scott的脚本，$ORACLE_HOME/rdbms/admin/utlsampl.sql 内容如下：

Rem Copyright (c) 1990, 2006, Oracle. All rights reserved.

Rem NAME

REM UTLSAMPL.SQL

Rem FUNCTION

Rem NOTES

Rem MODIFIED

Rem lburgess 04/02/06 - lowercase passwords

Rem menash 02/21/01 - remove unnecessary users for security reasons

Rem gwood 03/23/99 - make all dates Y2K compliant

Rem jbellemo 02/27/97 - dont connect as system

Rem akolk 08/06/96 - bug 368261: Adding date formats

Rem glumpkin 10/21/92 - Renamed from SQLBLD.SQL

Rem blinden 07/27/92 - Added primary and foreign keys to EMP and DEPT

Rem rlim 04/29/91 - change char to varchar2

Rem mmoore 04/08/91 - use unlimited tablespace priv

Rem pritto 04/04/91 - change SYSDATE to 13-JUL-87

Rem Mendels 12/07/90 - bug 30123;add to_date calls so language independent

Rem

rem

rem $Header: utlsampl.sql 02-apr-2006.21:13:01 lburgess Exp $ sqlbld.sql

rem

SET TERMOUT OFF

SET ECHO OFF

rem CONGDON Invoked in RDBMS at build time. 29-DEC-1988

rem OATES: Created: 16-Feb-83

DROP USER SCOTT CASCADE;

DROP USER ADAMS CASCADE;

DROP USER JONES CASCADE;

DROP USER CLARK CASCADE;

DROP USER BLAKE CASCADE;

GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY tiger;