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

OracleµÄFLASHBACK

OracleµÄFLASHBACK²Ù×÷£¬Íì»ØÄãÎóɾ³ýµÄÊý¾Ý
--Ð޸ıíÔÊÐírow movement
ALTER TABLE ds.SMD_FILE ENABLE ROW movement;
--FLASHBACK ±íµ½Ö¸¶¨µÄʱ¼äµã
FLASHBACK TABLE ds.SMD_FILE to TIMESTAMP TO_TIMESTAMP('2010-05-13 11:30:00','yyyy-mm-dd hh24:mi:ss')
--Ð޸ıí½ûÖ¹row mevement
ALTER TABLE ds.SMD_FILE DISABLE ROW movement;
--²é¿´Ö¸¶¨Ê±¼äµÄ±íµÄ¾µÏó,,by hydonlee
SELECT *
from ds.SMD_FILE AS OF TIMESTAMP TO_TIMESTAMP('2010-05-13 11:40:00', 'yyyy-mm-dd hh24:mi:ss');


Ïà¹ØÎĵµ£º

²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer

²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
      Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
      ÏÂÔØµ ......

OracleÍⲿÉí·ÝÈÏÖ¤Ñо¿

OracleÍⲿÉí·ÝÈÏÖ¤Ñо¿
ÃÜÂëÎļþÈÏÖ¤          ²Ù×÷ϵͳÈÏÖ¤                  remote_login_passwordfile   SQLNET.AUTHENTICATION_SERVICES   &nb ......

oracle µ¼Èë/³öÃüÁî

µ¼Èë IMP
Oracle µÄµ¼ÈëʵÓóÌÐò (Import utility) ÔÊÐí´ÓÊý¾Ý¿âÌáÈ¡Êý¾Ý£¬²¢ÇÒ½«Êý¾ÝдÈë²Ù×÷ϵͳÎļþ¡£ imp ʹÓõĻù±¾¸ñʽ£º imp[username[/password[@service]]] £¬ÒÔÏÂÀý¾Ù imp ³£ÓÃÓ÷¨¡£
 
1. »ñÈ¡°ïÖú
  imp help=y
2. µ¼ÈëÒ»¸öÍêÕûÊý¾Ý¿â
  imp system/manager file=bible_db log=dibl ......

oracleÂÒÂë

´óÖ·ÖΪÈý²¿·Ý£¬1.SQL£¬2.ERP±¾Éí£¬3.±¾»ú
1.Èç¹ûÊÇSQLµ¼³öʱ³öÏÖ£¬ÂÒÂë¿ÉÒÔͨ¹ýÐÞ¸ÄNLS_LANG£¬À´±ÜÃâÂÒÂ룬
·±ÌåÐ޸ijɣºTRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
¼òÌåÐ޸ijÉ: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Ó¢ÎľͲ»ÓÃ˵ÁË£¡£¡
2.Èç¹ûÊÇERP export ʱ³öÏÖÂÒÂ룬¿ÉÒÔͨ¹ýÉèÖÃprofileÀ´ÉèÖÃFND: NATIVE CLIENT ENC ......

oracle·þÎñÓ²¼þÉý¼¶ µ÷Õû²ÎÊý

author£ºskate
time£º2010-05-13
1)If memory increases and you're 64-bit,  e.g  8G to 16G,  Oracle SGA and related parameters need adjust; So are some the Unix kernel parameters.
2)As for CPU related configuration,  some  parameters, based on CPU_co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ