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.
Á¬½Óµ½
Ïà¹ØÎĵµ£º
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 ......
ÉùÃ÷£º
ÒÔϵÄÀý×Ó²»Ò»¶¨ÕýÈ·£¬Ö»ÊÇΪÁËÑÝʾ´ó¸ÅµÄÁ÷³Ì¡£
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
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 ´ó¶ÔÏó´æÈ¡:
¡¡¡¡ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
¡¡¡¡blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
¡¡¡¡mediumblodÊÇ24´Î·½,
¡¡¡¡Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
¡¡¡¡MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
¡¡¡¡ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL va ......
ÓÉÓÚÒÔǰ¶¼ÊÇÔÚsqlserver 2005´¦Àí£¬ÏÖÔÚ¿Í»§ÒªÇóoracleÊý¾Ý¿â·þÎñÆ÷£¬
×î³õµÄ´úÂëΪ£º
allRecordSize = (Integer) rs1.getObject(1); //Integer allRecordSize=0;
µ±Ö´ÐеÄʱºò±¨£ºBigDecimalÎÞ·¨×ª»¯ÎªIntegerÀàÐÍ
ΪÁ˼æÈÝÁ½ÕßÐ޸ĺóµÄ´úÂëΪ£º
Object o = rs1.getObject(1);
&nbs ......
Ö»ÊÇsqlserver ÌṩµÄÔ¶³ÌÊý¾Ý·ÃÎʺ¯Êý; ÔÚ±¾µØsqlserver ÖÐÈ¡ÍⲿÊý¾ÝÔ´Êý¾Ýʱºò¿ÉÓÃ;
¶ÔÁ¬½Ó±¾µØ oracle ²Ù×÷Ô¶³Ì oracle ²»ÄÜʹÓÃ; ²âÊÔ: pl/sql ÖÐʹÓÃ:
select * from openrowset(................); ÎÞЧ!!!!!!!!!!!!!!
ÔÚoracle ÖÐÐèÒª·ÃÎÊÔ¶³ÌÊý¾Ý,ÐèÒª½¨Á¢Ò»Á¬½ÓÔ¶³Ìoracle µÄ dblink ;
ÔÙÓÃÈçÏ·½ ......