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

oracle¼òµ¥stream Ò»¸öÓû§µ¥Ïò¸´ÖÆÅäÖÃ

ÒÔÏÂÎÒ×östreammͬ²½Á½Ì¨»úÆ÷¼äµÄijһ¸öÓû§µÄ²Ù×÷²½Öè¡£ºÜ¼òµ¥,¿´µ½stream
»¹
ÓкܶàÒª¿´µÄ¡£
1.»·¾³½éÉÜ
  Ö÷Êý¾Ý¿âSID : obpm
  ²Ù×÷ϵͳ :    win 2003
  IPµØÖ·   :  192.168.0.1
  Global_name :
  oracle
version: 10.2.0.1
  ´ÓÊý¾Ý¿âSID: orcl
  ²Ù×÷ϵͳ :    win 2003
  IPµØÖ·   :  192.168.0.2
  Global_name :
  oracle
version: 10.2.0.1
2.ÔÚÖ÷/´ÓÊý¾Ý¿âÉèÖóõʼ»¯²ÎÊý(ÔÚÖ÷´ÓÊý¾Ý¿â¶¼Ö´ÐÐÒÔϲÙ×÷)
  1) sqlplus / as sysdba ----ÒÔdbaÉí·ÝµÇ¼
  2)alter system set aq_tm_processes=2 scope=both;   ---ÆôÓöԶÓÁÐÏûÏ¢µÄʱ¼ä¼àÊÓ
¡¡¡¡alter system set global_names=true scope=both;   ---ÉèÖÃÈ«¾ÖÃû³ÆÎªtrue
¡¡¡¡---alter system set job_queue_processes=10 scope=both;
--ÉèÖö¨Ê±×÷Òµ½ø³Ì×î´óΪ10¸ö,ĬÈÏÊÇ10
¡¡¡¡alter system set undo_retention=3600 scope=both;  
--ÉèÖûعö¶Îʱ¼ä,ĬÈÏÊÇ900
    alter system set streams_pool_size=25M scope=spfile;
--sgaÉèÖÃΪ×Ô¶¯µ÷ÕûÇé¿öϲ»ÐèÉèÖøòÎÊý
  3)ÖØÆô¶¯Á½¸öÊý¾Ý¿â
3.ÉèÖÃÖ÷Êý¾Ý¿âΪ¹éµµmode
  1)archive log list; --²éÊÇ·ñ¹éµµ,ÈçÊǹ鵵,ÇëºöÂÔµÚ3µã
  2)shutdown immediate;
    startup mount;
    alter database archivelog;
    alter system set LOG_ARCHIVE_DEST_1='LOCATION=D:\arc\'; 
---ÉèÖù鵵Ŀ¼
    alter system switch logfile; --ÏàӦĿ¼¼ì²éÊÇ·ñÉú³ÉarcÎļþ
    alter database open;
4.Ö÷/´ÓÊý¾Ýн¨stream
¹ÜÀíÓû§(ÔÚÖ÷´ÓÊý¾Ý¿â¶¼Ö´ÐÐÒÔϲÙ×÷)
  1)sqlplus / as sysdba;
  2)create tablespace tbs_stream datafile 'E:\tbs_stream01.dbf' size
100m autoextend on maxsize unlimited segment space management auto;
---´´½¨Ö÷»·¾³µÄStream
רÓñí¿Õ¼ä
  3)execute dbms_logmnr_d.set_tablespace('tbs_stream');
--½«logminerµÄÊý¾Ý×Öµä´Ósystem±í¿Õ¼ä×ªÒÆµ½Ð½¨µÄ±í¿Õ¼ä£¬·ÀÖ¹³ÅÂúsystem±í¿Õ¼ä
  4)create user strmadmin identified by strmadmin default tablespace
tbs


Ïà¹ØÎĵµ£º

OracleϵÄÖÐÎÄÅÅÐò


alter session set nls_sort='schinese_pinyin_m';
select * from dept order by
nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');
Oracle9i֮ǰ£¬ÖÐÎÄÊǰ´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ¡£
ÔÚoracle9iÖÐÐÂÔöÁ˰´ÕÕÆ´Òô¡¢²¿Êס¢±Ê»­
ÅÅÐò¹¦ÄÜ¡£ÉèÖÃNLS_SORTÖµ
SCHINESE_RADICAL_M °´ÕÕ²¿Ê×£¨µÚһ˳Ðò£©¡¢±Ê»®£¨µÚ¶þ˳Ðò£©Å ......

Oracle DB Link´´½¨

ÓÐʱºò£¬ÐèÒªÔÚÁ½¸öOracleÊý¾Ý¿âÖ®¼äÊÖ¹¤Í¬²½Êý¾Ýʱ£¬DBLinkÊÇ×î·½±ã¿ì½ÝµÄÊÖ¶ÎÖ®Ò»£¬´´½¨DBLinkµÄ·½Ê½Ò»°ãÊÇÕâÑù£º
create public database link <DBLinkÃû³Æ> connect to <±»Á¬½Ó¿âµÄÓû§Ãû> identified by <±»Á¬½Ó¿âµÄÃÜÂë> using '< ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁîʹÓÃ

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......

Oracle 10g Æô¶¯Óë¹Ø±Õ

ÔÚÖ´ÐÐÆô¶¯¹Ø±ÕÃüÁî֮ǰÐèÒªÕýÈ·ÉèÖÃÏÂÁл·¾³±äÁ¿£º
    ORACLE_BASE
    ORACLE_HOME °²×°¹ý³ÌÖÐÏÔʾµÄoracle home Ŀ¼
    ORACLE_SID
    PATH=$PAHT£º$ORACLE_HOME/bin
    ÒÔ oracle Õ˺ŵǽ Linux£¬»òÕß´Ó root ÏÂÊäÈë su - or ......

ORACLE 10gÏÂÔØµØÖ·

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ