Çë½ÌÒ»¸öoracle±¸·ÝµÄÎÊÌâ - Oracle / ¿ª·¢
ÏëÔÚunix»·¾³ÏÂд¸öshell£¬
¶¨ÆÚ±¸·ÝÒ»¸ö±ítest ÖеÄpartition£¬partiton¡¡ÒÔP+ÈÕÆÚÃüÃû£¬ÀýÈçP20100426
ÏÖÔÚÏ뱸·ÝÉϸöÔ±ítestÖеÄpartition¸ÃÈçºÎ×öÄØ£¿
ÓÉÓÚϵͳ²»Ö§³Ö¡¡date -d ·½·¨£¬ËùÒÔÓÃexp¡¡·½·¨Ê±£¬²»ÖªµÀ¸ÃÈçºÎÈ¡ÉϸöÔµÄpartitonÃû×ÖÁË£¿
Çë½Ì¸÷λÊÇ·ñ»¹ÓÐÆäËû·½·¨¿ÉÒÔʵÏÖ£¿
ÄãµÄϵͳ֧³Ö
date +"%Y%m"
Õâ¸ö²»£¿
Õâ¸öÖ§³Ö
date '+%y-%m-%d'
Õâ¸öÊǵ±ÌìµÄ
ÎÊÌâÊÇ¡¡ÒªÈçºÎÈ¡¡¡ÉϸöÔµÄ
Ïà¹ØÎÊ´ð£º
ÅäÖû·¾³±äÁ¿oracleÔÚ XP
ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.
XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
¿´µ½ÓÐÒ»¸ö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 ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......