Çë½ÌÒ»¸ö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 for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡ ×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½ ´¥·¢Æ÷? Ó¦¸ÃÓÃJOB Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......