Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

µ±oracle³öÏÖ ¸ñʽÓë×Ö·û´®¸ñʽ²»Æ¥Åä½â¾ö°ì·¨

    select v.spid spid,v.appid appid,v.version version,v.newversion newversion,v.status status,v.createtime createtime from adc_spversionchangeapply v inner join adc_application a on a.id=v.appid
    where a.create_by = 'a' and v.appid = '12000000005' and  (v.createtime >= '1987-05-06') and (v.createtime <= '2009-04-29')
¼ÓÈëv.createtimeÔÚÊý¾Ý¿âÖÐÊÔdateÀàÐÍ  ÄÇô»áÅܳöÒì³£
ORA-01861: ÎÄ×ÖÓë¸ñʽ×Ö·û´®²»Æ¥Åä
ʵ¼ÊÉÏÊÇÒòΪ '1987-05-06'ÊÇ×Ö·û´®ÀàÐ͵¼ÖµÄdateÀàÐÍÓë×Ö·û´®ÀàÐÍ ¼þ¿çÀàÐÍ±È½Ï ËùÒÔÊÇÓÐÎÊÌâµÄ
½«'1987-05-06'  д³Éto_date('1987-09-18','yyyy-mm-dd')
¾ÍÐÐÁË
´úÂëÈçÏÂ
    select v.spid spid,v.appid appid,v.version version,v.newversion newversion,v.status status,v.createtime createtime from adc_spversionchangeapply v inner join adc_application a on a.id=v.appid
    where a.create_by = 'a' and v.appid = '12000000005' and  (v.createtime >= to_date('1987-05-12','yyyy-mm-dd')) and (v.createtime <= to_date( '2009-04-29','yyyy-mm-dd')


Ïà¹ØÎĵµ£º

Oracle 10g RAC On Linux Using NFS

http://inthirties.com:90/thread-918-3-1.html
This article describes the installation of
Oracle 10g release 2 (10.2.0.1) RAC on Linux (Oracle Enterprise Linux
4.5) using NFS to provide the shared storage.
Introduction
Download Software
Operating System Installation
Oracle Installation Prereq ......

OracleÊý¾Ýµ¼Èëµ¼³öÏê½â

½«Ò»¸öÊý¾Ý¿âµÄijÓû§µÄËùÓÐ±íµ¼µ½ÁíÍâÊý¾Ý¿âµÄÒ»¸öÓû§ÏÂÃæµÄÀý×Ó¡¡¡¡
exp userid=system/manager owner=username1 file=expfile.dmp
imp userid=system/manager fromuser=username1 touser=username2 ignore=y file=expfile.dmp
ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý ......

´ÓORACLEÖÐÓÃÓï¾äµ¼³öÐòÁÐ

½ñÌì´ÓÊý¾Ý¿âÖе¼³ö¼¸ÕÅ±í£¬µ«·¢ÏÖÐèÒªµÄÐòÁж¼Ã»µ¼³öÀ´£¬ÓÚÊÇÍøÉÏÕÒÕÒ·½·¨£¬·¢ÏÖÁËÈçÏÂÓï¾ä
select
'create sequence USERNAME.'|| t.sequence_name || ' minvalue '||MIN_VALUE||' maxvalue '||MAX_VALUE||' start with '||LAST_NUMBER||' increment by '||INCREMENT_BY||' cache '||CACHE_SIZE||' ;'
from dba_sequen ......

oracleÖеķÖÎöº¯Êý

·ÖÎöº¯Êý£¬×îÔçÊÇ´ÓORACLE8.1.6¿ªÊ¼³öÏֵģ¬ËüµÄÉè¼ÆÄ¿µÄÊÇΪÁ˽â¾öÖîÈç“ÀۼƼÆË㔣¬“ÕÒ³ö·Ö×éÄڰٷֱȔ£¬“ǰ-NÌõ²éѯ”£¬“ÒÆ¶¯Æ½¾ùÊý¼ÆËã”"µÈÎÊÌâ¡£Æäʵ´ó²¿·ÖµÄÎÊÌâ¶¼¿ÉÒÔÓÃPL/SQL½â¾ö£¬µ«ÊÇËüµÄÐÔÄܲ¢²»ÄÜ´ïµ½ÄãËùÆÚÍûµÄЧ¹û¡£·ÖÎöº¯ÊýÊÇSQLÑÔÓïµÄÒ»ÖÖÀ©³ä£¬Ëü²¢²»Êǽö½ ......

Oracle´æ´¢¿Õ¼ä¹ÜÀí

Oracle´æ´¢¿Õ¼ä¹ÜÀí
1.²é¿´Ã¿¸öÊý¾ÝÎļþµÄÊ£Óà±í¿Õ¼ä£¨Ò»¸ö±í¿Õ¼äÖ»¶ÔÓ¦N¸öÊý¾ÝÎļþ,NÒ»°ãµÈÓÚ1£©
Ö÷ÒªÊÇÀûÓñídba_free_space£¨±í¿Õ¼äÊ£Óà¿Õ¼ä×´¿ö£©ºÍdba_data_files£¨Êý¾ÝÎļþ¿Õ¼äÕ¼ÓÃÇé¿ö£©
    select b.file_id¡¡¡¡"ÎļþID",
¡¡¡¡b.tablespace_name¡¡¡¡"±í¿Õ¼äÃû",
¡¡¡¡b.file_name¡¡¡¡¡¡¡¡¡¡" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ