¾Æµê¹ÜÀíϵͳ——Oracleµ¼ÈëdmpÎļþ
ÏÂÃæÊÇCMDÃüÁî´°¿ÚϵIJÙ×÷£¬¿´¿´ÊÇÔõôµ¼ÈëµÄ¡£
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\oeg2006>imp
Import: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 11ÔÂ 25 19:24:12 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Óû§Ãû: oeg2006
¿ÚÁî: (ÊäÈë ²»»ØÏÔ)
Á¬½Óµ½: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
µ¼ÈëÎļþ: EXPDAT.DMP> D:\Documents and Settings\Administrator\workspace\hotelman
age\hotelmanage\SEVEN_TABLES.dmp
ÊäÈë²åÈ뻺³åÇø´óС£¨×îСΪ 8192 ) 30720>16384(Ëæ±ãÊäµÄ)
¾Óɳ£¹æÂ·¾¶µ¼³öÓÉEXPORT:V09.02.00´´½¨µÄÎļþ
¾¯¸æ: ´Ë¶ÔÏóÓÉ SYSTEM µ¼³ö, ¶ø²»Êǵ±Ç°Óû§
ÒѾÍê³ÉZHS16GBK×Ö·û¼¯ºÍAL16UTF16 NCHAR ×Ö·û¼¯Öеĵ¼Èë
Ö»Áгöµ¼ÈëÎļþµÄÄÚÈÝ (yes/no): no > (°´»Ø³µ¼ü)
ÓÉÓÚ¶ÔÏóÒÑ´æÔÚ, ºöÂÔ´´½¨´íÎó (yes/no): no > yes
µ¼ÈëȨÏÞ (yes/no): yes > (°´»Ø³µ¼ü)
µ¼Èë±íÊý¾Ý (yes/no): yes >
µ¼ÈëÕû¸öµ¼³öÎļþ (yes/no): no > yes
. ÕýÔÚ½«SYSTEMµÄ¶ÔÏóµ¼Èëµ½ OEG2006
. . ÕýÔÚµ¼Èë±í "BOOK_INFORMATION" 4Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "GUEST_REGIST" 8Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "GUEST_REGIST_MIDDLE" 13Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "PAY_TAB" 0Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "ROOM_INFORMATION" &nb
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Oracle ×°Åä¹£¸Å
Òª²é¿´¿ÉÓà RAM ºÍ»¥»»¿Õ¼ä´óС£¬ÔË×÷ÒÔ´ÎÏÂÁ
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
±ÈÈ磺
# grep MemTotal /proc/meminfo
MemTotal:512236 kB
# grep SwapTotal /proc/meminfo
SwapTotal:1574360 kB
½ÓÏÂÀ´£¬´´ÔìÓÃÀ´×°ÅäºÍά»¤ Oracle Ê®g Èí¼þµÄ Linux ×éºÍÓû ......
ÔÚORACLEÖо³£»áÅöµ½×èÈûµÄÇé¿ö·¢Éú£¬Õâ¸öʱºòÎÒÃǾÍÐèÒª¿ìËÙµÄÕÒ³öµ¼ÖÂ×èÈûµÄÔÒò£¬²¢¾¡¿ìÅųýËü£¬ºÃÈÃÏµÍ³ÖØÐÂÕý³£ÔËÐС£
ÏÂÃæÒÔËÀËøÎªÀý£¬À´¿´¿´ÈçºÎÕÒ³öµ¼ÖÂ×èÈûµÄ»á»°²¢½â¾öÎÊÌâ¡£
//SCOTT´°¿Ú1
SQL> select * from t2;
ID
----------
3
1
2
SQL> update t2 set i ......
ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
/// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......