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
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
ÏÂÔØµ ......
OracleÍⲿÉí·ÝÈÏÖ¤Ñо¿
ÃÜÂëÎļþÈÏÖ¤ ²Ù×÷ϵͳÈÏÖ¤ remote_login_passwordfile SQLNET.AUTHENTICATION_SERVICES &nb ......
µ¼Èë IMP
Oracle µÄµ¼ÈëʵÓóÌÐò (Import utility) ÔÊÐí´ÓÊý¾Ý¿âÌáÈ¡Êý¾Ý£¬²¢ÇÒ½«Êý¾ÝдÈë²Ù×÷ϵͳÎļþ¡£ imp ʹÓõĻù±¾¸ñʽ£º imp[username[/password[@service]]] £¬ÒÔÏÂÀý¾Ù imp ³£ÓÃÓ÷¨¡£
1. »ñÈ¡°ïÖú
imp help=y
2. µ¼ÈëÒ»¸öÍêÕûÊý¾Ý¿â
imp system/manager file=bible_db log=dibl ......
´óÖ·ÖΪÈý²¿·Ý£¬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 ......
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 ......