oracle imp\exp Óï·¨¼ò½é3
1¡¢Êý¾Ý¿âµ¼³öÃüÁî
exp wesoftwcp/wesoft@oradb file=f:\backup\%date:~0,10%.dmp log=f:\backup\%date:~0,10%.log
compress=n buffer=8092 consistent=y direct=n constraints=y feedback=10000 grants=y record=y indexes=y triggers=y rows=y
2¡¢Êý¾Ý¿âµ¼ÈëÃüÁî
set UserName=wesoftwcp
set Passwd=wesoft
set DBName=@oradb
#set LogName=%UserName%gz.log
set fromUser=wesoftwcp
set ToUser=wesoftwcp
set FileName=F:\backup\2009-12-03.dmp
imp %UserName%/%Passwd%%DBName% fromuser=%fromUser% touser=%ToUser% file=%FileName%
pause
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
1.Ê×ÏȽ«Òªµ¼ÈëµÄÊý¾ÝÉú³ÉexcelÎļþ¸ñʽ£¬×îÇ°Ãæ¿ÕÒ»¸ñ¡£
2.ÓÃPL/SQLÁ¬½ÓÒªµ¼ÈëµÄÊý¾Ý¿â£¬ÊäÈëÓï¾ä select * from ±íÃû for update
3.µã»÷Ð¡Ëø£¨±à¼Êý¾Ý£©£¬Ñ¡ÖÐÒ»Ðн«excel¸´ÖÆÊý¾ÝÕ³Ìùµ½±íÖÐ
ÒÔinformixÊý¾Ýµ¼³öΪÀý£¬Ê×ÏÈʹÓÃSecureCRT¹¤¾ß½øÈëÖÕ¶Ë¡£ÊäÈëÃüÁîdbaccessºóÖ´ÐУ¬Ñ¡ÖÐÊý¾Ý¿âNEWÒ»ÏÂSQLÓï¾äÊäÈëÃüÁunl ......
ORACLE EXP/IMP ²ÎÊýÏê½â
2008-01-09 18:16
ORACLE EXP/IMP ²ÎÊýÏê½â
===========================================================
×÷Õß: magic21(http://magic21.itpub.net)
·¢±íÓÚ: 2007.09.27 10:46
·ÖÀà: ÈÕ»ýÔÂÀÛ
³ö´¦: http://magic21.itpub.net/post/5324/400048
-------------------------------------- ......