oracle19c创建scott用户数据

最新推荐文章于 2023-08-30 15:54:33 发布

「已注销」

最新推荐文章于 2023-08-30 15:54:33 发布

阅读量309

点赞数

文章标签： oracle

本文链接：https://blog.csdn.net/weixin_43775431/article/details/124721245

版权

本文档详细介绍了如何在Oracle 19c数据库中创建经典的SCOTT用户，包括用户创建、权限分配及数据导入的步骤，为初学者提供实践指导。

摘要由CSDN通过智能技术生成

创建scott用户数据

[oracle@oracle21c human_resources]$ cat $ORACLE_HOME/rdbms/admin/utlsampl.sql
Rem Copyright (c) 1990, 2017, Oracle and/or its affiliates.
Rem All rights reserved.
Rem NAME
REM    UTLSAMPL.SQL
Rem  FUNCTION
Rem  NOTES
Rem    BEGIN SQL_FILE_METADATA
Rem    SQL_SOURCE_FILE: rdbms/admin/utlsampl.sql
Rem    SQL_SHIPPED_FILE: rdbms/admin/utlsampl.sql
Rem    SQL_PHASE: UTILITY
Rem    SQL_STARTUP_MODE: NORMAL
Rem    SQL_IGNORABLE_ERRORS: NONE
Rem    END SQL_FILE_METADATA
Rem
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 -