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

Çë½ÌÒ»¸öoracle±¸·ÝµÄÎÊÌâ - Oracle / ¿ª·¢

ÏëÔÚunix»·¾³ÏÂд¸öshell£¬
¶¨ÆÚ±¸·ÝÒ»¸ö±ítest ÖеÄpartition£¬partiton¡¡ÒÔP+ÈÕÆÚÃüÃû£¬ÀýÈçP20100426

ÏÖÔÚÏ뱸·ÝÉϸöÔ±ítestÖеÄpartition¸ÃÈçºÎ×öÄØ£¿
ÓÉÓÚϵͳ²»Ö§³Ö¡¡date -d ·½·¨£¬ËùÒÔÓÃexp¡¡·½·¨Ê±£¬²»ÖªµÀ¸ÃÈçºÎÈ¡ÉϸöÔµÄpartitonÃû×ÖÁË£¿
Çë½Ì¸÷λÊÇ·ñ»¹ÓÐÆäËû·½·¨¿ÉÒÔʵÏÖ£¿
ÄãµÄϵͳ֧³Ö
date +"%Y%m"
Õâ¸ö²»£¿

ÒýÓÃ
ÄãµÄϵͳ֧³Ö
date +"%Y%m"
Õâ¸ö²»£¿

Õâ¸öÖ§³Ö

date '+%y-%m-%d'

ÒýÓÃ
date '+%y-%m-%d'
Õâ¸öÊǵ±ÌìµÄ

ÎÊÌâÊÇ¡¡ÒªÈçºÎÈ¡¡¡ÉϸöÔµÄ


Ïà¹ØÎÊ´ð£º

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔصĽڵ㣺/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracleµÄ°²×°ºÍʹÓúÃÄÑ°¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí

ÅäÖû·¾³±äÁ¿oracleÔÚ XP
 ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.

XPÏ°²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......

oracle adoÁ¬½ÓÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈÇ°ÓõÄ10gÒ²Óöµ½ÀàËƵÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ