Oracle ʱ¼ä±È½Ï
ÔÚWeb¿ª·¢ÖУ¬´ÓÒ³Ãæ×¢ÈëµÄʱ¼äÒ»°ãΪStringÀàÐÍ£¬ÔõôȥºÍOracleÖеÄʱ¼ä½øÐбȽÏ
·½·¨£º
String Time£»
.......// Ò»¶Î´úÂë
¼ÙÉèTimeÎªÒ³Ãæ×¢ÈëStringÀàÐÍÊý¾Ý£¬Îª"2010-10-10 12:02:01"¡£
ÔÚдSQLÓï¾äʱ
String sql="select from mytable where table_time > to_date('"+Time+"','yyyy-mm-dd
hh24:mi:ss')"
;
Èç¹ûÏȰÑTime ת»»³É Date ÀàÐÍ£¬ÔÙÈ¥±È½Ï£¬»á±¨´í¡£
Ïà¹ØÎĵµ£º
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
[A]Èç¹û¿ªÆô¹éµµ£¬Çë±£Ö¤log_archive_start=true¿ªÆô×Ô¶¯¹éµµ£¬·ñÔòÖ»ÄÜÊÖ¹¤¹éµµ£¬Èç¹ûÊǹرÕÁ˹鵵£¬ÔòÉèÖøòÎÊýΪfalse
×¢Ò⣺Èç¹ûÊÇOPS/RAC»·¾³£¬ÐèÒªÏȰÑparallel_server = true×¢Ê͵ô£¬È»ºóÖ´ÐÐÈçϲ½Ö裬×îºóÓÃÕâ¸ö²ÎÊýÖØÐÂÆô¶¯
1¡¢¿ªÆô¹éµµ
a. ¹Ø±ÕÊý¾Ý¿âshutdown im ......
--´´½¨ÐòÁÐ
create sequence innerid
minvalue 1
maxvalue 999999999
start with 1
increment by 1
cache 20
order;
--´´½¨±í
create table users(
userid int primary key,
username varchar2(20),
userpwd varchar2(20)
);
select * from users;
insert into users values( ......
À䱸·ÝÊý¾Ý±ØÐëÊÇÊý¾Ý¿â²»ÔÚopen״̬Ï¡£ ÒÔϲ½Öè»á¸ø³öÏêϸµÄ¹ý³Ì£º
¡¡¡¡(1)£º ¹Ø±ÕDB £º shutdown immediate£»
¡¡¡¡(2)£ºcopy oradataĿ¼ÏµÄËùÓÐÎļþ£¬ °üÀ¨Êý¾ÝÎļþ£¬ ¿ØÖÆÎļþ£¬redo£¬µÈ£¬»¹ÐèÒªcopy ÃÜÂëÎļþ ÔÚĿ¼ora92Ï µÄdatabase ÖеÄpwd Îļþ.È«²¿copyµ½Ò»¸ö°²È«Ä¿Â¼ÖС£ÔÚsql ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
DOSÖп ......
OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(ÕûÀí), 2010-04-13
RBO·½Ê½£º»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)
ÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñѵÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹æÔò¡£±ÈÈçÎÒÃdz£¼ûµÄ£¬µ±Ò»¸öwhere×Ó¾äÖеÄÒ»ÁÐÓÐË÷Òýʱȥ×ßË÷Òý¡£
CBO·½Ê½£º»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO ......