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

Oracle×Ô¶¯±¸·Ý

1¡¢Ð´BATÎļþ
------------------------------------------------------------------------------------------------------
if "%time:~0,1%"==" " (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-0%time:~1,1%%time:~3,2%%time:~6,2%) else (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-%time:~0,2%%time:~3,2%%time:~6,2%)
exp ORACLEµÄÓû§Ãû/ÃÜÂë@·þÎñÃû owner=(Òªµ¼³öµÄÓû§Ãû)  file=%backup_file%.dmp log=%backup_file%.log
rar a %backup_file%.rar *.dmp *.log
xcopy "aaa_"%backup_file%.rar Z:\
del *.dmp
del *.log
-------------------------------------------------------------------------------------------------------
¸ÃÎļþµ¼³öÖÁ·ÅÖÃBATÎļþµÄÎļþ¼ÐÏ£¬ÎļþÃûΪµ¼³öµÄʱ¼ä
rarÃüÁîÊÇѹËõ±¸·ÝÎļþºÍÈÕÖ¾
xcopyÊǸ´ÖƵ¼³öµÄÎļþµ½ÁíÒ»¸ö´æ·ÅλÖã¬ÈôÊÇÍøÂçÉÏµÄÆäËûÓ²ÅÌ£¬½¨ÒéÏȽ¨ºÃÓ³Éä
2¡¢½«RAR.EXE·ÅÔÚºÍBATÎļþͬһ¸öÎļþ¼ÐÏÂ
3¡¢ÈôÒª×Ô¶¯±¸·Ý£¬Ìí¼ÓÈÎÎñ¼Æ»®¡¾¿ªÊ¼¡¿—¡·¡¾¸½¼þ¡¿—¡·¡¾ÏµÍ³¹¤¾ß¡¿—¡·¡¾ÈÎÎñ¼Æ»®¡¿
×öÏàÓ¦µÄÉèÖü´¿É
ÐèҪעÒâµÄÊÇ£¬batµÄÎļþÃûÇв»¿ÉÈ¡ÃûΪexp.bat£¬·ñÔò»á²»Í£µÄÖ´ÐУ¬Ò»Ö±Ë¢ÆÁ£¬ÒòΪºÍOracleĬÈϵÄͬÃûÁË¡£
ÎÒÒ»¿ªÊ¼ÎÞÒâÈ¡ÁËÕâ¸öÃû×Ö£¬Ò»Ö±Ë¢ÆÁ£¬ÅªµÃÎҺܲ»½â


Ïà¹ØÎĵµ£º

´ó¼ÒÒ»ÆðÀ´ÌÖÂÛOracle±í¿Õ¼äµÄ´´½¨

ÔÚÏîĿʵÏÖʱ£¬´ó¼ÒÒ»°ãÓбíµÄÉè¼Æ¡£ÓëÒ»°ãÊý¾Ý¿â²»Í¬£¬Oracle±í¿Õ¼äµÄ˵·¨¡£±í¿Õ¼äÒâΪ´æ·Å±íµÄ¿Õ¼ä¡£ÔÚ½¨Á¢±íµÄʱºòΪÁËÓëԭʼOracle±í¿Õ¼äÓÐÇø±ð£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ðµıí¿Õ¼ä´æ·Å±í¡£Ò»°ãµÄ½¨ÒéÊǽ¨Á¢Á½¸ö±í¿Õ¼äÒ»¸ö´æ·ÅÊý¾Ý£¬Ò»¸ö´æ·ÅË÷Òý¡£
´´½¨Oracle±í¿Õ¼äµÄ·½·¨ÈçÏ£º
1.¿ÉÒÔͨ¹ýOracle×Ô´øµÄͼÐÎÓû§½çÃæÊµÏÖ¡£¾ßÌå ......

java²Ù×÷oracleÊý¾Ý¿âÖеÄblob×Ö¶Î

oracleÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.R ......

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

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

centos 4.5ϰ²×°oracle 9204

centos 4.5ϰ²×°oracle 9204
Linux localhost.localdomain 2.6.9-55.ELsmp
Ò»£¬½âѹËõOracle9204µÄ°²×°Îļþ
1£® Oracle 9iR2 (9.2.0.4)
(1) ¼ò»¯¹ý³Ì£¨ÒÔoracleµÇ¼£¬ÊͷŰ²×°Îļþ,ʹÓøüÉٵĴÅÅ̿ռ䣬Ëٶȸü¿ì£©  
ÔÚ°²×°LINUXʱ×îºÃ·ÖÒ»¸öÇø/orasetup,ÕâÑùÒ»À´¼´Ê¹ÏµÍ³»µÁË,Ò²Ö»ÊÇÖØ×°ÏµÍ³,¶øÎÞÐëÖØÐ ......

Oracle²é¿´Óû§±í

ÔÚOracleÖв鿴ËùÓеıí: 
select * from tab/dba_tables/dba_objects/cat; 
¿´Óû§½¨Á¢µÄ±í   :  
select table_name from user_tables;  //µ±Ç°Óû§µÄ±í   
    
select table_name from all_tables;  //ËùÓÐÓû§µÄ±í    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ