Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¾Æµê¹ÜÀíϵͳ——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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

½ÌÄã°²×°oracle£¡

 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²éѯϵͳÖÐ×èÈûÇé¿ö~

ÔÚORACLEÖо­³£»áÅöµ½×èÈûµÄÇé¿ö·¢Éú£¬Õâ¸öʱºòÎÒÃǾÍÐèÒª¿ìËÙµÄÕÒ³öµ¼ÖÂ×èÈûµÄÔ­Òò£¬²¢¾¡¿ìÅųýËü£¬ºÃÈÃÏµÍ³ÖØÐÂÕý³£ÔËÐС£
ÏÂÃæÒÔËÀËøÎªÀý£¬À´¿´¿´ÈçºÎÕÒ³öµ¼ÖÂ×èÈûµÄ»á»°²¢½â¾öÎÊÌâ¡£
//SCOTT´°¿Ú1
SQL> select * from t2;
ID
----------
3
1
2
SQL> update t2 set i ......

C#±¸·ÝOracle´úÂë

ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
 /// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ