Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

notes oracle undeploy

crsctl stop crs
killall init.crsd
cd /etc/init.d
rm -rf init.crs init.crsd init.cssd init.evmd
rm -rf /tmp/.oracle/
rm -rf /var/tmp/
rm -rf /var/tmp/.oracle/
cd /etc
rm -rf oraInst.loc oracle/ oratab
rm -rf $ORACLE_BASE
dd if=/dev/zero of=/dev/raw/raw_voting_disks bs=1024k
dd if=/dev/zero ......

DB2ºÍORACLEµÄÓ¡Ïó±È½Ï

Ò»¸öÏîÄ¿ÐèÒªDB2£¬ÒÔǰûÓùý£¬ÓÃÁËWINDOWS 2008ϵÄDB29.7 ºÃ¼¸ÖÜ£¬ËãÈëÃÅÁ˰ɣ¬ÏÂÃæÕâÎÄÕ¾͵±Ò»¸öORACLEʹÓÃÕßÑÛÀïµÄDB2µÄÓ¡Ïó°É£¬Ò²ÐíÓÐЩ¶«Î÷¿ÉÄÜÓÐÆ«²î£¬µ«ÊǾÍÊÇÎÒ×Ô¼ºµÄÓ¡Ïó£º
1¡¢Ìåϵ½á¹¹£¬DB2µÄʵÀýºÍÊý¾Ý¿â·Ö¿ªµÄ×ö·¨£¬ÎÒ¸öÈË»¹ÊDZȽÏϲ»¶µÄ£¬ÒòΪʵÀý¿ÉÒÔ´´½¨¶à¸ö£¬Êý¾Ý¿âµÄ»Ö¸´Ö±½Ó»Ö¸´µ½ÊµÀýϾͿÉÒÔÁË£¬Ïà¶ ......

°²×°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Êý¾Ý¿â×Ô¶¯±¸·ÝÈÎÎñ

For win:
1¡¢Ð½¨Ò»¸öÅú´¦ÀíÎļþb.bat£¬¸ÃÎļþĿ¼ÏÂÒªÓÐexp.exeÎļþ
    Åú´¦ÀíÎļþÄÚÈÝ£º
  exp userid=user/passfile=i:\db%date:~0,10%.dmp log=i:\db%date:~0,10%.log
2¡¢Ð½¨ÈÎÎñ¹ØÁªb.batÎļþ¼´¿É¡£
For linux:
1¡¢Çе½oracleÓû§ÏÂн¨Ò»¸öÎļþ£¬Èçb.sh  £¬²¢¸³ÓÚ¿ÉÖ´ÐÐȨÏÞ c ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ