oracle10G·ÖÇøµÄ´´½¨Óëά»¤Oracle·ÖÇø±íºÍ±¾µØË÷Òý
¡¡¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇOracleÆóÒµ°æÖжÀÁ¢ÊշѵÄÒ»¸ö×é¼þ¡£ÒÔÏÂÊǶÔÓÚ·ÖÇø¼°±¾µØË÷ÒýµÄÒ»¸öʾÀý¡£
¡¡¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇOracleÆóÒµ°æÖжÀÁ¢ÊշѵÄÒ»¸ö×é¼þ¡£ÒÔÏÂÊǶÔÓÚ·ÖÇø¼°±¾µØË÷ÒýµÄÒ»¸öʾÀý¡£
¡¡¡¡Ê×Ïȸù¾Ý×Öµä±í´´½¨Ò»¸ö²âÊÔ·ÖÇø±í£º
SQL> connect eygle/eygle
¡¡¡¡Connected.
¡¡¡¡SQL> CREATE TABLE dbobjs
¡¡¡¡2 (OBJECT_ID NUMBER NOT NULL,
¡¡¡¡3 OBJECT_NAME varchar2(128),
¡¡¡¡4 CREATED DATE NOT NULL
¡¡¡¡5 )
¡¡¡¡6 PARTITION BY RANGE (CREATED)
¡¡¡¡7 (PARTITION dbobjs_06 VALUES LESS THAN (TO_DATE('01/01/2007', 'DD/MM/YYYY')),
¡¡¡¡8 PARTITION dbobjs_07 VALUES LESS THAN (TO_DATE('01/01/2008', 'DD/MM/YYYY')));
¡¡¡¡Table created.
¡¡¡¡SQL> COL segment_name for a20
¡¡¡¡SQL> COL PARTITION_NAME for a20
¡¡¡¡SQL> SELECT segment_name, partition_name, tablespace_name
¡¡¡¡2 from dba_segments
¡¡¡¡3 WHERE segment_name = 'DBOBJS';
¡¡¡¡SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME
¡¡¡¡-------------------- -------------------- ------------------------------
¡¡¡¡DBOBJS DBOBJS_06 EYGLE
¡¡¡¡DBOBJS DBOBJS_07 EYGLE
¡¡¡¡´´½¨Ò»¸öLocalË÷Òý£¬×¢ÒâÕâÀï¿ÉÒÔ½«²»Í¬·ÖÇøµÄË÷ÒýÖ¸¶¨´´½¨µ½²»Í¬µÄ±í¿Õ¼ä£º
SQL> CREATE INDEX dbobjs_idx ON dbobjs (created) LOCAL
¡¡¡¡2 (PARTITION dbobjs_06 TABLESPACE users,
¡¡¡¡3 PARTITION dbobjs_07 TABLESPACE users
¡¡¡¡4 );&nbs
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò»,INSERT
1.ΪÁ˲»´òÂÒÔÀ´µÄ±íµÄÊý¾Ý,ËùÒÔ±¸·ÝÔÀ´µÄÊý¾Ý.
create table emp2 as select * from emp
create table emp3 as select * from emp
create table dept2 as select * from dept
create table salgrade2 as select * from salgrade
2.²é¿´±íµÄÉè¼ÆÇé¿ö:desc dept2;±íʾ²é¿´±ídept2µÄÉè¼ÆÇé¿ö.
3.²åÈëÊý¾Ýµ ......
Ë÷Òý( Index )Êdz£¼ûµÄÊý¾Ý¿â¶ÔÏó£¬ËüµÄÉèÖúûµ¡¢Ê¹ÓÃÊÇ·ñµÃµ±£¬¼«´óµØÓ°ÏìÊý¾Ý¿âÓ¦ÓóÌÐòºÍDatabase µÄÐÔÄÜ¡£ËäÈ»ÓÐÐí¶à×ÊÁϽ²Ë÷ÒýµÄÓ÷¨£¬ DBA ºÍ Developer ÃÇÒ²¾³£ÓëËü´ò½»µÀ£¬µ«±ÊÕß·¢ÏÖ£¬ ......
¹Ø¼ü×Ö: oracle job ¼ä¸ôʱ¼ä trunc
¼ÙÉèÄãµÄ´æ´¢¹ý³ÌÃûΪPROC_RAIN_JM
ÔÙдһ¸ö´æ´¢¹ý³ÌÃûΪPROC_JOB_RAIN_JM
ÄÚÈÝÊÇ£º
Create Or Replace Procedure PROC_JOB_RAIN_JM Is li_jobno Number; &nb ......