{"id":436,"date":"2013-10-29T13:06:59","date_gmt":"2013-10-29T22:06:59","guid":{"rendered":"\/blog\/?p=436"},"modified":"2023-09-21T09:38:49","modified_gmt":"2023-09-21T00:38:49","slug":"oracle-schema","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=436","title":{"rendered":"Oracle Schema"},"content":{"rendered":"\n

1 Overview<\/span>
<\/span>http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/overview.htm<\/span><\/a>

2 Installation<\/span>
<\/span>http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/installation.htm<\/span><\/a>

3 Rationale<\/span>
<\/span>http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/rationale.htm<\/span><\/a>

4 Schema Diagrams<\/span>
<\/span>http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/diagrams.htm<\/span><\/a>

5 Sample Schema Scripts and Object Descriptions<\/span>
<\/span><\/span>http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/scripts.htm<\/span><\/a><\/span>


\uacbd\ub85c<\/span>
$ORACLE_HOME\/demo\/schema\/log\/<\/span>

- SQL \ud559\uc2b5\uc744 \uac00\uc7a5 \uc27d\uac8c \ud6a8\uc728\uc801\uc73c\ub85c \ud558\ub294 \ubc29\ubc95\uc740 \uc2e4\uc81c \ub370\uc774\ud130\ub97c \uac00\uc9c0\uace0 \uc2e4\ud589 \uacb0\uacfc\ub97c \ud655\uc778 \ud558\ub294 \ubc95\uc774\ub2e4.<\/span>

- Oracle\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790 \ub4e4\uc744 \uc704\ud55c \uc0d8\ud50c \uc2a4\ud0a4\ub9c8\ub97c \uc81c\uacf5 \ud55c\ub2e4.<\/span>


\uc624\ub77c\ud074 \uc0d8\ud50c \uc2a4\ud0a4\ub9c8<\/span>

-\uc0c1\ud488\uc744 \ud310\ub9e4\ud558\ub294 \uac00\uc0c1\uc758 \ub2e4\uad6d\uc801 \ud68c\uc0ac\ub97c \ubaa8\ub378\ub85c \uc77c\ubc18\uc801\uc778 \ud68c\uc0ac\uc5d0\uc11c \uc774\ub8e8\uc5b4\uc9c0\ub294 \uae30\ubcf8\uc801\uc778 \uc5c5\ubb34 \ub300\ubd80\ubd84\uc744 \ud3ec\uad04\ud560 \uc218 \uc788\uc744 \uc815\ub3c4\uc758 \uad6c\uc870\ub97c \uac00\uc9c4\ub2e4.<\/span>



\uc2a4\ud0a4\ub9c8 \uad6c\uc131<\/span>

-Humman Resource(HR) \uc2a4\ud0a4\ub9c8 : \uc778\uc0ac\ubd80, \uc0d8\ud50c \ud68c\uc0ac\uc758 \uad6c\uc131\uc6d0\ub4e4\uacfc \ubd80\uc11c, \uad6c\uc131\uc6d0\ub4e4\uc758 \uc9c1\uae09 \ub4f1\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uac16\uc74c.<\/span>

-Order Entry(OE) \uc2a4\ud0a4\ub9c8 : \uc0c1\ud488 \uc7ac\uace0 \ucd94\uc801 \ubc0f \uc0c1\ud488 \ud310\ub9e4 \ubd80\uc11c<\/span>

-Product Media(PM) \uc2a4\ud0a4\ub9c8 : \ud310\ub9e4\ub41c \uc0c1\ud488\uc758 \uc0c1\uc138 \uc815\ubcf4\ub97c \ub2e4\ub8e8\ub294 \ubd80\uc11c<\/span>

-Information Exchange(IX) \uc2a4\ud0a4\ub9c8 : B2B \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc774\uc6a9\ud55c \ubb3c\ub958\ucc98\ub9ac \uc218\ud589<\/span>

-Sales History(SH) \uc2a4\ud0a4\ub9c8 : \ud68c\uc0ac \uacbd\uc601\uc5d0 \ud544\uc694\ud55c \uc0c1\ud488 \ud310\ub9e4\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc790\ub8cc \uad00\ub9ac<\/span>



** \uc624\ub77c\ud074 \uc2a4\ud0a4\ub9c8\ub780 ?<\/span>

- \uc2a4\ud0a4\ub9c8 \uc624\ube0c\uc81d\ud2b8(Schema Object)\ub4e4\uc758 \uc9d1\ud569. Schema Object\ub294 \ud14c\uc774\ube14, \ubdf0, \uc778\ub371\uc2a4\uc640 \uac19\uc740 \uad6c\uc870\ub97c \ud3ec\ud568\ud558\ub294 \ub17c\ub9ac\uc801\uc778 \ub370\uc774\ud130 \uc800\uc7a5 \uad6c\uc870\ub97c \uac00\uc9c4 \uac1d\uccb4.<\/span>

- \ud558\ub098\uc758 \uc2a4\ud0a4\ub9c8\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uc5d0 \uc758\ud574 \uc18c\uc720\ub418\uba70, \uadf8 \uc774\ub984\uc740 \uc0ac\uc6a9\uc790 \uc774\ub984\uacfc \uac19\uc74c(\uc2a4\ud0a4\ub9c8 \uc815\uc758 \ub77c\uace0 \ud568)<\/span>

*\uc2a4\ud0a4\ub9c8\ub780 \uc784\uc758\uc758 \uc0ac\uc6a9\uc790\uac00 \uc0dd\uc131\ud55c \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\ub4e4\uc744 \ub9d0\ud558\uba70, \uc2a4\ud0a4\ub9c8 \uc774\ub984\uc740 \uadf8 \uc0ac\uc6a9\uc790\uc758 \uc774\ub984\uacfc \uac19\ub2e4. (\ub1cc\ub97c \uc790\uadf9\ud558\ub294 \uc624\ub77c\ud074 p.94)<\/span><\/b>


\uc608) 'HR' \uc774\ub780 \uc0ac\uc6a9\uc790\uac00 \ud14c\uc774\ube14, \uc778\ub371\uc2a4, \ubdf0 \ub4f1 \uc5ec\ub7ec \uac1d\uccb4\ub97c \uc0dd\uc131\ud588\ub2e4\uba74 \uadf8\uac1d\uccb4\uc758 \uc18c\uc720\uc790\ub294 'HR'\uc774\uba70 \ubaa8\ub450\ub97c \uac00\ub9ac\ucf1c HR \uc2a4\ud0a4\ub9c8\ub77c\uace0 \ud568.<\/span>

Oracle System \uc815\ubcf4\ub97c \uac16\uace0 \uc788\ub294 Data Dictionary\uc758 \ub300\ubd80\ubd84\uc758 \uc18c\uc720\uc790\ub294 SYS<\/span>



*\uc2a4\ud0a4\ub9c8\uc758 \uc815\uc758\ub294 '\ub17c\ub9ac\uc801\uc778 \ub370\uc774\ud130 \uc800\uc7a5\uad6c\uc870' \uc774\uc9c0\ub9cc \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \ub17c\ub9ac\uc801 \uc800\uc7a5 \uad6c\uc870\uc640\ub294 \ub2e4\ub978 \uac1c\ub150.<\/span>


HR, OE, PM, IX, SH \uc2a4\ud0a4\ub9c8\ub294 Oracle Enterprise \uc124\uce58\uc2dc \uc790\ub3d9\uc73c\ub85c \uc124\uce58\ub418\uba70 \ucc98\uc74c \uc0ac\uc6a9\uc2dc \uc0ac\uc6a9\uc790 \uacc4\uc815\ub9cc \ud480\uc5b4 \uc8fc\uba74\ub41c\ub2e4.<\/span>


[\uc0ac\uc6a9\uc790 \uacc4\uc815 \ud480\uae30 - SYS DBA \uad8c\ud55c]<\/span>

SQL> ALTER USER [HR, OE, PM, IX, SH \uc911 \ud558\ub098] ACCOUNT UNLOCK;<\/span>



* \uacc4\uc815\uc774 \uc7a0\uacbc\uc744 \uacbd\uc6b0<\/span>

ERROR:<\/span>

ORA-28000: the account is locked.<\/span>



* ALTER USER HR ACCOUNT UNLOCK - HR \uacc4\uc815 \ud480\uae30<\/span>

* ALTER USER HR ACCOUNT LOCK - HR \uacc4\uc815 \uc7a0\uadf8\uae30<\/span>


\uacc4\uc815\uc744 \ud480\uc5c8\uc9c0\ub9cc \ube44\ubc00 \ubc88\ud638\ub97c \ubaa8\ub97c \uacbd\uc6b0<\/span>

SQL> ALTER USER [\uc0ac\uc6a9\uc790\uc774\ub984] IDENTIFIED BY [\ube44\ubc00\ubc88\ud638] ACCOUNT UNLOCK;<\/span>


SQL> ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;<\/span>


\uc0d8\ud50c \uc2a4\ud0a4\ub9c8\ub97c \uc124\uce58\ud558\uae30 \uc704\ud55c \uae30\ubcf8\uc740 \uc5ec\uae30\uae4c\uc9c0~~~!<\/span>


\ubcf8\uaca9\uc801\uc73c\ub85c \uc0d8\ud50c \uc2a4\ud0a4\ub9c8\ub97c \uc124\uce58\ud558\uae30 \uc704\ud574 HR, OE, PM, IX, SH, BI \uc720\uc800\ub97c \uc7a0\uae08 \ud574\uc81c \ud55c\ub2e4.<\/span>


SQL> ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;<\/span>

SQL> ALTER USER OE IDENTIFIED BY OE ACCOUNT UNLOCK;<\/span>

SQL> ALTER USER PM IDENTIFIED BY PM ACCOUNT UNLOCK;<\/span>

SQL> ALTER USER IX IDENTIFIED BY IX ACCOUNT UNLOCK;<\/span>

SQL> ALTER USER SH IDENTIFIED BY SH ACCOUNT UNLOCK;<\/span>

SQL> ALTER USER BI IDENTIFIED BY BI ACCOUNT UNLOCK;<\/span>



\uc0d8\ud50c \uc2a4\ud0a4\ub9c8 \uc124\uce58 \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc740<\/span>

$ORACLE_HOME\\demo\\schema\\mksample.sql \uc744 \ucc3e\uc744 \uc218 \uc788\ub2e4.<\/span>

*\ub2e8, Oracle Database 10g Companion CD Release 2\uc778 \uacbd\uc6b0 \ud30c\uc77c\uc774 \uc0dd\uc131\ub428.<\/span>

\uc0d8\ud50c \uc2a4\ud0a4\ub9c8 \uc124\uce58 \ud30c\uc77c\uc740 \uac01 \uc0ac\uc6a9\uc790 \uc2e0\uaddc \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec, \ud14c\uc774\ube14, \uc778\ub371\uc2a4, \ubdf0 \ub4f1 \uc124\uce58\ud560 Object \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\ub85c \uad6c\uc131. \uad81\uae08\ud558\uba74 mksample.sql\uc744 \uc5f4\uc5b4 \ubcf4\uc138\uc694-_-;<\/span>


\ud30c\uc77c\uc758 \uacbd\ub85c\ub97c \uc54c\uba74 \uc544\ub798\uc640 \uac19\uc774<\/span>

SQL>@ D:\\oracle\\product\\10.2.0\\db_1\\demo\\schema\\human_resources\\mksample.sql<\/span>


\uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc2e4\ud589\ub418\uba74 sys \ubc0f \uc2e0\uaddc\ub85c \uc0dd\uc131\ub418\ub294 \uc0ac\uc6a9\uc790\uc758 \uc554\ud638\uc640 \uc124\uce58\ub420 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc774\ub984\uc744 \uc785\ub825\ud558\ub77c\uace0 \ub098\uc628\ub2e4~<\/span>

SQL> specifiy password for SYSTEM as parameter 1:<\/span>

1\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: oracle<\/span>

SQL> specifiy password for SYS as parameter 2:<\/span>

2\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: oracle<\/span>

SQL> specifiy password for HR as parameter 3:<\/span>

3\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: hr<\/span>

SQL> specifiy password for OE as parameter 4:<\/span>

4\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: oe<\/span>

SQL> specifiy password for PM as parameter 5:<\/span>

5\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: pm<\/span>

SQL> specifiy password for IX as parameter 6:<\/span>

6\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: ix<\/span>

SQL> specifiy password for sh as parameter 7:<\/span>

7\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: sh<\/span>

SQL> specifiy password for bi as parameter 8:<\/span>

8\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: bi<\/span>

SQL> specifiy default tablespace as parameter 9:<\/span>

9\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: example<\/span>

SQL> specifiy temporary tablespace as parameter 10:<\/span>

10\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: temp<\/span>

SQL> specifiy log file directory (including trailing delemiter)  as parameter 11:<\/span>

11\uc758 \uac12\uc744 \uc785\ub825\ud558\uc2dc\uc624: $ORACLE_HOME\/demo\/schema\/log\/<\/span>


11\ubc88\uae4c\uc9c0 \uc785\ub825\ud558\uba74 \uc124\uce58\uac00 \uc9c4\ud589~~~ \uc131\uacf5 \ub418\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc785\ub825<\/span>

SQL>SELECT object_name, subobject_name FROM dba_objects<\/span>

WHERE owner in ('HR', 'OE', 'PM', 'IX', 'SH', 'BI');<\/span>

554\uac1c\uc758 \ud589\uc774 \uc120\ud0dd \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span>



\uc704\uc640 \uac19\uc740 \uba54\uc138\uc9c0\uac00 \ub728\uba74 \uc124\uce58 \uc644\ub8cc<\/span>

\uc624\ube0c\uc81d\ud2b8\uc758 \uacbd\uc6b0 \uc124\uce58\uac00 \uc548\ub418\uac70\ub098 \ubc84\uc83c\uc5d0 \ub530\ub77c \ub2ec\ub77c \uc9c8\uc218 \uc788\uc74c.<\/span>
<\/p>\n","protected":false},"excerpt":{"rendered":"

1 Overviewhttp:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/overview.htm 2 Installationhttp:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/installation.htm 3 Rationalehttp:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/rationale.htm 4 Schema Diagramshttp:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/diagrams.htm 5 Sample Schema Scripts and Object Descriptionshttp:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10831\/scripts.htm \uacbd\ub85c$ORACLE_HOME\/demo\/schema\/log\/ – SQL \ud559\uc2b5\uc744 \uac00\uc7a5 \uc27d\uac8c \ud6a8\uc728\uc801\uc73c\ub85c \ud558\ub294 \ubc29\ubc95\uc740 \uc2e4\uc81c \ub370\uc774\ud130\ub97c \uac00\uc9c0\uace0 \uc2e4\ud589 \uacb0\uacfc\ub97c \ud655\uc778 \ud558\ub294 \ubc95\uc774\ub2e4. – Oracle\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790 \ub4e4\uc744 \uc704\ud55c \uc0d8\ud50c \uc2a4\ud0a4\ub9c8\ub97c \uc81c\uacf5 \ud55c\ub2e4. \uc624\ub77c\ud074 \uc0d8\ud50c \uc2a4\ud0a4\ub9c8 -\uc0c1\ud488\uc744 \ud310\ub9e4\ud558\ub294 \uac00\uc0c1\uc758 \ub2e4\uad6d\uc801 \ud68c\uc0ac\ub97c \ubaa8\ub378\ub85c \uc77c\ubc18\uc801\uc778 \ud68c\uc0ac\uc5d0\uc11c \uc774\ub8e8\uc5b4\uc9c0\ub294 \uae30\ubcf8\uc801\uc778 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-436","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=436"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/436\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}