Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸ö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 ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ