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
Ïà¹ØÎĵµ£º
¼×¹ÇÎÄÒѾÍê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔÏÂ¾ÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£
Java SE:
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£
2£©SunµÄ ......
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 ......
--È¡µÃµ±Ìì0ʱ0·Ö0Ãë
select TRUNC(SYSDATE) from dual;
--È¡µÃµ±Ìì23ʱ59·Ö59Ãë(ÔÚµ±Ìì0ʱ0·Ö0ÃëµÄ»ù´¡ÉϼÓ1ÌìºóÔÙ¼õ1Ãë)
SELECT TRUNC(SYSDATE)+1-1/86400 from dual;
--È¡µÃµ±Ç°ÈÕÆÚÊÇÒ»¸öÐÇÆÚÖеĵڼ¸Ìì,×¢Ò⣺ÐÇÆÚÈÕÊǵÚÒ»Ìì
select to_char(sysdate,'D'),to_char(sysdate,'DAY') from dual;
--ÔÚoracleÖÐÈçºÎµÃ ......
OracleÓ¦ÓÃϵͳµÄÓÅ»¯Ëĸö·½Ãæ
1.¡¡¡¡¡¡ Ó¦ÓóÌÐòSQLÓï¾äÓÅ»¯;
2.¡¡¡¡¡¡ ORACLEÊý¾Ý¿â²ÎÊýµ÷Õû;
3.¡¡¡¡¡¡ ²Ù×÷ϵͳ²ÎÊýµ÷Õû;
4.¡¡¡¡¡¡ ÍøÂçÐÔÄܵ÷Õû.
oracleÓ¦ÓÃϵͳµÄÐÔÄÜÖ¸±ê
1.¡¡¡¡¡¡ Êý¾Ý¿âÍÌÍÂÁ¿;
2.¡¡¡¡¡¡ Êý¾Ý¿âÓû§ÏìӦʱ¼ä.
ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯µÄ¼¸¸ö²¿·Ö
Êý¾Ý¿âÐÔÄÜÓÅ»¯°üÀ¨Èçϼ¸¸ö²¿·Ö£º
1¡¢1¡¢µ÷Õ ......
ʵ¼ùµÚÒ»½²£º
Ãû´Ê½âÊÍ£º
dataguard£ººÇºÇ ORACLE¸ß¿ÉÓÃÌåϵÖÐÈý¼ÜÂí³µÖ®Ò»£¨RAC¡¢STREAM£©¡£¸ÉÂïÓã¿£¿£¿¾ÍÊÇÒìµØ±¸·Ý¡¢ÈÝÔÖʲôµÄ¡£Ê²Ã´ÔÀí£¿£¿==ÁĹþ¡£
primary:Êý¾ÝĸÌå
standby:Êý¾ÝĸÌåµÄ¿½±´»ò±¸·Ý»ò¿Ë¡£¨Ö»ÄÜ¿Ë9¸ö Ϊʲô ÒªÎÊORACLE Ϊʲô log_archive_dest_n Õâ¸öÄãNµÄÉÏÏÞÊÇ10à¶£©
ʵ¼ùµÚ¶þ¼þ£º
ʵ¼ù¼ì ......