- Äɲ䵤줿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
- ºï½ü¤µ¤ì¤¿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
// ²¼³¬ÁØÍѥƥó¥×¥ì¡¼¥È
#topicpath
----
//¤³¤³¤Ë¥³¥ó¥Æ¥ó¥Ä¤òµ½Ò¤·¤Þ¤¹¡£
#contents
Oracle¤Ï¤Û¤È¤ó¤ÉÃΤé¤Ê¤¤¤Î¤Ç¡¢¤È¤ê¤¢¤¨¤ºÈ÷˺¡£
**³°Éô¥¡¼¤Î°ìÍ÷ [#maee463b]
SQL Plus¤Ê¤É¤Ç³ºÅö¥¹¥¡¼¥Þ¤Î¥æ¡¼¥¶¤Ç¥í¥°¥¤¥ó¤·¤Æ°Ê²¼¤ÎSQL¤ò¼Â¹Ô¡£
select CONSTRAINT_NAME,TABLE_NAME,STATUS from
USER_CONSTRAINTS where CONSTRAINT_TYPE = 'R'
¥Æ¡¼¥Ö¥ë̾¤ÈFK̾¡¢¤½¤ì¤¬Í¸ú¾õÂÖ¤«¤ò³Îǧ¤Ç¤¤Þ¤¹¡£
SQL> select count(*) from USER_CONSTRAINTS where
CONSTRAINT_TYPE = 'R' and status='ENABLED';
COUNT(*)
----------
0
SQL> select count(*) from USER_CONSTRAINTS where
CONSTRAINT_TYPE = 'R' and status='DISABLED';
COUNT(*)
----------
39
¤³¤ó¤Ê´¶¤¸¤Ç¤¹¡£
**¥´¥ß¥Æ¡¼¥Ö¥ë¤Îºï½ü [#p044b50d]
purge user_recyclebin;
**SQL*Plus¤ÎTIPS [#e895e9d8]
***ÊÌ¥µ¡¼¥Ð¤ÎOracle¤ËÀܳ¤¹¤ë [#aab6e086]
-bash-3.2$ sqlplus hoge/pass@192.168.10.100:1521/xe
¤Ê¤É¤ÇOK!
***³°Éô¥Õ¥¡¥¤¥ë¤«¤éSQL¼Â¹Ô [#g41782bf]
sqlplus user/pass @hogehoge.sql
¤Çhogehoge.sql¤ÎSQL¤¬¼Â¹Ô¤Ç¤¤ë
***hogehoge.sql¤Îʸˡ [#jef18876]
-SQL*Plus¤Ï¤É¤¦¤â°ì¥«¥é¥à¤¢¤¿¤ê¤ÎÉý¤¬¶¹¤¯¡¢¤¹¤°¤ËÀÞ¤êÊÖ¤·¤Á¤ã¤¦¡£
set linesize 9999
¤Ç²£¤Ë¤É¡¼¤ó¤È¹¤¤É½¼¨¤Ë¤Ê¤ë¡£¡£
-SQL*Plus¤Ï¤¹¤°¤Ë¥Ø¥Ã¥À(¥«¥é¥à̾)¤òÁÞÆþ¤·¤Á¤ã¤¦¡£
set pagesize 10000
¤È¤«¤Ç¥Ø¥Ã¥À¤òÁÞÆþ¤·¤Ê¤¤¤è¤¦¤Ë¤¹¤ë
-¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤¹ÊýË¡¡£¤É¤¦¤âhogehoge.sql¤Ç
spool result.txt
SQLʸ¡£
spool off
exit
¤È¤¹¤ë¤È½ÐÎÏ·ë²Ì¤ò¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤¹¤ß¤¿¤¤¡£
***SQL*Plus¤ÈTeraTerm¤Çüâ¤Ê¤É¤¬Ê¸»ú²½¤±¤¹¤ë [#mb64a834]
DB¤Îʸ»ú¥³¡¼¥É¤òJA16SJISTILDE¤È¤·¤Æ¤¤¤ë¤È¤¡¢TerraTerm¤Çselect¤·¤Æ¤ß¤ë¤Èü⤬ʸ»ú²½¤±¤·¤Æ¤¿¡£¡£
export NLS_LANG=Japanese_Japan.JA16SJISTILDE
¤È¤·¤Æ´Ä¶ÊÑ¿ô¤òÀßÄꤷ¡¢¤µ¤é¤ËTeraTerm¤òSJIS¤Ë¤·¤Æ¤ª¤±¤ÐOK¤Ç¤¹¡£
***¥æ¡¼¥¶¤Îºï½ü [#i8c0fe81]
SQL> drop user hogehoge cascade;
**DB¤ÎExport,Import [#jdecb75d]
DB¥µ¡¼¥Ð¤Ëoracle¥æ¡¼¥¶¤Ç¥í¥°¥¤¥ó¤·¡¢²¼µ¥³¥Þ¥ó¥É¤ò¼Â¹Ô
exp hoge/fuga@xe owner=hoge file=hoge.20070709.dmp statistics=none
°ÕÌ£¤Ï¡Öhoge¥æ¡¼¥¶¤Ç¥¹¥¡¼¥Þhoge¤Î¥Æ¡¼¥Ö¥ë¤òÁ´¤Æ¥À¥ó¥×((¥¤¥ó¥¹¥¿¥ó¥¹¤Ïxe))¡×¡£
exp userid=hoge/fuga tables=TABLE1 file=hoge_TABLE1.20070709.dmp statistics=none
¤Æ¥Æ¡¼¥Ö¥ë»ØÄê¤â²Äǽ¤Ç¤¹¡£
import¤Ï°Ê²¼¤ÎÄ̤ê
imp userid=hoge2/fuga2 tables=TABLE1 fromuser=hoge touser=hoge2 file=hoge_TABLE1.20070709.dmp ignore=y
fromuser:¸µ¤Î¥æ¡¼¥¶ touser:¤Ê¤ó¤Æ¥¹¥¡¼¥Þ¤ËÆþ¤ì¤ë¤«¡£
----
¤³¤Îµ»ö¤Ï
#vote(¤ª¤â¤·¤í¤«¤Ã¤¿[1],¤½¤¦¤Ç¤â¤Ê¤¤[1])
- linesize¤Ï¹Ô¤¹¤Ù¤Æ¤¬´Ö±ä¤Ó¤·¤Þ¤¹¡£ÆÃÄêÎó¤Î¤ß¤Î¥µ¥¤¥ºÊѹ¹¤Ï¡¡column <column_name> format a10¡¡¤Ê¤É¤È¤·¤Þ¤¹ -- [[KY]] &new{2007-10-12 (¶â) 19:00:47};
#comment
#topicpath
SIZE(10){¸½ºß¤Î¥¢¥¯¥»¥¹:&counter;}