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

OracleµÄÊý¾Ý·ÖÇø

Êý¾Ý·ÖÇøÊÇÕë¶Ô±íµÄ¡£
ΪʲôҪ½«±í·ÖÇø£¿
·ÖÇø±íͨ³£´æ´¢ÔÚ½ÏСµÄÎļþ£¨<2GB£©ÖУ¬Ò×ÓÚ±¸·Ý¡£
Ó²¼þ¹ÊÕÏʱ£¬Ö»ÓÐÊý¾Ý¿âµÄһС²¿·Ö»áÊܵ½Ó°Ïì¡£
Ò×ÓÚÊý¾Ý·ÖÎö¡£
¿ÉÒÔÔÚÆäËû·ÖÇø¼ÌÐøÌṩ·þÎñµÄͬʱά»¤ÐèÒª½øÐÐά»¤µÄ±íµÄ·ÖÇø¡£alter table sale drop partition q1_1999;
»ùÓÚÁ¿³ÌµÄ·ÖÇø
¹Ø¼üÊÇÑ¡Ôñ·ÖÇø¼ü£¬ËüÓ¦¸Ã¿¼Âǵ½3¸öÒòËØ¡£
µ±Êý¾Ý´Ó·ÖÇø±íÖзµ»ØÊ±£¬¸ÃÁбØÐëÊÇSQLÓï¾äν´ÊµÄÒ»²¿·Ö¡£
ÁÐÖбØÐëÓÐ×ã¹»µÄ²»Í¬Öµ£¬¿ÉÒÔÓÃÀ´ÔÚ·ÖÇøÖ®¼ä²ð·ÖÐС£
Èç¹ûÈ·¶¨ÒѾ­ÓÐ×ã¹»µÄÖµ£¬ÄÇôÕâЩֵÖеÄÐзֲ¼±ØÐëÓÐÖúÓÚÆ½¾ùÐзֲ¼¡££¨Ê¹·ÖÇøµÄÊý¾ÝÁ¿ÒªÇ÷ͬ£©
create table miling (
    originator    varchar2(40),
    recipient      varchar2(40),
    message     varchar2(4000),
    created       date,
    delivered     varchar2(1),
    read            varchar2(1))
storage (initial 120m next 120m pctincrease 0)
partition by range(created)
(partition mailing_p01 values less than
                (to_date('01-JAN-2001', 'DD-MON-YYYY'))
                tablespace mailing_ts1,
  partition mailing_p02 values less than
                (to_date('01-JUL-2001', 'DD-MON-YYYY'))
                tablespace mailing_ts2,
  partition mailing_p03 values less than
                (to_date('01-JAN-2002', 'DD-MON-YYYY'))
                tablespace mailing_ts3,
  partition mailin


Ïà¹ØÎĵµ£º

oracleÖÐsqlÓï¾äÖеÄinµÄÌõ¼þÊýÁ¿´óÓÚ1000ÓÐÎÊÌâ

oracleÖÐsqlÓï¾äÖÐselect * from t_Test t where  t.Id in(1,2,3......)/*ÊýÁ¿²»ÄÜ´óÓÚ1000¸ö*/
½â¾ö·½·¨ ·Ö¸î³É¶à´Îin È»ºóÔÙ»òÉÏ  Èç select * from t_Test t where  t.Id in(1,2,3......800) or  t.Id in(801,802,803......1300)
ÔÚʹÓÃÖÐ×îºÃÄܲ»Ê¹ÓÃÆäËûÌõ¼þÀ´´úÌæin
......

°²×°Oracle 10g inistant clientºóÊÇPL/SQL³öÏÖÂÒÂë

ÏëʹÓÃPL/SQL¿ª·¢¹¤¾ß£¬µ«²»Ïë°²×°ÄǸö¼¸°ÙÕ×µÄoracle¿Í»§¶Ë£¬ÓÚÊǰ²×°ÁËoracle 10g inistant client£¬40¶àM°É¡£
°²×°ºóPL/SQL¿ÉÒÔÓÃÁË£¬µ«ÊDzéѯ³ö¼Ç¼ÀïÃæµÄÖÐÎÄÈ´ÊÇÂÒÂë¡£ÕÛÌÚÁ˺þòÅÕÒ³ö½â¾ö·½·¨£º
ÉèÖû·¾³±äÁ¿£ºNLS_LANG£¬ÖµÎªOracleÊý¾Ý¿âÉèÖõÄ×Ö·û¼¯£¬ÔÚÎÒµÄϵͳÀïÃæÉèÖÃÊÇ£ºSIMPLIFIED CHINESE_CHINA.ZHS16GBK ......

Oracle¹«²¼Java·¢Õ¹²ßÂÔ


¼×¹ÇÎÄÒѾ­Íê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔÏÂ¾ÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£
 
Java SE:
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£
2£©SunµÄ ......

oracleµÇ¼ÈÏ֤֪ʶ

ÀûÓÃosÉóºË
µÇ¼oracleʱÔÚWinÖÐʵÏÖ¶ÔosµÄÉóºËÓÐÈçϼ¸²½£º
1¡¢  create  os user id
2¡¢  create  os group   ora_dba(Õâ¸ö×éÖÐÓû§¾ßÓйÜÀíËùÓÐoracle database µÄȨÏÞ),
             ora_sid_dba£¨Ö»ÄܶÔÓ¦µ½ÏàÓ¦sidµ ......

OracleÊý¾Ý¿âµÇ¼µÄÉíÖ¤ÑéÖ¤

[oracle@liwei admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 15:55:18 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> quit
Disconnected
[oracle@liwei admin]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ