oracle ·ÖÇø²ð·Ö ²»ÄܲåÈëÊý¾Ý 01502 Ë÷ÒýʧЧ
Êý¾Ý±íday_energyµ±Ç°ÎªÔ·ÖÇø±í£¬·ÖÇøÐÅÏ¢ÈçÏ£ºDE_200912,DE_201001,DE_201002.....,Ô·ÖÇø±í³öÏÖËٶȲéѯÂý£¬Òò´Ëͨ¹ý½¨Á¢ÈÕ·ÖÇø±í½øÐиÄÉÆ¡£
²ð·ÖÔ·ÖÇø±íµÄÓï¾äΪ£º
alter table day_energy split partition de_201001 at('20100102') into (partition de_20100101,partition de_20100102)
·ÖÎö£º
alter table ±íÃû split partition ·ÖÇøÃû at (·Ö¸îÈÕÆÚ) into (зÖÇø1£¬Ð·ÖÇø2)£»
Èç¹û¼òµ¥µÄ·ÖÇø1¸öÔÂµÄ±í£¬±È½Ï¼òµ¥£¬µ«ÊÇÈç¹ûÒª²ð·ÖÒ»ÄêµÄ±í£¬ÄǾÍÌ«¸´ÔÓÁË¡£ÎªÁ˼òµ¥ÊµÏÖËùÒÔ¾Íͨ¹ýÒÔÏÂÕâ¸ö¹ý³Ì½øÐÐÅúÁ¿²ð·Ö£º
-- czc ²ð·Ö·ÖÇø±í
--½«Ô·ÖÇø±í²ð·Ö³ÉÈÕ·ÖÇø±í
declare
v_tbl varchar2(56);
v_partion varchar2(56);
datetime date;
v_sql varchar2(1024);
v_dt0 varchar2(8);
v_dt1 varchar2(8);
begin
datetime:=to_date('2010-11-1','yyyy-MM-dd');
v_tbl:='day_energy';
while to_char(datetime,'yyyyMMdd')!='20110101' loop
if to_char(datetime,'MM')=to_char(datetime+1,'MM') then
v_dt0:=to_char(datetime,'yyyyMMdd');
v_dt1:=to_char(datetime+1,'yyyyMMdd');
if to_number(to_char(datetime,'dd'))=1 then
v_partion:='DE_'||to_char(datetime,'yyyyMM');
else
v_partion:='DE_'||to_char(datetime,'yyyyMMdd');
end if;
v_sql:='alter table '||v_tbl||' split partition '||v_partion||' at ('''||v_dt1||''') into (partition DE_'||v_dt0||', partition DE_'||v_dt1||');';
dbms_output.put_line(v_sql);
--execute immediate v_sql;
end if;
datetime:=datetime+1;
end loop;
end;
µ«ÊdzöÎÊÌâÁË£¬·¢ÏÖda
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Èç¹ûÊý¾ÝÎļþË𻵣¬»áÓöµ½1157 ºÍ 1110µÄ´íÎó¡£ÕâʱºòÐèÒª½éÖʻָ´Êý¾Ý¿â¡£
»Ö¸´Êý¾Ý¿âÐèÒªÓÐÏàÓ¦µÄ±¸·ÝºÍ±¸·ÝÒÔÀ´²úÉúµÄËùÓеĹ鵵ÈÕÖ¾ÎļþºÍÁª»úÈÕÖ¾Îļþ¡£
Èç¹ûÔÚmountµ½openµÄʱºò·¢ÏÖÆÕͨµÄÊý¾ÝÎļþË𻵣¬Êý¾Ý¿â»áÍ£ÁôÔÚmount״̬Ï£¬Õâʱºò¿ÉÒÔÖ´ÐÐalter database datafile x offline drop ºÍalter database open à ......
1¡£select * from a where a.rowid=(select min(b.rowid) from b where a.id=b.id);
create test1(
nflowid number primary key,
ndocid number,
drecvdate date);
insert into test1 values (1, 12301, sysdate) ;
insert into test1 values (2, 12301, sysdate);
select * from test1 order by drecvdate:
......
ÏîÄ¿´ÓmysqlǨÒƵ½ORACLEÖÐÓöµ½ÒÆÖ²ÎÊÌ⣬mysqlÖÐÖ§³Ölimit ¶øORACLE say no .
½â¾ö·½·¨ ÀûÓÃORACLEµÄαÁÐ rownumÀ´¿ØÖÆ¡£¡£
Mysql : select * from table limit 10
equl
ORACLE£º select * from table where rownum <= 10
ORACLE αÁнéÉÜ£º
ËæÊý¾Ý×ÖµäÒ»Æð×Ô¶¯´´½¨µÄÒ»¸ö±í,ÊôÓÚsysģʽ,ÈκÎÓû§¶¼¿ÉÒÔ·ÃÎÊ,&nbs ......
ÔÚInternetÉÏÔË×÷Êý¾Ý¿â¾³£»áÓÐÕâÑùµÄÐèÇ󣺰ѱ鲼ȫ¹ú¸÷³ÇÊÐÏàËƵÄÊý¾Ý¿âÓ¦ÓÃͳһÆðÀ´£¬Ò»¸ö½ÚµãµÄÊý¾Ý¸Ä±ä²»½öÌåÏÖÔÚ±¾µØ£¬»¹·´Ó³µ½Ô¶¶Ë¡£¸´ÖƼ¼Êõ¸øÓû§ÌṩÁËÒ»ÖÖ¿ìËÙ·ÃÎʹ²ÏíÊý¾ÝµÄ°ì·¨¡£
Ò»¡¢ÊµÏÖÊý¾Ý¿â¸´ÖƵÄÇ°ÌáÌõ¼þ
1¡¢Êý¾Ý¿âÖ§³Ö¸ß¼¶¸´Öƹ¦ÄÜ
Äú¿ÉÒÔÓÃsystemÉí·ÝµÇ¼Êý¾Ý¿â£¬²é¿´v$optionÊÓͼ£¬Èç¹ûÆäÖÐAdv ......