日韩无码专区无码一级三级片|91人人爱网站中日韩无码电影|厨房大战丰满熟妇|AV高清无码在线免费观看|另类AV日韩少妇熟女|中文日本大黄一级黄色片|色情在线视频免费|亚洲成人特黄a片|黄片wwwav色图欧美|欧亚乱色一区二区三区

RELATEED CONSULTING
相關(guān)咨詢
選擇下列產(chǎn)品馬上在線溝通
服務(wù)時(shí)間：8:30-17:00
你可能遇到了下面的問(wèn)題
關(guān)閉右側(cè)工具欄

新聞中心

這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
Oracle10g利用utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)

Oracle 10g利用utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)是本文我們主要要介紹的內(nèi)容，我們知道，很多的演示程序都是以scott用戶及其用戶下的表做例子的，于是，快速的創(chuàng)建這個(gè)用戶和初始化表中的數(shù)據(jù)是必須的。在Oracle 10g環(huán)境中這個(gè)過(guò)程很簡(jiǎn)便，只需要以sys用戶執(zhí)行一下$ORACLE_HOME/rdbms/admin/utlsampl.sql腳本就OK了。

下面來(lái)演示一下這個(gè)過(guò)程。以便大家參考。

1.確認(rèn)一下數(shù)據(jù)庫(kù)的版本，同時(shí)查看一下系統(tǒng)中是否已經(jīng)存在scott用戶。

 
 
 
    
  
  
  
  1. sys@ora10g> select * from v$version; 
    2. 
  
  
  
  2. BANNER 
    3. 
  
  
  
  3. ---------------------------------------------------------------- 
    4. 
  
  
  
  4. Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi 
    5. 
  
  
  
  5. PL/SQL Release 10.2.0.3.0 - Production 
    6. 
  
  
  
  6. CORE    10.2.0.3.0      Production 
    7. 
  
  
  
  7. TNS for Linux: Version 10.2.0.3.0 - Production 
    8. 
  
  
  
  8. NLSRTL Version 10.2.0.3.0 - Production 
    9. 
  
  
  
  9. sys@ora10g>select USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,CREATED from dba_users where USERNAME = 'SCOTT'; 
    10. 
  
  
  
  10. no rows selected
    11.

2.創(chuàng)建腳本路徑$ORACLE_HOME/rdbms/admin/utlsampl.sql

 
 
 
    
  
  
  
  1. sys@ora10g>@?/rdbms/admin/utlsampl.sql 
    2. 
  
  
  
  2. Table created. 
    3. 
  
  
  
  3. Table created. 
    4. 
  
  
  
  4. 1 row created. 
    5. 
  
  
  
  5. 1 row created. 
    6. 
  
  
  
  6. 1 row created. 
    7. 
  
  
  
  7. 1 row created. 
    8. 
  
  
  
  8. 1 row created. 
    9. 
  
  
  
  9. 1 row created. 
    10. 
  
  
  
  10. 1 row created. 
    11. 
  
  
  
  11. 1 row created. 
    12. 
  
  
  
  12. 1 row created. 
    13. 
  
  
  
  13. 1 row created. 
    14. 
  
  
  
  14. 1 row created. 
    15. 
  
  
  
  15. 1 row created. 
    16. 
  
  
  
  16. 1 row created. 
    17. 
  
  
  
  17. 1 row created. 
    18. 
  
  
  
  18. 1 row created. 
    19. 
  
  
  
  19. 1 row created. 
    20. 
  
  
  
  20. 1 row created. 
    21. 
  
  
  
  21. 1 row created. 
    22. 
  
  
  
  22. Table created. 
    23. 
  
  
  
  23. Table created. 
    24. 
  
  
  
  24. 1 row created. 
    25. 
  
  
  
  25. 1 row created. 
    26. 
  
  
  
  26. 1 row created. 
    27. 
  
  
  
  27. 1 row created. 
    28. 
  
  
  
  28. 1 row created. 
    29. 
  
  
  
  29. Commit complete. 
    30. 
  
  
  
  30. Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production 
    31. 
  
  
  
  31. With the Partitioning, Data Mining and Real Application Testing options 
    32. 
  
  
  
  32. ora10g@linux5 /home/oracle$
    33.

3.驗(yàn)證用戶是否創(chuàng)建成功

 
 
 
    
  
  
  
  1. sys@ora10g>select USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,CREATED from dba_users where USERNAME = 'SCOTT'; 
    2. 
  
  
  
  2. USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED 
    3. 
  
  
  
  3. -------- -------------- ------------------ -------------------- --------- 
    4. 
  
  
  
  4. SCOTT    OPEN           USERS              TEMP                 05-MAR-09 
    5. 
  
  
  
  5. sys@ora10g>conn scott/tiger 
    6. 
  
  
  
  6. Connected. 
    7. 
  
  
  
  7. scott@ora10g>
    8. 
  
  
  
  8. scott@ora10g>select * from cat; 
    9. 
  
  
  
  9. TABLE_NAME                     TABLE_TYPE 
    10. 
  
  
  
  10. ------------------------------ ----------- 
    11. 
  
  
  
  11. DEPT                           TABLE 
    12. 
  
  
  
  12. EMP                            TABLE 
    13. 
  
  
  
  13. BONUS                          TABLE 
    14. 
  
  
  
  14. SALGRADE                       TABLE
    15.

4.【附錄】utlsampl.sql腳本內(nèi)容

 
 
 
    
  
  
  
  1. $ cat $ORACLE_HOME/rdbms/admin/utlsampl.sql 
    2. 
  
  
  
  2. Rem Copyright (c) 1990, 1996, 1997, 1999, 2001 by Oracle Corporation 
    3. 
  
  
  
  3. Rem NAME 
    4. 
  
  
  
  4. REM    UTLSAMPL.SQL 
    5. 
  
  
  
  5. Rem  FUNCTION 
    6. 
  
  
  
  6. Rem  NOTES 
    7. 
  
  
  
  7. Rem  MODIFIED 
    8. 
  
  
  
  8. Rem     menash     02/21/01 -  remove unnecessary users for security reasons 
    9. 
  
  
  
  9. Rem     gwood      03/23/99 -  make all dates Y2K compliant 
    10. 
  
  
  
  10. Rem     jbellemo   02/27/97 -  dont connect as system 
    11. 
  
  
  
  11. Rem     akolk      08/06/96 -  bug 368261: Adding date formats 
    12. 
  
  
  
  12. Rem     glumpkin   10/21/92 -  Renamed from SQLBLD.SQL 
    13. 
  
  
  
  13. Rem     blinden   07/27/92 -  Added primary and foreign keys to EMP and DEPT 
    14. 
  
  
  
  14. Rem     rlim       04/29/91 -         change char to varchar2 
    15. 
  
  
  
  15. Rem     mmoore     04/08/91 -         use unlimited tablespace priv 
    16. 
  
  
  
  16. Rem     pritto     04/04/91 -         change SYSDATE to 13-JUL-87 
    17. 
  
  
  
  17. Rem   Mendels    12/07/90 - bug 30123;add to_date calls so language independent 
    18. 
  
  
  
  18. Rem 
    19. 
  
  
  
  19. rem 
    20. 
  
  
  
  20. rem $Header: utlsampl.sql 21-feb-01.18:15:30 menash Exp $ sqlbld.sql 
    21. 
  
  
  
  21. rem 
    22. 
  
  
  
  22. SET TERMOUT OFF 
    23. 
  
  
  
  23. SET ECHO OFF 
    24. 
  
  
  
  24. rem CONGDON    Invoked in RDBMS at build time.   29-DEC-1988 
    25. 
  
  
  
  25. rem OATES:     Created: 16-Feb-83 
    26. 
  
  
  
  26. DROP USER SCOTT CASCADE; 
    27. 
  
  
  
  27. DROP USER ADAMS CASCADE; 
    28. 
  
  
  
  28. DROP USER JONES CASCADE; 
    29. 
  
  
  
  29. DROP USER CLARK CASCADE; 
    30. 
  
  
  
  30. DROP USER BLAKE CASCADE; 
    31. 
  
  
  
  31. GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER; 
    32. 
  
  
  
  32. DROP PUBLIC SYNONYM PARTS; 
    33. 
  
  
  
  33. CONNECT SCOTT/TIGER 
    34. 
  
  
  
  34. CREATE TABLE DEPT 
    35. 
  
  
  
  35.        (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY, 
    36. 
  
  
  
  36.         DNAME VARCHAR2(14) , 
    37. 
  
  
  
  37.         LOC VARCHAR2(13) ) ; 
    38. 
  
  
  
  38. CREATE TABLE EMP 
    39. 
  
  
  
  39.        (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY, 
    40. 
  
  
  
  40.         ENAME VARCHAR2(10), 
    41. 
  
  
  
  41.         JOB VARCHAR2(9), 
    42. 
  
  
  
  42.         MGR NUMBER(4), 
    43. 
  
  
  
  43.         HIREDATE DATE, 
    44. 
  
  
  
  44.         SAL NUMBER(7,2), 
    45. 
  
  
  
  45.         COMM NUMBER(7,2), 
    46. 
  
  
  
  46.         DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT); 
    47. 
  
  
  
  47. INSERT INTO DEPT VALUES 
    48. 
  
  
  
  48.         (10,'ACCOUNTING','NEW YORK'); 
    49. 
  
  
  
  49. INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS'); 
    50. 
  
  
  
  50. INSERT INTO DEPT VALUES 
    51. 
  
  
  
  51.         (30,'SALES','CHICAGO'); 
    52. 
  
  
  
  52. INSERT INTO DEPT VALUES 
    53. 
  
  
  
  53.         (40,'OPERATIONS','BOSTON'); 
    54. 
  
  
  
  54. INSERT INTO EMP VALUES 
    55. 
  
  
  
  55. (7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20); 
    56. 
  
  
  
  56. INSERT INTO EMP VALUES 
    57. 
  
  
  
  57. (7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30); 
    58. 
  
  
  
  58. INSERT INTO EMP VALUES 
    59. 
  
  
  
  59. (7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30); 
    60. 
  
  
  
  60. INSERT INTO EMP VALUES 
    61. 
  
  
  
  61. (7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20); 
    62. 
  
  
  
  62. INSERT INTO EMP VALUES 
    63. 
  
  
  
  63. (7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30); 
    64. 
  
  
  
  64. INSERT INTO EMP VALUES 
    65. 
  
  
  
  65. (7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30); 
    66. 
  
  
  
  66. INSERT INTO EMP VALUES 
    67. 
  
  
  
  67. (7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10); 
    68. 
  
  
  
  68. INSERT INTO EMP VALUES 
    69. 
  
  
  
  69. (7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87','dd-mm-rr')-85,3000,NULL,20); 
    70. 
  
  
  
  70. INSERT INTO EMP VALUES 
    71. 
  
  
  
  71. (7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5000,NULL,10); 
    72. 
  
  
  
  72. INSERT INTO EMP VALUES 
    73. 
  
  
  
  73. (7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30); 
    74. 
  
  
  
  74. INSERT INTO EMP VALUES 
    75. 
  
  
  
  75. (7876,'ADAMS','CLERK',7788,to_date('13-JUL-87', 'dd-mm-rr')-51,1100,NULL,20); 
    76. 
  
  
  
  76. INSERT INTO EMP VALUES 
    77. 
  
  
  
  77. (7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30); 
    78. 
  
  
  
  78. INSERT INTO EMP VALUES 
    79. 
  
  
  
  79. (7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3000,NULL,20); 
    80. 
  
  
  
  80. INSERT INTO EMP VALUES 
    81. 
  
  
  
  81. (7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10); 
    82. 
  
  
  
  82. CREATE TABLE BONUS 
    83. 
  
  
  
  83.         ( 
    84. 
  
  
  
  84.         ENAME VARCHAR2(10)      , 
    85. 
  
  
  
  85.         JOB VARCHAR2(9)  , 
    86. 
  
  
  
  86.         SAL NUMBER, 
    87. 
  
  
  
  87.         COMM NUMBER 
    88. 
  
  
  
  88.         ) ; 
    89. 
  
  
  
  89. CREATE TABLE SALGRADE 
    90. 
  
  
  
  90.       ( GRADE NUMBER, 
    91. 
  
  
  
  91.         LOSAL NUMBER, 
    92. 
  
  
  
  92.         HISAL NUMBER ); 
    93. 
  
  
  
  93. INSERT INTO SALGRADE VALUES (1,700,1200); 
    94. 
  
  
  
  94. INSERT INTO SALGRADE VALUES (2,1201,1400); 
    95. 
  
  
  
  95. INSERT INTO SALGRADE VALUES (3,1401,2000); 
    96. 
  
  
  
  96. INSERT INTO SALGRADE VALUES (4,2001,3000); 
    97. 
  
  
  
  97. INSERT INTO SALGRADE VALUES (5,3001,9999); 
    98. 
  
  
  
  98. COMMIT;
    99.

關(guān)于Oracle 10g數(shù)據(jù)庫(kù)利用系統(tǒng)自帶腳本utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)的過(guò)程就介紹到這里了，希望本次的介紹能夠?qū)δ兴斋@！


網(wǎng)站標(biāo)題：Oracle10g利用utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)
網(wǎng)站地址：http://www.5511xx.com/article/cceieog.html