Oracle×ÔÔöIDµÄ½â¾ö°ì·¨
Ê×ÏÈ´´½¨Ò»¸öË÷Òý£¬È»ºó´´½¨Ò»¸ö´¥·¢Æ÷
Ë÷ÒýµÄÃû×Ö£º SEQ_tproduct
´¥·¢Æ÷µÄÃû×Ö£º addid
±íÃû£ºtproduct
×ÔÔöÁÐÃû£ºpid
create sequence SEQ_tproduct
minvalue 1
start with 1
increment by 1
nocache;
create or replace trigger addid
before insert on tproduct
for each row 51Testing
begin
select SEQ_tproduct.nextval into :new.pid from dual;
end;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚµ¼ÈëÒ»¸ö2GµÄ±¸·ÝÎļþʱ£¬Êý¾Ý¿â±¨ORA-00257¹ÊÕÏ£¬ÕÒµ½ÕâƪÎÄÕ¡£×ª×Ôhttp://dev.yesky.com/438/2525938.shtml
¸ÅÊö£º
¡¡¡¡OracleÊý¾Ý¿âÊÇÄ¿Ç°Òµ½ç×î³£ÓõĴóÐÍÊý¾Ý¿âϵͳ£¬ÎÒÔÚʵ¼ÊÏîÄ¿ÖÐÓöµ½³öÏÖORA-00257´íÎ󣨿ռ䲻×ã´íÎ󣩣¬Í¨¹ý²éÕÒ×ÊÁÏ£¬¾ø´ó²¿·Ö˵ÕâÊÇÓÉÓڹ鵵ÈÕ־̫¶à£¬Õ¼ÓÃÁËÈ«²¿µÄÓ²ÅÌÊ£Óà¿Õ¼äµ¼Öµģ¬Í¨¹ý ......
ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾ ......
ORACLEµÄÒ»¸öÊý¾ÝÎļþµÄ×î´óÖµÊǶàÉÙÄØ£¿
ÎÒÃÇÖªµÀORACLEµÄ×îСµÄÎïÀíµ¥Î»ÊÇBLOCK£¬Êý¾ÝÎļþµÄ×é³ÉµÄ×îÖÕÐÎʽҲÊÇblock£¬ÄÇôÊý¾ÝÎļþµÄ´óСÏÞÖƾÍÓ¦¸ÃÊÇblockÊýÁ¿µÄÏÞÖÆ£¬ÄÇô¾¿¾¹blockµÄÊýÁ¿ÓкÎÏÞÖÆ£¬ÕâÀï¾ÍÒªÌáµ½Ò»¸öORACLEÄÚ²¿ÊõÓïDBA(´Ëdba·ÇÊý¾Ý¿â¹ÜÀíÔ±£¬¶øÊÇdata block address)
Extent 0 &n ......
Ç°ÑÔ£º
sql_trace ÊÇÎÒÔÚ¹¤×÷Öо³£ÒªÓõ½µÄµ÷ÓŹ¤¾ß£¬Ïà±È½Ïstatspack ÎÒ¸üÔ¸ÒâÓÃÕâ¸ö¹¤¾ß¡£
ÒòΪÊý¾Ý¿âÂýÔÒòµÄ85%ÒÔÉÏÊÇÓÉÓÚsqlÎÊÌâÔì³ÉµÄ£¬statspackûÓÐsqlµÄÖ´Ðмƻ®¡£ÏÔʾûÓÐËüÖ±¹Û£¬·½±ã£¬¶ÔÏëÒªÕë¶ÔÐÔ²»Ç¿£¬
1£¬½éÉÜÊý¾Ý¿âµ÷ÓÅÐèÒª¾³£»áÓõ½µÄ¹¤¾ß ......