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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÎÒÏàÐÅÎÒÃǸÕѧoracle£¬¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬¶¼ÊÇÔÚ±¾µØ½øÐеģ¬Ö»Òª±£Ö¤¼àÌý·þÎñÆô¶¯£¬ÄÇôÎÒÃǾͿÉÒÔÕý³£Ê¹ÓÃsqlplus¶ÔÊý¾Ý¿â½øÐвéѯ£¬µ«ÊǼÙÈçÎÒÃÇÏ£Íûͨ¹ýÔ¶³Ì¶ÔÊý¾Ý¿âÀ´·ÃÎÊÄØ£¬´ËʱÎÒÃǾÍÒª¶Ôoracle¼àÌý½øÐÐÅäÖá£
oracle¼àÌýÅäÖÃÓÐÈý¸öÎļþ£¬ÎªÁË·½±ãÃèÊö£¬ÎÒÓÃserverºÍclientÀ´Çø·Ö£ ......
²é¿´±»ËøµÄ±í
select p.spid,a.serial#,
c.object_name,b.session_id,b.oracle_username,b.os_user_name from
v$process p,v$session a, v$locked_object b,all_objects c
where p.addr=a.p ......
¹ÊÕϽâ¾ö£ºoracle10g Êý¾Ý¿â¸´ÖÆÍ¬²½
ºÇºÇ¡£oracleÎÒÊǸö²ËÄñ£¬Ã»»¨¹¦·òÑо¿Ëü£¬µ«ÎÒ»¹ÊǼæÈÎdba£¬Ä¿Ç°oracleÈ«²¿ÊÇÓÉÒÔǰµÄdba´´½¨µÄ£¬oracleȷʵºÃ¡£»ù±¾Ã»Óгö¹ýÎÊÌ⣬ÎÒÒ²¾Í»ù±¾²»¹ÜËüÁË£¬¿ÉÊÇÓÉÓÚ×Ô¼º´ÖÐÄ´óÒ⣬ÔÚÒ»´ÎÐ޸ķþÎñÆ÷µØÖ·Ê±ºò£¬Êý¾Ý¿âÀïµÄtns...Õâ¸öÅäÖÃÎļþÍüÁËÐ޸쬽á¹ûµ¼ÖÂͬ²½Ê§°Ü£¬µÈÎÒ·¢ÏÖµÄʱºò£¬ ......
½«±í¿Õ¼äºÍÊý¾ÝÎļþ´ÓÒ»¸öλÖÃÒÆ¶¯µ½ÁíÒ»¸öλÖõIJÙ×÷·½·¨
Ò»£® OFFLINE
OFFLINE ·ÖΪALTER DATABASE Óë ALTER TABLESPACE OFFLINE£¬
ËûÃǵÄÇø±ð²Î¿´blog£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/29/4898800.aspx
°´Êý¾ÝÎļþÀ´£º
1.ÏȽ«ÏàÓ¦µÄÊý¾ÝÎļþ offline
ALTER DATABASE DATAFILE 'D:\OR ......