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

OracleÓû§¹ÜÀí³£ÓòÙ×÷

 
ÒÔÏÂÁгöµÄÊÇOracle
Óû§¹ÜÀí¹ý³ÌÖг£ÓõÄһЩָÁÒÔ¹©´ó¼Ò²Î¿¼¡£
Oracle
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£

1.          
SQL>Create
profile
ÎļþÃû limit
2.          
   FAILED_LOGIN_ATTEMPTS
£ºÖ¸¶¨Ëø¶¨Óû§µÄµÇ¼ʧ°Ü´ÎÊý  
3.          
   PASSWORD_LOCK_TIME
£ºÖ¸¶¨Óû§±»Ëø¶¨ÌìÊý  
4.          
   PASSWORD_LIFE_TIME
£ºÖ¸¶¨¿ÚÁî¿ÉÓÃÌìÊý  
5.          
   PASSWORD_REUSE_TIME
£ºÖ¸¶¨Ôڶ೤ʱ¼äÄÚ¿ÚÁî²»ÄÜÖØÓà  
6.          
   PASSWORD_REUSE_MAX
£ºÖ¸¶¨ÔÚÖØÓÿÚÁîǰ¿ÚÁîÐèÒª¸Ä±äµÄ´ÎÊý   
7.          
   SESSIONS_PER_USER
£ºÏÞÖÆÓû§²¢·¢»á»°¸öÊý  
8.          
   CPU_PER_SESSION
£ºÏÞÖÆ»á»°ËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩  
9.          
   CPU_PER_CALL
£ºÏÞÖÆÃ¿´Îµ÷ÓÃËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩  
10.      
   CONNECT_TIME
£ºÏÞÖÆ»á»°µÄ×ܼÆÁ¬½Óʱ¼ä£¨·ÖÖÓ£©  
11.      
   IDLE_TIME
£ºÏÞÖÆ»á»°µÄ¿ÕÏÐʱ¼ä£¨·ÖÖÓ£©);  
Oracle
Óû§¹ÜÀíÖ®¶þ¡¢´´½¨Óû§£¨°üÀ¨´´½¨½ÇÉ«£©:

1.          
SQL>Create
user
  
Óû§Ãû  
2.          
   IDENTIFIED  BY
  
¿ÚÁî  
3.          
   Default
  tablespace &nb


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

perl½«oracleÊý¾Ý¿âµÄÊý¾Ýµ¼³ö³ÉtxtµÄ¼òµ¥·½Ê½

 µ±ÎÒÃÇÃæ¶Ô Êý°ÙÍòÊýǧÍòÐÐÁеÄÊý¾Ý¿â±íµÄʱºò£¬¶øÄãÓÖÏ£ÍûÄܽ«Êý¾Ý¾¡¿ìµÄµ¼³ö³Étxt¸øÄãµÄÀϰ壬ÓÐÈí¼þ»òÕ߯äËû¶«Î÷µ¼³öÀ´¾ÍÏԵñȽÏÓôÃÆÁË£¬ÒòΪÀϰåÒª³ÔÎç·¹ÁË£¬Ëû¿É²»Ï£ÍûÔÚϰàµÄʱºò»¹Ìýµ½ÄãÔÚ˵£¬Êý¾ÝÕýÔÚµ¼³öÖС£
   ÓÚÊÇÎÒÃÇÀûÓÃÁË£¬ËÙ¶ÈתÈëÕýÌâÁ˰¡¡£
ÐèÒªµÄÄ£¿é£º
DBI£»
#!/usr/bin/pe ......

oracle²»Í¬°æ±¾Ö®¼äµÄÇл»

¼òµ¥ÃèÊöÒ»ÏÂÔÚwindowsµÄͬһÓû§Ï£¬°²×°OracleµÄ9i¡¢10gºÍ11gµÄ·½·¨¡£
OracleÔÚwindowsƽ̨ϵݲװÊÇËùÓÐÆ½Ì¨ÖÐ×î¼òµ¥µÄ£¬»ù±¾Éϲ»ÐèÒª½øÐÐÈκζîÍâµÄ´¦Àí¾Í¿ÉÒԳɹ¦µÄ°²×°£¬¿ÉÒÔ˵ûÓÐʲô¼¼Êõº¬Á¿¡£
 
²»¹ýÔÚͬһ̨»úÆ÷µÄͬһ¸öÓû§ÉÏͬʱ°²×°Á½¸ö²»Í¬°æ±¾µÄÊý¾Ý¿â¾ÍÐèÒªÒ»¶¨µÄ¼¼ÇÉÁË¡£ÕâÀï¼òµ¥ÃèÊöÒ»ÏÂÔÚͬʱ ......

oracle ³£ÓñêÁ¿ÀàÐÍ

 £¨1£© varchar2(n):¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®£¬ÆäÖÐ n ÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ 32767 ×Ö½Ú¡£µ±Ê¹ÓøÃÊý¾ÝÀàÐͶ¨Òå±äÁ¿ÊÇ£¬±ØÐë×¢Ò⣬ÔÚPL/SQL¿éÖÐʹÓøÃÊý¾ÝÀàÐͲÙ×Ývarchar2±íÁÐʱ£¬ÆäÊýÖµµÄ³¤¶È²»Ó¦¸Ã³¬¹ý 4000 ×Ö½Ú¡£
......

Oracle ORA_ROWSCN

½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ­°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØÊ½éÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ