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

Oracle°²×°ÍêºóÍü¼Ç¸øÓû§½âËø¸ÃÔõô°ì£¿

        ÎÒµÄOracleÊý¾Ý¿â°²×°Íê±ÏºóÍüÁËÔÚ¡°¿ÚÁî¹ÜÀí¡±Àï¸øÓû§½âËøÁË£¬ÇëÎÊ»¹ÓÐʲô²¹¾È´ëÊ©Âð£¿ÎÒÊÇOracle³õѧÕߣ¬Çë˵µÃÏêϸд¡£Íò·Ö¸Ðл£¡  

sqlplus /nolog;

conn / as sysdba;

alter user ÄãµÄÓû§ account unlock;

alter user ÄãµÄÓû§ identified by ÄãµÄÃÜÂë;

conn ÄãµÄÓû§/ÄãµÄÃÜÂë;


systemºÍsysÓû§¶¼¿ÉÒÔÓÃ,ÒÔsystemÁ¬½ÓÊý¾Ý¿â,½øÈësqlplus,Ö´ÐÐ
ALTER USER myuser ACCOUNT UNLOCK;
±ÈÈçÒª¸øscott½âËø£¬Ôò
alter user scott account unlock;

Äã¿ÉÒÔÔÚ½âËøÊ±¾ÍÐÞ¸ÄÓû§¿ÚÁ
SQL code:
1.conn / as sysdba;--ÓÃdbaȨÏ޵Ǽϵͳ
2.alter user user_name account unlock identified by new_password;


ÒýÓÃ
systemºÍsysÓû§¶¼¿ÉÒÔÓÃ,ÒÔsystemÁ¬½ÓÊý¾Ý¿â,½øÈësqlplus,Ö´ÐÐ
ALTER USER myuser ACCOUNT UNLOCK;
±ÈÈçÒª¸øscott½âËø£¬Ôò
alter user scott account unlock;


ÕâÖÖ·½·¨¾Í¿ÉÒÔÁË¡£

ÒýÓÃ
Äã¿ÉÒÔÔÚ½âËøÊ±¾ÍÐÞ¸ÄÓû§¿ÚÁ
SQL code1.conn/as sysdba;--ÓÃdbaȨÏ޵Ǽϵͳ2.alteruseruser_name account unlock identifiedby  new_password;

UP

systemºÍsysÓû§¶¼¿ÉÒÔÓÃa

лл´ó¼Ò¡£ÎÒÊäÈëÁË¡°alter user system account unlock"Ö®ºóÇûسµ£¬³öÏÖÁËÒ»¸ö¡°2¡°£¬ÊDz»ÊǾͱíʾ½â


Ïà¹ØÎÊ´ð£º

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

oracleÄÚ´æÕ¼Óò»¶ÏÔö³¤ÎÊÌâ

Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿
Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡
¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡
which os ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ