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;
Ïà¹ØÎĵµ£º
ÎÒÃǼÙÉèÊÇÊý¾Ý¿â¹ÜÀíÔ±£¬ÎªÁËÊý¾Ý¿âµÄ°²È«£¬ÎÒÃÇÐèÒªÖªµÀµ±Ç°ÓжàÉÙÁ¬½ÓÊý£¬×î´óÖ§³Ö¶àÉÙÁ¬½ÓÊý£¬¿ÉÒÔÓÃÒÔÏÂÓï¾ä²éѯ
select username,count(username),machine,status from v$session
&n ......
ORACLE´¥·¢LGWRÈÕ־д½ø³ÌµÄÌõ¼þ
µ±Ä³¸öÊÂÎñÌύʱ
µ±ÖØ×öÈÕÖ¾»º³åÇøÖб仯µÄ¼Ç¼³¬¹ý1MBʱ
µ±ÖØ×öÈÕÖ¾»º³åÇøÖÐËù´æµÄ¼Ç¼Òѳ¬¹ý»º³åÇøÈÝÁ¿µÄ1/3
ÔÚDBWR½«Êý¾Ý¿â¸ßËÙ»º³åÇøÖÐÐ޸ĹýµÄÊý¾Ý¿éдµ½Êý¾ÝÎļþ֮ǰ
ÿ3ÃëÖÓ
......
µ±ÔËÐÐsqlplus.shµÄʱºò±¨³ö£º
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
ºÜÆæ¹Ö
nls_lang.shµÄ114ÐÐǰºóÊÇÕâÑùµÄ
if [[ -n "$LC_ALL" ]]; then
locale=$LC_ALL
elif [[ -n "$LANG" ]]; then
locale=$LANG
else
locale=
fi
[[ÓдíÎ󣿲»¿ ......
½«±í¿Õ¼äºÍÊý¾ÝÎļþ´ÓÒ»¸öλÖÃÒÆ¶¯µ½ÁíÒ»¸öλÖõ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 ......
OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆÎªsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È»ºóÔÙ´ ......