Oracle´´½¨Óû§µÄÆæ¹ÖÎÊÌ⣿µÈ´ý¸ßÊÖ½â»ó
»·¾³ 10G
ʹÓÃem´´½¨Ò»¸öÓû§£¬Ò»ÇÐÕý³££¬
Óô´½¨Õâ¸öÓû§µÄ sqlÓï¾äÔÚ isql*plus ´´½¨ÁíÍâÒ»¸öÓû§
CREATE USER "Tim" PROFILE "DEFAULT" IDENTIFIED BY "*******" ACCOUNT UNLOCK
Ö»ÊÇÐÞ¸ÄÁËÓû§ÃûºÍÃÜÂë,Ò²Ìáʾ´´½¨³É¹¦¡£¶øÇÒÔÚemÀï±ß¿ÉÒÔ¿´µ½Õâ¸öÓû§ Tim
µ«ÊǽÓÏÂÀ´ Ö´ÐÐÊÚȨ²Ù×÷ grant create table to Tim
µÄʱºòÌáʾÎÒÓû§ºÍ½ÇÉ«²»´æÔÚ¡£
ºóÀ´·¢ÏÖÎ¨Ò»Çø±ðÊÇ£¬ÎÒʹÓÃem´´½¨µÄÓû§ÔÚemÀï±ßÏÔʾ¶¼ÊÇ´óдÃû×Ö£¨ÎÞÂÛÎÒ´´½¨µÄʱºòÊäÈë´óд»¹ÊÇСд£©
¶øÊ¹ÓÃisql*plus´´½¨µÄÓû§ ÔòÔÚemÀï±ßÏÔʾµÄÊÇÎÒµ±Ê±´´½¨Ê±ºòÊäÈëµÄ´óдС¹æÔò¡£
µ«ÕâÑùÔÙÊÚȨ¾ÍÊDz»ÐС£
ºóÀ´ÎÒ³¢ÊÔͬÑùµÄÓï¾ä£¬ÎÒ°ÑÓû§ÃûÈ«´óд£¬¾Í¶¼¿ÉÒÔÁË¡£
²éѯÓï¾äÀï±ßÎÒ´óСдÔõôÑù±ä»¯¶¼¿ÉÒԲ鵽Õâ¸öÓû§¡£¡£
ÕæÆæ¹Ö°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
¶¼ÊÇ""ÈǵĻö~
CREATE USER Tim PROFILE DEFAULT IDENTIFIED BY ******* ACCOUNT UNLOCK
SQL> CREATE USER "Tim" PROFILE "DEFAULT" IDENTIFIED BY "Tim" ACCOUNT UNLOCK;
Óû§ÒÑ´´½¨¡£
SQL> grant connect to tim;
grant connect to tim
*
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01917: Óû§»ò½ÇÉ« 'TIM' ²»´æÔÚ
SQL> grant connect to Tim;
grant connect to Tim
&nb
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......