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

OracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðò

ÎÒÔÚ¹¤×÷ÖÐÔÚOracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðòʱ£¬ÓÃorder by ±íÃû.datatime desc ×ÜÊÇʵÏÖ²»ÁË¡£
²»¹ý×îºóÎÊÑî¾é×îºóºÍÎÒ˵¿ÉÒÔ°ÑÎÒÃDzéѯµÄ×ܸösqlÓï¾ä×öΪһ¸ö±íÀ´ÅÅÐò£º
select rownum,aa.* from (....  order by ±íÃû.datatime desc ) aa


Ïà¹ØÎĵµ£º

OracleÐÐתÁÐʵÀý

ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD"  (
     ID                   nvarchar2(20)              &n ......

Oracle Listener ¶¯Ì¬×¢²á Óë ¾²Ì¬×¢²á

Ò»£®Ê²Ã´ÊÇ×¢²á
×¢²á¾ÍÊǽ«Êý¾Ý¿â×÷Ϊһ¸ö·þÎñ×¢²áµ½¼àÌý³ÌÐò¡£¿Í»§¶Ë²»ÐèÒªÖªµÀÊý¾Ý¿âÃûºÍʵÀýÃû£¬Ö»ÐèÒªÖªµÀ¸ÃÊý¾Ý¿â¶ÔÍâÌṩµÄ·þÎñÃû¾Í¿ÉÒÔÉêÇëÁ¬½Óµ½Êý¾Ý¿â¡£Õâ¸ö·þÎñÃû¿ÉÄÜÓëʵÀýÃûÒ»Ñù£¬Ò²ÓпÉÄܲ»Ò»Ñù¡£
¡¡¡¡ÔÚÊý¾Ý¿â·þÎñÆ÷Æô¶¯¹ý³ÌÖУ¬Êý¾Ý¿â·þÎñÆ÷»áÏò¼àÌý³ÌÐò×¢²áÏàÓ¦µÄ·þÎñ£¨ÎÞÂÛºÎʱÆô¶¯Ò»¸öÊý¾Ý¿â£¬Ä¬Èϵض¼ ......

³éÏóÊý¾ÝÀàÐÍ£¬ÈÃOracleÊý¾Ý¿âÊý¾Ý¹ÜÀí¸ü¼ÓÈÝÒ×

2¡¢ ³éÏóÊý¾ÝµÄÒýÓá£
¡¡¡¡µ±½¨Á¢ºÃ³éÏóÊý¾ÝÀàÐ͵Äʱºò£¬Êý¾Ý¿â¹ÜÀíÔ±¾Í¿ÉÒÔÏò»ù±¾Êý¾ÝÀàÐÍÄÇÑù£¬ÒýÓóéÏóÊý¾ÝÀàÐÍ£¬°üÀ¨ÔÚ½¨Á¢±í»òÕß¶ÔÏà¹Ø×ֶνøÐи³ÖµµÄʱºò£¬¶¼Õâô·½±ã¡£
¡¡¡¡ÈçÔÚ½¨Á¢±íµÄʱºò£¬¿ÉÒÔ°ÑÕâ¸ö³éÏóÊý¾ÝÀàÐÍÖ±½Ó¸úij¸ö×ֶιØÁªÆðÀ´¡£Èç
¡¡¡¡Create Table USERS
¡¡¡¡(F­­_Adress Adress );
¡¡¡ ......

Oracle¹éµµÈÕÖ¾¹ÜÀí


²é¿´µ±Ç°Êý¾Ý¿â¹éµµÈÕÖ¾²Ù×÷ģʽ:
select name,log_mode from v$database;
²é¿´¹éµµÈÕ־λÖÃ:
show parameter log_archive_dest; µÚÒ»¸ö¹éµµÎ»ÖÃ
show parameter log_archive_duplex_dest; µÚ¶þ¸ö¹éµµÎ»ÖÃ
ÏȹرÕÊý¾Ý¿â,È»ºó×°ÔØÊý¾Ý¿â:
shutdown immediate;
startup mount;
Ð޸Ĺ鵵ÈÕÖ¾²Ù×÷ģʽ,È»ºó´ò¿ªÊý¾Ý¿â ......

Oracle´´½¨±í¿Õ¼ä¡¢´´½¨Óû§ÒÔ¼°ÊÚȨ¡¢²é¿´È¨ÏÞ

´´½¨ÁÙʱ±í¿Õ¼ä
CREATE   TEMPORARY  TABLESPACE test_temp
TEMPFILE  ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf '
SIZE 32M
AUTOEXTEND  ON
NEXT  32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
CREATE  TABLESPACE test_data
LOGGING
DATAFI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ