{"id":8721,"date":"2024-03-08T04:30:51","date_gmt":"2024-03-07T19:30:51","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=8721"},"modified":"2024-03-08T05:50:10","modified_gmt":"2024-03-07T20:50:10","slug":"oracle-%ea%b8%b0%ec%b4%88-%eb%aa%85%eb%a0%b9","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=8721","title":{"rendered":"Oracle – \uae30\ucd08 \uba85\ub839"},"content":{"rendered":"

Oracle – \uae30\ucd08 \uba85\ub839<\/h1>\n

\uacc4\uc815 \uc0dd\uc131<\/h2>\n

\uc624\ub77c\ud074 12c \ubd80\ud130 c##<\/code> \uc744 \ubd99\uc5ec\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

sqlplus\n......\n\uc0ac\uc6a9\uc790\uba85 \uc785\ub825: system\n\ube44\ubc00\ubc88\ud638 \uc785\ub825:\n......\nSQL> conn\/as sysdba\n\uc5f0\uacb0\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n\nSQL> create user myuser identified by mypass;\ncreate user myuser identified by mypass\nORA-65096: \uacf5\ud1b5 \uc0ac\uc6a9\uc790 \ub610\ub294 \ub864 \uc774\ub984\uc774 \ubd80\uc801\ud569\ud569\ub2c8\ub2e4.\nSQL> create user c##myuser identified by mypass;\n\uc0ac\uc6a9\uc790\uac00 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n\nSQL> grant connect, resource, dba to c##myuser;\n\uad8c\ud55c\uc774 \ubd80\uc5ec\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\nSQL> commit;<\/code><\/pre>\n
\ud14c\uc774\ube14 \uc0dd\uc131<\/h2>\n
sqlplus\n\uc0ac\uc6a9\uc790\uba85 \uc785\ub825: c##myuser\n\ube44\ubc00\ubc88\ud638 \uc785\ub825:\nSQL> CREATE TABLE tbl_post (\n    idx             NUMBER(20)                          NOT NULL,\n    title           VARCHAR2(100)                       NOT NULL,\n    content         VARCHAR2(3000)                      NOT NULL,\n    writer          VARCHAR2(20)                        NOT NULL,\n    view_cnt        NUMBER(4)       DEFAULT 1           NOT NULL,\n    delete_yn       NUMBER(1)       DEFAULT 0           NOT NULL,\n    created_date    DATE            DEFAULT SYSDATE     NOT NULL,\n    modified_date   DATE            DEFAULT             NULL\n);\n\ud14c\uc774\ube14\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n\nSQL> ALTER TABLE tbl_post ADD CONSTRAINT idx_pk PRIMARY KEY (idx);\n\ud14c\uc774\ube14\uc774 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n\nSQL> CREATE SEQUENCE idx_seq START WITH 1;\n\uc2dc\ud000\uc2a4\uac00 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/code><\/pre>\n
DB \uba85 \ud655\uc778\ubc29\ubc95<\/h2>\n
sqlplus\n\uc0ac\uc6a9\uc790\uba85 \uc785\ub825: c##myuser\n\ube44\ubc00\ubc88\ud638 \uc785\ub825:\n\nSQL> SELECT NAME, DB_UNIQUE_NAME FROM v$database;\n\nNAME               DB_UNIQUE_NAME\n------------------ ------------------------------------------------------------\nXE                 XE<\/code><\/pre>\n
SID \ud655\uc778\ubc29\ubc95<\/h2>\n
SQL> SELECT instance FROM v$thread;\n\nINSTANCE\n--------------------------------------------------------------------------------\nxe<\/code><\/pre>\n
```\n\n```bash<\/code><\/pre>\n
<\/code><\/pre>\n
<\/code><\/pre>\n
<\/code><\/pre>\n
<\/code><\/pre>\n
<\/code><\/pre>\n
<\/code><\/pre>\n
<\/code><\/pre>\n
<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Oracle – \uae30\ucd08 \uba85\ub839 \uacc4\uc815 \uc0dd\uc131 \uc624\ub77c\ud074 12c \ubd80\ud130 c## \uc744 \ubd99\uc5ec\uc57c \ud569\ub2c8\ub2e4. sqlplus …… \uc0ac\uc6a9\uc790\uba85 \uc785\ub825: system \ube44\ubc00\ubc88\ud638 \uc785\ub825: …… SQL> conn\/as sysdba \uc5f0\uacb0\ub418\uc5c8\uc2b5\ub2c8\ub2e4. SQL> create user myuser identified by mypass; create user myuser identified by mypass ORA-65096: \uacf5\ud1b5 \uc0ac\uc6a9\uc790 \ub610\ub294 \ub864 \uc774\ub984\uc774 \ubd80\uc801\ud569\ud569\ub2c8\ub2e4. SQL> create user c##myuser identified by mypass; \uc0ac\uc6a9\uc790\uac00 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4. SQL>\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-8721","post","type-post","status-publish","format-standard","hentry","category-devops"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8721"}],"version-history":[{"count":3,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8721\/revisions"}],"predecessor-version":[{"id":8724,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8721\/revisions\/8724"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}