Oracle¼òµ¥Êý¾ÝÒƶ¯
µ¼³ö. ÏëÒªµ¼³öÆäËûÓû§µÄ¶ÔÏóÐèÒªÓÐEXP_FULL_DATABASE½ÇÉ«
exp Óû§Ãû/ÃÜÂë file=·¾¶ tables=(±íÃû1,±íÃû2,...) µ¼Èë. ÏëÒªµ¼ÈëÆäËûÓû§µÄ¶ÔÏóÐèÒªÓÐIMP_FULL_DATABASE½ÇÉ«
imp Óû§Ãû/ÃÜÂë file=·¾¶ Êý¾Ý±Ãµ¼³ö
a.) Ö»Äܵ¼³öµ½Oracle¹Ü¿ØĿ¼. ¿ÉÒÔʹÓÃĬÈϵÄDATA_PUMP_DIR
b.) ²éѯDATA_PUMP_DIRÐÅÏ¢. ¿ÉÒÔ¿´µ½¶ÔÓ¦¾ßÌåµÄÎïÀí·¾¶.
SELECT * from dba_directories WHERE directory_name = 'DATA_PUMP_DIR';
c,.) ÊÚȨ½«Òªµ¼³öµÄÓû§,ÏàӦĿ¼µÄȨÏÞ
GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO scott;
d.) ½«²ÎÊýдÈëÒ»¸öÎļþºÃ·½±ãʹÓÃ.ÈçдÈëµ½c:\para.txt
DIRECTORY=DATA_PUMP_DIR
tables=tables=(±íÃû1,±íÃû2,...)
DUMPFILE=scott.dmp
QUERY=scott.±íÃû1:"WHERE Ìõ¼þ"
e.) ÔËÐÐ
expdp Óû§Ãû/ÃÜÂë parfile=c:\para.txt Êý¾Ý±Ãµ¼Èë.¸Õ¸ÕµÄÊý¾Ý
impdp Óû§Ãû/ÃÜÂë parfile=c:\para.txt Êý¾Ý±Ãµ¼Èëʱ,¸Ä±äËùÊôÓû§ºÍ±í¿Õ¼ä.
ÔÚ²ÎÊýÎļþÖмÓÈëÀàËƲÎÊý,È»ºóÖ´ÐÐÒÔÉϵĵ¼ÈëÃüÁî.
REMAP_SCHEMA=SCOTT:XXX
REMAP_TABLESPACE=USERS:YYY
Ïà¹ØÎĵµ£º
QQ:1156316388 Tel:010-51527259
Ò»¡¢Æô¶¯
Èý¸öÃüÁ
1¡¢sqlplux /nolog
2¡¢connect /as sysdba
3¡¢startup
¶þ¡¢¹Ø±Õ
1¡¢shutdown immediate;
[oracle@zhao ......
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, file_name,
round(by ......
³£ÒªoracleÊý¾Ý¿â¶¨Ê±µÄ×Ô¶¯Ö´ÐÐһЩ½Å±¾£¬»ò×öÊý¾Ý¿â±¸·Ý£¬»ò×öÊý¾ÝµÄÌáÁ¶£¬»ò×öÊý¾Ý¿âµÄÐÔÄÜÓÅ»¯£¬°üÀ¨Öؽ¨Ë÷ÒýµÈµÈµÄ¹¤×÷,ÕâʱÐèÒªÓõ½Ò»¸öº¯Êýdbms_job.submit£¬À´Íê³ÉOracle¶¨Ê±Æ÷Jobʱ¼äµÄ´¦ÀíÉÏ¡£Ê¹ÓÃdbms_job.submitÕâ¸öº¯Êý£¬ÎÒÃÇÖ»ÐèÒª¿¼ÂÇÁ½¸öÊÂÇ飺°²ÅÅijһÈÎÎñ£¬ºÍ¶¨ÖÆÒ»¸öÖ´ÐÐÈÎÎñµÄʱ¼äµã¡£µ«×îÖØÒªÒ²ÊÇ× ......
OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ
============================================================
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡Èç¹ûÓÐÒ»×éÈË£¬ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»á²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾ÍÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ ......