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

½ü¶Îʱ¼äºÜ¶àÍøÓÑÌá³ö¼àÌýÅäÖÃÏà¹ØÎÊÌ⣬¿Í»§ÖÕ¶Ë(Client)ÎÞ·¨Á¬½Ó·þÎñÆ÷¶Ë(Server)¡£±¾ÎÄÏÖ¶Ô¼àÌýÅäÖÃ×÷Ò»¼òµ¥½éÉÜ£¬²¢Ìá³öһЩ¿Í»§ÖÕ¶ËÎÞ·¨Á¬½Ó·þÎñÆ÷¶ËµÄ½â¾ö˼·£¬Ô¸¶Ô¹ã´óÍøÓÑÓë¶ÁÕßÓÐһЩ°ïÖú¡£
 
Ò»¡¢¼àÌýÆ÷(LISTENER)
¡¡¡¡¼àÌýÆ÷ÊÇOracle»ùÓÚ·þÎñÆ÷¶ËµÄÒ»ÖÖÍøÂç·þÎñ£¬Ö÷ÒªÓÃÓÚ¼àÌý¿Í»§¶ËÏòÊý¾Ý¿â·þÎñÆ÷¶ËÌá ......

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

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

JAVAʵÏÖOracleÊý¾Ý¿âµÄÊý¾ÝµÄ·ÖÒ³ÏÔʾ

 
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum  rn from (select * from Person) a where  rownum <= MaxN ......

ORACLE ʹÓÃDBMS_METADATA.GET_DDL»ñÈ¡DDLÓï¾ä

Oracle ÔÚ9iÒԺ󣬿ÉÒÔÀûÓÃDBMS_METADATA.GET_DDL°üµÃµ½Êý¾Ý¿âµÄ¶ÔÏóµÄddl½Å±¾¡£ÈçÏ£¨SQLPLUSÖÐÖ´ÐУ©£º
1. »ñÈ¡µ¥¸öµÄ½¨±í¡¢ÊÓͼºÍ½¨Ë÷ÒýµÄÓï·¨
set pagesize 0
set long 90000
set feedback off
set echo off
spool DEPT.sql
select dbms_metadata. ......

OracleÊý¾Ý¿âʹÓü°ÃüÃû¹æÔòµÄÏê½â

¹«Ë¾Òѽ¨Á¢µÄ»ò´ý½¨Á¢µÄÍøÕ¾£¬È磺ÖÐÎÄÕ¾£¨CHINA£©£¬¹ú¼ÊÕ¾£¨ALIBABA£©£¬»ªÉÌÕ¾£¨CHINESE£©µÈ¡£
OLPS
Online process system£¬ÔÚÏß´¦Àíϵͳ£¬¼´ÎÒÃǵĻáÔ±¿ÉÒÔä¯ÀÀµÄÍøÕ¾ËùÁ¬½ÓµÄÊý¾Ý¿â£¬Ò²ÊÇÎÒÃÇËù˵µÄǰ̨¡£
BOPS
Back Office process system£¬ºǫ́´¦Àíϵͳ£¬¼´ÎÒÃǵÄÍøÕ¾µÄ·¢²¼ÏµÍ³¡£
BZO
Business Object(?)£¬¹«Ë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ