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
Ïà¹ØÎĵµ£º
1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH ......
³õ³õѧϰoracle 10g,×î»ù±¾µÄÎÊÌâ¾ÍÊÇ°²×°Êý¾Ý¿â,³õ³õ°²×°Êý¾Ý¿âʱ,°²×°Óë±ðÈ˵Ķ¼²î²»¶à,¾ÍÊÇÔÚ×îºóʱ,²»ÄÜ×ÔÐÐÅä×°Êý¾Ý¿â,Òª×Ô¼ºÅäÖÃÊý¾Ý¿â,×îºó¾¹ý×Ô¼ºµÄÅŲé:ÔÚ°²×°ÏµÍ³Ê±,ϵͳµÄ¼ÆËã»úÃû³Æ(×¢²á¼ÆËã»úʱÓõÄ)ΪӢÎÄ,Óû§Ãû³ÆΪÖÐÎÄ,Òò´Ë²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿â,
¾¹ý±¾È˵Ķà´ÎʵÑé,ÔÚ¼ÆËã»úÃû³Æ¡¢Óû§ÃûΪӢÎĵÄ×´Ì¬Ï ......
×ÊÁÏ»ñÈ¡×ÔѧϰºÎÃ÷Öø×÷<<Oracle DBA Åàѵ½Ì³Ì>>µÚ¶þ°æ֮ʱ.ÆäÖÐdba_¿ªÍ·µÄ±íÐèÒªÓÐsysdbaȨÏÞ²ÅÄÜ·ÃÎÊ.
1. »ñÈ¡Êý¾Ý¿âÃû×Ö,´´½¨ÈÕÆÚ,µ±Ç°Ä£Ê½,ÈÕ־ģʽµÈµÈ:
SELECT name,created,log_mode,open_mode from v$database;
2. »ñÈ¡ÔËÐÐʵÀýµÄÖ÷»úÃû,ʵÀýÃû,°æ±¾:
SELECT host_name,instance_name,ve ......
Ò»¡¢Ê×ÏÈÏÂÔØ
1¡£µ½OracleµÄOTNÕ¾µãÉÏÏÂÔØOracle10g for Solaris x86µÄ°²×°ÅÌ http://www.oracle.com/technology ... ocs/solx86soft.html 2¡£ÏÂÔØÍê±ÏÒԺ󣬵õ½solarisx86_DB_10_1_0_3_Disk1.cpio.gzÎļþ ½âѹ£¬Éú³ÉDisk1Ŀ¼ $ gunzip -c solarisx86_DB_10_1_0_3_Disk1.cpio.gz | cpio -idmv È»ºó¿´oracle 10g fo ......