ASP.NETÅäÖÃOracleµÄÏà¹ØËµÃ÷
² Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
² Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
² Oracle9i°²×°³É¹¦ÒԺ󣬾ßÌåµÄȨÏÞÉèÖÃÈçÏ£º
1. ÒÔAdministratorȨÏ޵ǼWindows.
2. Æô¶¯Window ×ÊÔ´ä¯ÀÀÆ÷ÕÒµ½ORACLE_HOMEĿ¼£¬ÈçC:\Oracle\ora92
3. ÓÒ¼üµ¯³ö²Ëµ¥£¬Ñ¡Ôñ¸ÃĿ¼¹²ÏíÓ밲ȫ£¨Win2000ÏÂÒªµã»÷ÊôÐÔ£©
4. µã»÷ “°²È«” ҳǩ
5. ÔÚ×éºÍÓû§Ãû³ÆÁбíÖеã»÷“Authenticated Users” Ïî.
6. ÔÚ¸ÃÓû§µÄȨÏÞÁбíÖУ¬½«“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿òÖÃΪ²»Ñ¡ÖÐ״̬
7. Ôٴεã»÷“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿ò£¬½«ÆäÉèÖÃΪѡÖÐ״̬
8. µã»÷“¸ß¼¶”°´Å¥²¢ÔÚȨÏÞÏîÄ¿ÖÐÈ·¶¨“Authenticated Users” ÊÇ·ñÓµÓГ¶ÁÈ¡²¢ÔËÐДȨÏÞ²¢Ó¦ÓÃÓÚ“¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. Èç¹û²»ÊÇ£¬Ë«»÷ÕâÑù£¬²¢È·±£È¨ÏÞ¿ÉÒÔ“Ó¦ÓÃÓÚ” “¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. ¸ÃÏî·Ç³£ÖØÒªÄãÒ»¶¨ÒªºË²é.
9. µã»÷“È·¶¨” °´Å¥
10. Windows.ÖØÆô¶¯, ÒÔʹµÃËùÓеÄÐÞ¸ÄÉúЧ.
Ïà¹ØÎĵµ£º
1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/ ......
½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾÀ¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......
Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾÆô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME/install/pro ......
1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......