Oracle8 Administrator's Reference for LINUX Release 8.0.5 A66585-01 |
|
SQL*Plus¸¦ À§ÇÑ ¼³Á¤ ÆÄÀÏÀº, site profileÀ» ¼³Á¤ÇÏ´Â ÀüüÀûÀÎ ¼³Á¤ÆÄÀÏÀÎ glogin.sql
°ú, »ç¿ëÀÚ profileÀ» Á¤ÀÇÇÏ´Â login.sql
ÀÌ ÀÖ´Ù. glogin.sql
°ú login.sql
filesÀº SQL*Plus sessionÀÌ ½ÃÀÛµÉ ¶§ ½ÇÇàµÉ SQL¹®ÀåÀ̳ª ¶Ç´Â SQL*Plus ¸í·É¾î¸¦ Æ÷ÇÔÇÑ´Ù. ¿©·¯ºÐµéÀÌ SQL*Plus¸¦ ½ÇÇàÇÒ ¶§ glogin.sql
¸¦ ¸ÕÀú ÀÐ°í ³ ´ÙÀ½ login.sql
¸¦ ÀÐ°Ô µÈ´Ù.
Site profile ÆÄÀÏÀº $ORACLE_HOME/sqlplus/admin/glogin.sql
ÀÌ´Ù.
SQL*Plus´Â »ç¿ëÀÚ°¡ SQL*Plus¸¦ ½ÃÀÛÇÒ ¶§¸¶´Ù, ±×¸®°í SQL*Plus°¡ ¿À¶óŬ°úÀÇ
¿¬°áÀ» ½ÃµµÇÒ ¶§¸¶´Ù ¸í·É¾î ÆÄÀÏÀ» ½ÇÇàÇÑ´Ù. ±âº»ÀûÀÎ Site ProfileÀº SQL*Plus°¡
¼³Ä¡µÉ ¶§¸¶´Ù $ORACLE_HOME/sqlplus/admin
¿¡ ³õÀÌ°Ô µÈ´Ù.
¸¸¾à Site ProfileÀÌ ÀÌ¹Ì Á¸ÀçÇÑ´Ù¸é, µ¤¾î ¾²±â°¡ µÈ´Ù. SQL*Plus°¡ Á¦°ÅµÉ ¶§¿¡´Â
ÀÌ¹Ì ÀÖ´Â Site Profileµµ Á¦°ÅµÈ´Ù.
User Profile file˼ login.sql
ÀÌ´Ù. SQL*Plus´Â Ç×»ó »ç¿ëÀÚ ÇÁ·ÎÆÄÀÏÀ» ÇöÀç µð·ºÅ丮¿¡¼ ¸ÕÀú ã´Â´Ù. SQL*Plus°¡ ãÀ» ¼ø¼´ë·Î »ç¿ëÀÚ ÇÁ·ÎÆÄÀÏÀÌ ÀÖ´Â µð·ºÅ丮¸¦ SQLPATH¶ó´Â ȯ°æº¯¼ö¿¡ colonÀ¸·Î ºÐ¸®µÈ µð·ºÅ丮 ¸®½ºÆ®¸¦ ¸í½ÃÇÒ ¼ö ÀÖ´Ù.
¿¹¸¦ µé¸é, ¸¸¾à ÇöÀç µð·ºÅ丮°¡ /u02/oracle
ÀÌ°í SQLPATH °¡ ´ÙÀ½ °ú °°ÀÌ ¼³Á¤µÇ¾î ÀÖ´Ù¸é:
% echo $SQLPATH /home:/home/oracle:/u01/oracle
SQL*Plus´Â ¸ÕÀú ÇöÀç µð·ºÅ丮ÀÎ /u02/oracle
¿¡¼ login.sql
À» ã´Â´Ù. ¸¸¾à ¿©±â¼ ¹ß°ßÇÒ ¼ö ¾ø´Ù¸é, SQL*Plus´Â /home
, /home/oracle
±×¸®°í /u01/oracle
µð·ºÅ丮¸¦ °¢°¢ ã°Ô µÈ´Ù.
¿©±â login.sql
fileÀÇ »ùÇÃÀÌ ÀÖ´Ù:
set echo off set feedback 4 set pause on set pause "PLEASE PRESS RETURN TO CONTINUE" set message on set echo on
SQL scriptÀÎ $ORACLE_HOME/sqlplus/admin/pupbld.sql
Àº Product¿Í User Profile tableÀ» ¸¸µé±â À§Çؼ »ç¿ëÀÚ SYSTEMÀ¸·Î¼ ½ÇÇàµÉ °ÍÀÌ´Ù.
$ORACLE_HOME/sqlplus/admin/pupbld.sql
˼ $ORACLE_HOME/bin/pupbld
shell script¸¦ ÀÌ¿ëÇؼ ½ÇÇàµÉ °ÍÀÌ´Ù. ÀÌ ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇϱâ À§Çؼ´Â, ȯ°æº¯¼ö ORACLE_HOME°ú SYSTEM_PASS °¡ ¹Ýµå½Ã ¼³Á¤µÇ¾î ÀÖ¾î¾ß ÇÑ´Ù. SYSTEM_PASS´Â SYSTEMÀÇ »ç¿ëÀÚ À̸§°ú ¾ÏÈ£¸¦ ¹Ýµå½Ã ¼³Á¤ÇØ¾ß ÇÑ´Ù. ¿¹¸¦ µé¸é:
% setenv SYSTEM_PASS SYSTEM/manager % pupbld Installing product user profile tables... Product user profile tables installed.
¸¸¾à µ¥ÀÌÅͺ£À̽º °´Ã¼°¡ ¼±Åõȴٸé, pupbld.sql
Àº SQL*Plus ¼³Ä¡ÇÏ´Â µ¿¾È Installer¿¡ ÀÇÇؼ¸¸ ½ÇÇàµÉ ¼ö ÀÖ´Ù.
SQL*Plus´Â Å×½ºÆ®¸¦ À§Çؼ »ç¿ëµÉ µ¥¸ð Å×À̺íÀÌ Æ÷ÇԵǾî ÀÖ´Ù.
¸¸¾à ±âº» ¼³Ä¡¸¦ ÀÌ¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º °´Ã¼¸¦ »ý¼ºÇϸé, »ç¿ëÀÚ SCOTT¿Í µ¥¸ð Å×À̺íÀº ÀÚµ¿À¸·Î »ý¼ºµÉ °ÍÀÌ´Ù.
Ä¿½ºÅÒ ¼³Ä¡¸¦ ÀÌ¿ëÇÏ¿© SQL*Plus¸¦ ¼³Ä¡ÇÒ ¶§, ¸¸¾à Create Database Object¸¦ ¼±ÅÃÇÏ°í, ¿©·¯ºÐµéÀÌ "Would you like to load the SQL*Plus Demo Tables?"¶ó´Â Áú¹®¿¡ 'Yes'¶ó°í ´äÇϸé, Installer´Â TIGER¶ó´Â ¾ÏÈ£¸¦ °¡Áø SCOTT¶ó´Â »ç¿ëÀÚ¸¦ ¸¸µé°í µ¥¸ð Å×À̺íÀ» »ý¼ºÇÑ´Ù.
SQL ½ºÅ©¸³Æ® $ORACLE_HOME/sqlplus/demo/demobld.sql
´Â µ¥¸ð ÆÄÀÏÀ» »ý¼ºÇϱâ À§ÇØ »ç¿ëµÈ´Ù. demobld.sql
ÆÄÀÏÀº shcema¿¡¼ µ¥¸ð Å×À̺íÀ» ¸¸µé°í ¾î¶² »ç¿ëÀڷμ SQL*Plus ³»¿¡¼ ½ÇÇàµÈ´Ù. ¿¹¸¦ µé¸é:
% sqlplus scott/tiger SQL> @?/sqlplus/demo/demobld.sql
$ORACLE_HOME/sqlplus/demo/demobld.sql
´Â shell script $ORACLE_HOME/bin/demobld
¸¦ ÀÌ¿ëÇÏ¿© ´ÙÀ½°ú °°ÀÌ ½ÇÇàµÉ °ÍÀÌ´Ù:
% demobld scott tiger
SQL scriptÀÎ $ORACLE_HOME/sqlplus/demo/demodrop.sql
Àº µ¥¸ð Å×À̺íÀ» drop Çϴµ¥ ÀÌ¿ëÇÑ´Ù. demodrop.sql
ÆÄÀÏÀº »ç¿ëÀÚÀÇ schema·Î ºÎÅÍ µ¥¸ð Å×À̺íÀ» drop Çϱâ À§Çؼ ¾î¶² »ç¿ëÀڷμ SQL*Plus¸¦ ½ÇÇàÇÑ´Ù. ¿¹¸¦ µé¸é:
% sqlplus scott/tiger SQL> @?/sqlplus/demo/demodrop.sql
$ORACLE_HOME/sqlplus/demo/demodrop.sql
´Â shell script $ORACLE_HOME/bin/demodrop
¸¦ ÀÌ¿ëÇؼ ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇÒ ¼ö ÀÖ´Ù:
% demodrop scott tiger
¸¸¾à ±âº» ¼³Ä¡¿Í Create Database Object¸¦ ¼±ÅÃÇϸé, Help Facility´Â ÀÚµ¿À¸·Î ¼³Ä¡µÈ´Ù.
SQL*Plus¸¦ ¼³Ä¡ÇÒ ¶§, ¸¸¾à Create Database Objects¸¦ ¼±ÅÃÇÏ°í ¿©·¯ºÐµéÀÌ "Would you like to load the SQL*Plus Help Facility?"¶ó´Â Áú¹®¿¡ 'Yes'¶ó°í ´ë´äÇß´Ù¸é, Installer´Â Help Facility¸¦ »ý¼ºÇÏ°Ô µÈ´Ù.
Installing the Help Facility Manually
Help Facility´Â $ORACLE_HOME/bin/helpins
shell script¸¦ ÀÌ¿ëÇؼ ¼öÀÛ¾÷À¸·Î ¼³Ä¡ÇÒ ¼ö ÀÖ´Ù. ÀÌ ½ºÅ©¸³Æ®¸¦ ÀÌ¿ëÇϱâ À§Çؼ´Â ȯ°æº¯¼ö ORACLE_HOME °ú SYSTEM_PASS°¡ ¹Ýµå½Ã ¼³Á¤µÇ¾î ÀÖ¾î¾ß ÇÑ´Ù. SYSTEM_PASS´Â SYSTEMÀÇ »ç¿ëÀÚ À̸§°ú ¾ÏÈ£°¡ ¼³Á¤µÇ¾î ÀÖ¾î¾ß ÇÑ´Ù. ¿¹¸¦ µé¸é:
$ setenv SYSTEM_PASS SYSTEM/manager $ helpins SQL*Loader: Release 8.0.5.0.0 - Production (c) Copyright 1998 Oracle Corporation. All rights reserved. Commit point reached - logical record count 828 SQL*Loader: Release 8.0.5.0.0 - Production (c) Copyright 1998 Oracle Corporation. All rights reserved. Commit point reached - logical record count 1024 Commit point reached - logical record count 1207 SQL*Loader: Release 8.0.5.0.0 - Production (c) Copyright 1998 Oracle Corporation. All rights reserved. Commit point reached - logical record count 1024 Commit point reached - logical record count 1304 Commit point reached - logical record count 2328 Commit point reached - logical record count 2724 Commit point reached - logical record count 2835
ÂüÁ¶:
SQL*Plus User's Guide and Reference¸¦ ÂüÁ¶Ç϶ó. ±×¸®°í |
SQL*Plus ÇÁ¶÷ÇÁÆ®¿¡¼ ed
¶Ç´Â edit
¸í·É¾î¸¦ ÀÔ·ÂÇϸé, ed, emacs, ned
¶Ç´Â vi
¿Í °°Àº ±âº»ÀûÀÎ ½Ã½ºÅÛ ÆíÁý±â¸¦ È£ÃâÇÑ´Ù. ¿©·¯ºÐµéÀÇ PATH ȯ°æº¯¼ö¿¡´Â À̵é ÆíÁý±âÀÇ µð·ºÅ丮°¡ Æ÷ÇԵǾî ÀÖ¾î¾ß ÇÑ´Ù.
ÀüüÀûÀÎ ±âº» ÆíÁý±â´Â glogin.sql
³»¿¡¼ SQL*Plus _editor
optionÀ» ÀÌ¿ëÇؼ DBA¿¡ ÀÇÇØ ¼³Á¤µÈ´Ù. ÀÌ ¼³Á¤À» ´Ù¸¥°ÍÀ¸·Î ¹Ù²Ù±â À§Çؼ´Â login.sql
³»¿¡ ÆíÁý±â¸¦ ¸í½Ã ÇØ ÁÖ¾î¾ß ÇÑ´Ù. µÎ ÆÄÀÏ ´Ù SQL*Plus°¡ ½ÃÀ۽ÿ¡ ÀÐ¾î µéÀÌ°Ô µÇ´Â µ¥ local fileÀÌ ¿ì¼±±ÇÀ» °¡Áö°Ô µÈ´Ù. _editor
option Àº µÎ ÆÄÀÏ ¾îµð¼µçÁö SQL*Plus ¼¼¼±µ¿¾È¿¡ ¼³Á¤µÉ ¼ö ÀÖ´Ù.
¸¸¾à _editor
optionÀÌ ¼³Á¤µÇ¾î ÀÖÁö ¤·³ºÀ¸¸é, EDITOR¿Í VISUAL À̶ó´Â ȯ°æº¯¼ö°¡ SQL*Plus editor¸¦ ¼³Á¤ÇÏ°Ô µÈ´Ù. ±×µéÀº »ç¿ëÀÚÀÇ ½ÃÀÛ ÆÄÀÏÀ̳ª ¶Ç´Â ½Ã½ºÅÛ ÇÁ·ÒÇÁÆ®¿¡¼ ¼³Á¤µÈ´Ù. ¸¸¾à µÑ´Ù ¼³Á¤µÇ¾î ÀÖÀ¸¸é EDITOR¶ó´Â º¯¼ö°¡ ÀÌ¿ëµÈ´Ù.
SQL*Plus´Â ´ÙÀ½ ¼ø¼¿¡ µû¶ó ±âº» ÆíÁý±â¸¦ ¼³Á¤ÇÏ°Ô µÈ´Ù:
_editor
SQL*Plus sessionµ¿¾È ¼³Á¤µÈ º¯¼ö.
login.sql
³»¿¡ ÀÖ´Â _editor
º¯¼ö.
glogin.sql
³»¿¡ ÀÖ´Â _editor
º¯¼ö.
ÀÌµé º¯¼ö Áß ¾î´À°Íµµ ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì, SQL*Plus´Â ed
¸¦ »ç¿ëÇÑ´Ù.
login.sql
file³»¿¡ ´ÙÀ½ ÁÙÀ» Ãß°¡ÇÏ¿© SQL*Plus _editor
optionÀ» ¼³Á¤ÇÑ´Ù:
define _editor=editor_name
¿©±â¼ editor_name ´Â ¸®´ª½ºÀÇ ÆíÁý±â À̸§ÀÌ´Ù.
Bourne ¶Ç´Â Korn shell¿¡¼´Â, ´ÙÀ½°ú °°ÀÌ È¯°æº¯¼ö¸¦ ÀÔ·ÂÇÏ¿© ±âº» ÆíÁý±â¸¦ ¼³Á¤ÇÑ´Ù:
$ LINUX_VAR=editor_name; export LINUX_VAR
C shell¿¡¼´Â, ´ÙÀ½°ú °°ÀÌ È¯°æ º¯¼ö¸¦ ÀÔ·ÂÇÏ¿© ±âº» ÆíÁý±â¸¦ ¼³Á¤ÇÑ´Ù:
ȯ°æº¯¼ö ¹®¹ýÀº Table 4-1¿¡ ¼³¸íµÇ¾î ÀÖ´Ù.
LINUX_VAR |
EDITOR ¶Ç´Â VISUAL ȯ°æ º¯¼ö |
editor_name |
LINUX ÆíÁý±â (¿¡¸¦ µé¸é, |
¸¸¾à ¿©·¯ºÐµéÀÌ system editor¸¦ È£ÃâÇÒ °æ¿ì, ÇöÀçÀÇ SQL buffer´Â edit buffer ³»¿¡ ³õÀÌ°Ô µÇ°í ÆíÁý±â¿¡¼ ÀÌ¿ë°¡´ÉÇÑ ¸ðµç ¸í·É¾î´Â SQL ¹®ÀåÀ» ¹Ù²Ü¼ö ÀÖ´Ù. SQL*Plus´Â afiedt.buf
¶ó´Â ÀÓ½ÃÆÄÀÏÀ» »ç¿ëÇÑ´Ù. ¿©·¯ºÐµéÀÌ ÆíÁý±â¸¦ Á¾·áÇÒ ¶§, ¹Ù²ï SQL buffer´Â SQL*Plus·Î µ¹¾Æ°¡°Ô µÈ´Ù.
SQL*Plus ÇÁ·ÒÇÁÆ® ¹Ù·ÎµÚ ù±ÛÀÚ·Î ´À³¦Ç¥ (!)¸¦ Àû¾î ÁÖ¸é ¹Ù·Î µÚÀÌ¾î ¿À´Â ¹®ÀÚ¿µéÀº sub-sell·Î Àü´Þ½ÃÅ°¶ó´Â °ÍÀ» ÀÇ¹Ì ÇÑ´Ù. SHELL ȯ°æº¯¼ö¿¡¼ ¿©·¯ºÐµéÀÌ ¸í·É¾î¸¦ ½ÇÇà½Ãų shellÀÇ Á¾·ù¸¦ ¼±ÅÃÇÑ´Ù. ±âº» shellÀº /bin/sh (sh)
ÀÌ´Ù. ¸¸¾à shellÀ» ½ÇÇàÇÒ ¼ö ¾ø´Ù¸é, error message°¡ Ãâ·ÂµÉ °ÍÀÌ´Ù.
´ÙÀ½ SQL*Plus commands¸¦ ÀÌ¿ëÇÏ¿© Ư¼öÇÑ ÀÛ¾÷À» ¼öÇàÇÑ´Ù:
SQL*Plus¸¦ ½ÇÇàÇÏ´Â Áß°£¿¡:
SPOOL ¸í·É¾î¿¡ ÀÇÇؼ »ý¼ºµÇ´Â ÆÄÀÏÀÇ ±âº» È®ÀåÀÚ´Â .lst
ÀÌ´Ù. ÀÌ È®ÀåÀÚ¸¦ º¯°æÇϱâ À§ÇÏ¿©, period (.)¸¦ Æ÷ÇÔÇÏ´Â spool ÆÄÀÏÀ» ¸í½ÃÇØ¾ß ÇÑ´Ù.
¿¹¸¦ µé¸é:
SQL> SPOOL query.lis
SQL*Plus¿¡¼ COPY
¸í·É¾î´Â °°Àº ¹öÁ¯ÀÇ ¿î¿µÃ¼°è°¡ ½ÇÇàÁßÀÎ ´Ù¸¥ machine¿¡ ´ëÇؼµµ Á¦ÇѾøÀÌ Áö¿øµÈ´Ù.
COPY
´Â ´Ù¸¥ ¹öÁ¯ÀÇ ¿î¿µÃ¼°è¸¦ ¿î¿µÁßÀÎ machine »çÀÌ¿¡µµ ÀÛµ¿ÇÑ´Ù. ¸¸¾à COPY
°¡ ½ÇÆÐÇÒ °æ¿ì, rcp
³ª ftp
¸¦ ÀÌ¿ëÇÏ¿© Á¢¼ÓÇÏ¿© °Ë»çÇϱ⠹ٶõ´Ù. Á¦ÇÑÁ¡Àº °¢°¢ÀÇ È¸»ç¿¡¼ Á¦°øÇÏ´Â ³ÝÆ®¿öÅ· ¼ÒÇÁÆ®¿þ¾î¿¡¼ ½Ã½ºÅÛ »çÀÌ¿¡¼ ÀûÀýÈ÷ µ¿ÀÛÇÏ´Â rcp
, ftp
¶Ç´Â COPY
¸í·ÉÀ» ¸·À» ¼öµµ ÀÖ´Ù´Â °ÍÀÌ´Ù.
ÁÖÀÇ:
|
¸¸¾à COPY
°¡ ½Ã½ºÅÛµé °£¿¡ ±â´ÉÀ» ÇÏÁö ¾Ê´Â´Ù¸é, ¿©·¯ºÐµéÀÌ copyÇϱ⸦ ¿øÇÏ´Â Å×À̺íÀ» °¡¸£Å°´Â »ç¿ëÀÚ ID ¿Í ½Ã½ºÅÛÀ¸·Î µ¥ÀÌÅͺ£À̽º ¸µÅ©¸¦ »ý¼ºÇØ µÎ¾î¶ó. ÀÌ·¸°Ô Çϱâ À§Çؼ ´ÙÀ½°ú °°ÀÌ ÀÔ·ÂÇ϶ó:
SQL> create table newtable as \ (SELECT * FROM table@database_link_name)
ÀÌ°ÍÀº ¿ø°Ý ½Ã½ºÅÛ¿¡ µé¾î°¡ ÀÖ´Â µ¥ÀÌÅͺ£À̽º·Î ºÎÅÍ rows¿Í columnsÀ» select Çس»¾î ·ÎÄà ½Ã½ºÅÛ¿¡ »õ·Î¿î Å×À̺í·Î ÀÔ·ÂÇÏ¿© ÁØ´Ù.
SQL*Plus LINESIZE ÀÇ ±âº»°ªÀº 80À̸ç PAGESIZEÀÇ ±âº» °ªÀº 25ÀÌ´Ù. ÀÌµé º¯¼öµéÀº À©µµ¿ìÀÇ Å©±â¿¡µû¶ó ÀÚµ¿À¸·Î ¼³Á¤µÇÁö ¾Ê´Â´Ù.
LINUXÀÇ º¹±Í°ªÀº ¿ÀÁ÷ ÇÑ ¹ÙÀÌÆ®¸¸ÀÌ ÀÌ¿ë°¡´ÉÇÏ´Ù. ÀÌ°ÍÀº ¿À¶óŬÀÇ ¿¡·¯Äڵ带 µ¹·ÁÁִµ¥ ÃæºÐÇÏÁö ¸øÇÏ´Ù. º¹±Í°ªÀÇ ¹üÀ§´Â 0 ºÎÅÍ 255±îÁö ÀÌ´Ù.