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

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.ÖØÆô¶¯, ÒÔʹµÃËùÓеÄÐÞ¸ÄÉúЧ.


Ïà¹ØÎĵµ£º

Oracle ±í¿Õ¼ä»ù±¾²Ù×÷

 
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µÄOpenWorld:ÁªÊÖSun¶ÔÕ½IBM

 ½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£­15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾ­À­¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......

oracle 10 em

Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾ­Æô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME/install/pro ......

OracleÍⲿ±íСÀý

1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ