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 ÀàÐÍ£¬ÔÙÈ¥±È½Ï£¬»á±¨´í¡£
Ïà¹ØÎĵµ£º
±¾ÊµÀýÒÑÍêȫͨ¹ý²âÊÔ,µ¥Ïò,Ë«Ïòͬ²½¶¼¿ÉʹÓÃ.
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
ǰ6²½±ØÐëÖ´ÐÐ,µÚ6ÒÔºóÊÇһЩ¸¨ÖúÐÅÏ¢.
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblink
drop public database link dblink ......
1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M;
3.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING C ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
DOSÖп ......
ÔÚ×öÏîÄ¿¾³£Óöµ½·Ö¿ÆÊÒ¡¢ÈËÔ±½øÐлã×ܵÄÎÊÌ⣬ÔÚORACLEÖжԴËÀàÎÊÌâµÄ´¦ÀíÏ൱·½±ã£¡ÏÂÃæÒÔÏîÄ¿ÖÐÓöµ½µÄʵÀý½øÐÐ˵Ã÷£º
²éѯÓï¾äÈçÏ£º
select f_sys_getsectnamebysectid(a.sectionid) as sectname,
--a.sectionid,
f_sys_employin ......