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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚFedora 10Éϰ²×°Oracle£¨10.2.0£©
ĬÈϵÄϵͳ²ÎÊýÏ£¬ÔÚFedora 10ÉÏÎÞ·¨°²×°Oracle£¬ÐèÒª½øÐÐÏÂÁÐÈô¸É´¦Àí£º
1. Ñé֤ϵͳҪÇó
ÒªÑé֤ϵͳÊÇ·ñÂú×ã Oracle 10g Êý¾Ý¿âµÄ×îµÍÒªÇó£¬ÒÔ root Óû§Éí·ÝµÇ¼²¢ÔËÐÐÒÔÏÂÃüÁî¡£
Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂà ......
³£ÓÃSQL²éѯ£º
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
select tablespace_name, file_id, ......
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 ......
DECODEº¯ÊýµÄ×÷ÓãºËü¿ÉÒÔ½«ÊäÈëÊýÖµÓ뺯ÊýÖеIJÎÊýÁбíÏà±È½Ï£¬¸ù¾ÝÊäÈëÖµ·µ»ØÒ»¸ö¶ÔÓ¦Öµ¡£º¯ÊýµÄ²ÎÊýÁбíÊÇÓÉÈô¸ÉÊýÖµ¼°Æä¶ÔÓ¦½á¹ûÖµ×é³ÉµÄÈô¸ÉÐòżÐÎʽ¡£µ±È»£¬Èç¹ûδÄÜÓëÈκÎÒ»¸öʵ²ÎÐòżƥÅä³É¹¦£¬Ôòº¯ÊýÒ²ÓÐĬÈϵķµ»ØÖµ¡£
¡¡¡¡Çø±ðÓÚSQLµÄÆäËüº¯Êý£¬DECODEº¯Êý»¹ÄÜʶ±ðºÍ²Ù×÷¿ÕÖµ¡£
¡¡¡¡Óï·¨ÈçÏ£º
¡¡¡¡DECODE ......