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
Ïà¹ØÎĵµ£º
2008 ÖйúÊ×½ìOracleÊý¾Ý¿â¾«Ó¢¹¤³ÌʦÆÀÑ¡µç×ÓÊÔÌ⠺ʹð°¸(2008Äê9ÔÂ3ÈÕ)
===========================================================
2008 ÖйúÊ×½ìOracleÊý¾Ý¿â¾«Ó¢¹¤³ÌʦÆÀÑ¡µç×ÓÊÔÌ⠺ʹð°¸(2008Äê9ÔÂ3ÈÕ)
×÷Õß: zhulch(http://zhulch.itpub.net)
·¢±íÓÚ: 2008.09.02 16:12
·ÖÀà: ERP(Oracle/SAP)
³ö´¦: ht ......
OracleÖеÄSQLÔÚÖ´ÐÐ֮ǰ½øÐнâÎö£¬Ò»¸öÓ²½âÎö°üÀ¨ÏÂÃæµÄ²½Ö裺
¼ÓÔØµ½¹²Ïí³ØÖÐ - SQLÔ´´úÂë±»¼ÓÔØµ½ÄÚ´æÖС£
Óï·¨½âÎö - Oracle¼ì²éÓ﷨ƴд´íÎó¡£
ÓïÒå½âÎö - OracleÑéÖ¤À´×ÔÊý¾Ý×ÖµäµÄËùÓбíÃûºÍÁÐÃû²¢ÇÒÑéÖ¤ÄãÊÇ·ñÓÐȨ·ÃÎÊÕâЩÊý¾Ý¡£
²éѯת»» - Èç¹ûÔÊÐí(query_rewrite=true)£¬oracle½«°Ñ¸´ÔÓµÄSQLת»»ÎªµÈ¼ÛµÄ¼òµ ......
oracle9iºÍ10gµÄÏÂÔØµØÖ·
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92 ......
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
-------------------------------------- ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......