oracle sequenceÖµÖØÖûØ1
declare
n number(10);
tsql varchar2(100);
begin
select test_seq.nextval into n from dual;
n:=-(n-1);
tsql:='alter sequence test_seq increment by'|| n;
execute immediate tsql;
select test_seq.nextval into n from dual;
tsql:='alter sequence test_seq increment by 1';
execute immediate tsql;
end;
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÎÒÃǼÙÉèÊÇÊý¾Ý¿â¹ÜÀíÔ±£¬ÎªÁËÊý¾Ý¿âµÄ°²È«£¬ÎÒÃÇÐèÒªÖªµÀµ±Ç°ÓжàÉÙÁ¬½ÓÊý£¬×î´óÖ§³Ö¶àÉÙÁ¬½ÓÊý£¬¿ÉÒÔÓÃÒÔÏÂÓï¾ä²éѯ
select username,count(username),machine,status from v$session
&n ......
Òò¿ª·¢ÒªÇó£¬ÐèÒª¶ÔoracleÀïµÄÊý¾ÝÓëÊý¾ÝÎļþ×÷±È½Ï¡£Èç²ÉÓÿͻ§¶ËÁ¬½ÓoracleµÄ·½Ê½ÔòÏÔµÃСÌâ´ó×ö£¬ÇÒ¹¤×÷Á¿´ó£¬²»Ò×ά»¤¡£Ö±½Ó²ÉÓô洢¹ý³Ì£¬µ÷ÓÃUTL_FILE°üµÄ¹«¹²¹ý³Ì£¬ÏԵ÷½±ãµÃ¶à¡£
Ê×ÏÈ£¬ÐèÒª°ÑÊý¾ÝÎļþËùÔÚµÄĿ¼ע²áµ½oracleÖУ¬ÓÃcreate directory¡£¡£¡£Óï¾ä£¬È»ºó°Ñ´ËÄ¿ ......