oracleÊý¾Ý¿â´ò¿ªsql*plusʱÓöµ½ÎÊÌâ
ÎÒÏëѧoracle£¬¸Õ×°Íêoracle10g for Vista£»´ò¿ªSQL*Plusʱ£¬Èç¹ûµÚÒ»´ÎÊäÈëÕýÈ·µÄÓû§ÃûºÍ¿ÚÁî¾Í¿ÉÒÔ´ò¿ªËü£¬Èç¹ûµÚÒ»´ÎÊäÈë´íÎóµÄ£¬µÚ¶þ´ÎÔÙÊäÈëÕýÈ·µÄ£¬¾Í»áÌáʾÓû§Ãû/¿ÚÁîÓÐÎ󣬾ܾøµÇ¼£¬ÄÄλ¸ßÊÖÓÐʱ¼ä°ïÎÒ½âÊÍһϣ¬²¹³äһϣ¬ÓÃcmd´ò¿ªsqlplusʱ£¬Èç¹ûµÚÒ»ÊäÈë´íÎóÃÜÂ룬µÚ¶þ´ÎÊäÈëÕýÈ·ÃÜÂ룬ÊÇ¿ÉÒÔ´ò¿ªµÄ
SQL code:
--Óиö²ÎÊý£ºÓÃÒÔ¿ØÖƳ¢ÊÔÃÜÂë´ÎÊýµÄ
SQL code:
loginretries = 3
SQL code:
alter profile default limit failed_login_attempts 5;
3Â¥ÄǸöºÃÏñÊÇlinuxµÄ°É£¿
û¿´¶®Â¥Ö÷µÄÒâ˼£¬×öÁËЩ²Ù×÷. Â¥Ö÷²Î¿¼Ï£º
SQL code:
C:\Documents and Settings\user.HQ-TEXT>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚÁù 9ÔÂ 26 13:43:53 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/admin as sysdba; -- ÕýÈ·µÄÓû§ÃûºÍÃÜÂë
ÒÑÁ¬½Ó¡£
SQL> conn system/admin; -- ÕýÈ·µÄÓû§ÃûºÍÃÜÂë
ÒÑÁ¬½Ó¡£
SQL> conn system
ÊäÈë¿ÚÁî: --´íÎóµÄÃÜÂ룬ֱ½ÓÍ˳öÁ¬½Ó´°¿Ú£¬ÐèÒªÖØÐÂÁ¬½ÓÁË..
ERROR:
ORA-01017: invalid use
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......