oracleÆô¶¯¼àÌý
СÐÍ»ú²Ù×÷ϵͳÊÇAIX
ϵͳÆô¶¯µÄʱºòÐèÒªÆô¶¯¼àÌýºÍÈý¸öʵÀý£¬ÎÒÊÇÓÃÅú´¦ÀíÖ´Ðе쬴úÂëÈçÏ£º
su - oracle -c "lsnrctl start"
su - oracle -c "export ORACLE_SID=orcl1
sqlplus /nolog < < eof
conn /as sysdba
startup
eof"
su - oracle -c "export ORACLE_SID=orcl2
sqlplus /nolog < < eof
conn /as sysdba
startup
eof"
su - oracle -c "export ORACLE_SID=orcl3
sqlplus /nolog < < eof
conn /as sysdba
startup
eof"
ÿ´ÎÖ´ÐÐÖ®ºó¶¼ÊÇÈý¸öʵÀý¶¼ÆðÀ´ÁË£¬¼àÌýÈ´Æð²»À´£¬ÎÒÈç¹ûÖ±½ÓÔÚ¿ØÖÆÌ¨Ê¹ÓÃrootÖ´ÐÐsu - oracle -c "lsnrctl start"¿ÉÒÔÆô¶¯¼àÌý£¬ËµÃ÷ÃüÁîÓ¦¸ÃÊÇûÓÐÎÊÌâµÄ£¬¿É²»ÖªµÀΪʲôʹÓÃrootÓû§Ö´ÐÐÕâ¸öÅú´¦ÀíµÄʱºò¼àÌý¾ÍÆð²»À´¡£
su ÃüÁî²»ºÏÊʰɣ¿
sudo ¸üÊʺÏÕâÖÖÓ¦Óá£
ÓеÀÀí
ÓÃshell½Å±¾
sudo£¬»òÕßshell½Å±¾£¬ÄÜ˵µÄ¾ßÌåµãÂð£¿
¿ÉÒÔдһ¸öshell ½Å±¾ ×Ô¶¯Æô¶¯£¡
×îºóÔÙÆð¼àÌý£¿
studing
Ïà¹ØÎÊ´ð£º
Çë¸÷λ¸ßÊÖ°ïæ oracleºº×ÖתƴÒô
±ÈÈçÏÖÔÚÓиöÁÐ ÀïÃæµÄºº×ÖΪÄãºÃ ÎÒÏë²é³öÀ´µÄÊÇN ÇëÎʸ÷λ¸ßÊÖÈçºÎʵÏÖ ¸ø¸öÏêϸµÄ¿´¿´ лÁË
ÓÐÖªµÀµÄ¸æËßÒ»Éù ллÁË
ûÕÒµ½°¡ Äܸø·¢Ò»¸öÂð
ÄÄλ˧¸çÄܸøÏêϸµÄËµÒ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçÏÂ2ÕÅ±í£º
table1:
node_id
parent_id
root_id
value
table2:
node_id
status
±í1´æ´¢ÁËÒ»¿ÃÊ÷£¬±í2´æ´¢Á˽ڵã״̬£¬ÎÊÌâÈçÏ£º
ÈçºÎÓÃSQLÓï¾ä»ñµÃ״̬statusΪ1µÄ½ÚµãµÄËùÓÐ×Ó½ÚµãÒÔ¼°ÆäÏÂ×ÓÊ÷ÖÐËùÓÐ½Ú ......
OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐÊ²Ã´Çø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
ÒýÓÃ
constraintºÍc ......