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

oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö


oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö
OracleµÄimp/exp×é¼þÊÇÎÒÃdz£ÓõŤ¾ß£¬ËüµÄÒ»¸ö²Ù×÷Ô­Ôò¾ÍÊÇÏòϼæÈÝ¡£ÏÂÃæÊǾݴË×ܽáµÄ¼¸¸öʹÓùæÔòºÍÏà¹Ø²âÊÔ£º
 
¹æÔò1£ºµÍ°æ±¾µÄexp/imp¿ÉÒÔÁ¬½Óµ½¸ß°æ±¾£¨»òͬ°æ±¾£©µÄÊý¾Ý¿â·þÎñÆ÷£¬µ«¸ß°æ±¾µÄexp/imp²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄÊý¾Ý¿â·þÎñÆ÷
 
1.1 ʹÓÃ9i¿Í»§¶Ëͨ¹ýimpÁ¬½Óµ½10gÊý¾Ý¿â
 
C:\Documents and Settings\yuechaotian>exp userid=hdtest/test@s67 tables=(ab01) rows=n file=d:\x.dmp
 
Export: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 2ÔÂ 20 10:09:55 2008
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Á¬½Óµ½: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Òѵ¼³ö ZHS16GBK ×Ö·û¼¯ºÍ AL16UTF16 NCHAR ×Ö·û¼¯
×¢: ½«²»»áµ¼³ö±íÊý¾Ý£¨ÐУ©
 
¼´½«µ¼³öÖ¸¶¨µÄ±íͨ¹ý³£¹æÂ·¾¶ ...
. . ÕýÔÚµ¼³ö±í                            AB01
ÔÚûÓо¯¸æµÄÇé¿öϳɹ¦ÖÕÖ¹µ¼³ö¡£
 
 
1.2 ʹÓÃ10g¿Í»§¶Ëͨ¹ýimpÁ¬½Ó9iÊý¾Ý¿â£ºÁ¬½Óʧ°Ü£¨¶ø²»Êǵ¼³öʧ°Ü£©
 
C:\Documents and Settings\yuechaotian>exp userid=hbjb_kf_hd/test@s46 owner=hdtest file=d:\x.dmp
 
Export: Release 10.2.0.1.0 - Production on ÐÇÆÚÈý 2ÔÂ 20 09:57:22 2008
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
EXP-00056: Óöµ½ ORACLE ´íÎó 6550
ORA-06550: µÚ 1 ÐÐ, µÚ 41 ÁÐ:
PLS-00302: ±ØÐë˵Ã÷ 'SET_NO_OUTLINES' ×é¼þ
ORA-06550: µÚ 1 ÐÐ, µÚ 15 ÁÐ:
PL/SQL: Statement ignored
EXP-00000: µ¼³öÖÕֹʧ°Ü
 
 
 
¹æÔò2£º¸ß°æ±¾exp³öµÄdmpÎļþ£¬µÍ°æ±¾ÎÞ·¨imp£¨ÎÞ·¨Ê¶±ðdmpÎļþ£©
 
2.1 ʹÓÃ10g¿Í»§¶Ëexp³ö10gµÄÊý¾Ý
 
C:\Documents and Settings\yuechaotian>exp userid=test/test@orcl owner=test file=d:\10g.dmp
 
Export: Release 10.2.0.1.0 - Production on ÐÇÆÚÈý 2ÔÂ 20 11:16:39 2008
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
Á¬½Óµ½


Ïà¹ØÎĵµ£º

oracleµ÷ÓÃjava³ÌÐòÁ¬sqlserver2005

1¡¢ÔÚoracleµÄsys-sysdbaϵǽ
дһ¸öjava source³ÌÐòÁ´½Ósqlserver2005£º
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
    public static String entry ......

ÓÃjavaµ÷ÓÃoracle´æ´¢¹ý³Ì×ܽá

ÉùÃ÷£º
ÒÔϵÄÀý×Ó²»Ò»¶¨ÕýÈ·£¬Ö»ÊÇΪÁËÑÝʾ´ó¸ÅµÄÁ÷³Ì¡£
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2)  AS
BEGIN
   INSERT INTO HYQ.B_ID (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´ ......

mysql,sqlserver,oracleÈýÖÖÊý¾Ý¿âµÄ´ó¶ÔÏó´æÈ¡

mysql ´ó¶ÔÏó´æÈ¡:
¡¡¡¡ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
¡¡¡¡blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
¡¡¡¡mediumblodÊÇ24´Î·½,
¡¡¡¡Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
¡¡¡¡MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
¡¡¡¡ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL va ......

oracleÓësqlserverÖ´ÐÐcount(*)·µ»ØµÄ½á¹û¼æÈÝ

ÓÉÓÚÒÔǰ¶¼ÊÇÔÚsqlserver 2005´¦Àí£¬ÏÖÔÚ¿Í»§ÒªÇóoracleÊý¾Ý¿â·þÎñÆ÷£¬
×î³õµÄ´úÂëΪ£º
allRecordSize = (Integer) rs1.getObject(1);    //Integer allRecordSize=0;
µ±Ö´ÐеÄʱºò±¨£ºBigDecimalÎÞ·¨×ª»¯ÎªIntegerÀàÐÍ
ΪÁ˼æÈÝÁ½ÕßÐ޸ĺóµÄ´úÂëΪ£º
  Object o = rs1.getObject(1);
 &nbs ......

sqlserver:openrowset / oracle:table/view@dblinkÃû

Ö»ÊÇsqlserver ÌṩµÄÔ¶³ÌÊý¾Ý·ÃÎʺ¯Êý;  ÔÚ±¾µØsqlserver ÖÐÈ¡ÍⲿÊý¾ÝÔ´Êý¾Ýʱºò¿ÉÓÃ;
¶ÔÁ¬½Ó±¾µØ oracle ²Ù×÷Ô¶³Ì oracle ²»ÄÜʹÓÃ; ²âÊÔ: pl/sql ÖÐʹÓÃ:
select * from openrowset(................); ÎÞЧ!!!!!!!!!!!!!!
ÔÚoracle ÖÐÐèÒª·ÃÎÊÔ¶³ÌÊý¾Ý,ÐèÒª½¨Á¢Ò»Á¬½ÓÔ¶³Ìoracle µÄ dblink ;
ÔÙÓÃÈçÏ·½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ