Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

hibernate3 µ÷ÓÃoracle´æ´¢¹ý³ÌµÄ·½·¨

ÅäÖÃÎļþ£º
<hibernate-mapping>
    <class name="vo.SshPost" table="ssh_post" >
     <!-- <cache usage="read-write"/>-->
        <id name="postId" type="java.lang.String">
     ......

Oracle INTERVAL DAY TO SECONDÊý¾ÝÀàÐÍ

INTERVAL DAY TO SECONDÊý¾ÝÀàÐÍ
OracleÓï·¨:
INTERVAL '{ integer | integer time_expr | time_expr }'
{ { DAY | HOUR | MINUTE } [ ( leading_precision ) ]
| SECOND [ ( leading_precision [, fractional_seconds_precision ] ) ] }
[ TO { DAY | HOUR | MINUTE | SECOND [ (fractional_seconds_precision) ] } ......

Oracle£ºÒ»¸öIT¡°Èںϡ±¾ÞÍ·µÄµ®Éú

 10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......

oracle²åÈëʱÈçºÎ²åÈëuuId

 ÊÇÏëÉú³ÉGUIDÂð£¿
SQL> select   sys_guid() from dual ;
SYS_GUID()
--------------------------------
F18031C69D8345DEB305D4B2E796A282
Äã¿ÉÒ԰ѱíµÄÖ÷¼ü×ֶεÄȱʡֵÉèΪsys_guid()
insert into luxian_info (id) values(sys_guid()); ......

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ºÅ