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

Íü¼Çoracle 9iÃÜÂë

Íü¼ÇÁËoracle 9iµÄËùÓÐÃÜÂ룬ËùÓеÄÓû§sys  system  sysman  scottµÈµÈ£¬ÒÔ¼°ÍøÉÏ˵µÄºÜ¶à·½·¨£¬Èç3.sqlplus / as sysdba;
4.alter user sys identified by 123; 5.alter user system identified by 123; µÈµÈ¶¼Ã»ÓÐÓã¡ÎÒÍü¼ÇÁËËùÓеÄÓû§ÃÜÂ룬½øSQL*PLUS¶¼²»Äܽø
£¬ÐҺû¹¿ÉÒÔͨ¹ýÃüÁîÐнøÈ¥£¬µ«ÊǽøÈ¥ÁËҲûÓ㬲»ÖªµÀÓÃÄĸöÓû§Á¬½Ó£¿£¿Ë­ÄܸæËßÎÒ¸ÃÔõô°ì°¡¡£¡£¡£¡£
¿ÉÒÔÖØÐ´´½¨ÃÜÂëÎļþ
ÔÚʹÓÃOracle Instance Manager´´½¨Ò»Êý¾Ý¿âʵÀýµÄʱºî£¬ÔÚORACLE_HOME£ÜDATABASEĿ¼Ï»¹×Ô¶¯´´½¨ÁËÒ»¸öÓëÖ®¶ÔÓ¦µÄÃÜÂëÎļþ£¬ÎļþÃûΪ PWDSID.ORA£¬ÆäÖÐSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£´ËÃÜÂëÎļþÊǽøÐгõʼÊý¾Ý¿â¹ÜÀí¹¤×÷µÄ»ù´£ÔÚ´ËÖ®ºó£¬¹ÜÀíÔ±Ò²¿ÉÒÔ¸ù¾ÝÐèÒª£¬Ê¹Óù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨ÃÜÂëÎļþ£¬ÃüÁî¸ñʽÈçÏ£º

C:£Ü >ORAPWDFILE=£¼ FILENAME £¾PASSWORD =£¼ PASSWORD £¾ ENTRIES= < MAX_USERS >

¸÷ÃüÁî²ÎÊýµÄº¬ÒåΪ£º

FILENAME£ºÃÜÂëÎļþÃû£»

PASSWORD£ºÉèÖÃINTERNAL£¯SYSÕʺŵĿÚÁ

MAX_USERS£ºÃÜÂëÎļþÖпÉÒÔ´æ·ÅµÄ×î´óÓû§Êý£¬¶ÔÓ¦ÓÚÔÊÐíÒÔSYSDBA£¯SYSOPERȨÏ޵ǼÊý¾Ý¿âµÄ×î´óÓû§Êý¡£ÓÉÓÚÔÚÒÔºóµÄά»¤ÖУ¬ÈôÓû§Êý³¬³öÁË´ËÏÞÖÆ£¬ÔòÐèÒªÖØ½¨ÃÜÂëÎļþ£¬ËùÒԴ˲ÎÊý¿ÉÒÔ¸ù¾ÝÐèÒªÉèÖõôóһЩ¡£

ͬÒâÂ¥ÉÏ£¡

°´´Ë·½·¨¼üÈë¡£ÃüÁîÐÐÎÞ·µ»ØÐÅÏ¢£¬Ìø»Ø³õʼµÄ״̬¡£²¹³äÏ£¬ÎÒÔÚCÅÌûÕÒµ½PWDSID.ORAÕâ¸öÎļþ£¬ÊDz»ÊÇÓÐÎÊÌâÄØ£¿  ÎÒÓÃÍøÉÏ˵µÄ×î¶àµÄ·½·¨alter user sys identified by 123£¬°´»Ø³µºó£¬·µ»Ø2£¬²»ÖªµÀʲôÒâ˼£¡Ôõô±ðÈ˶¼ËµÕâ¸öϵͳÈÏÖ¤·½·¨¿ÉÐУ¬ÎҾͲ»Ðа¡··

ÒýÓÃ
°´´


Ïà¹ØÎÊ´ð£º

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

ÊÇ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 Òì³£µÄ²¶»ñÎÊÌâ

ÎÒÏÈ˵Ã÷Ò»ÏÂÇé¿ö£ºÓÐÒ»¸örec1.batµÃÅú´¦ÀíÎļþÀï±ß´úÂëÈçÏ£º
SET ORACLE_SID=TosmecDB
sqlPLUS /nolog  "@c:\tosmec\sys\syscom\TosmecHotSub1.sql"

TosmecHotSub1.sqlµÄÎļþÄÚÈÝÈçÏ ......

ÀÏÎÊÌ⣺OracleÐÐתÁУ¨×Ö·û´®²ð·Ö£©

ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ