cntoen

19 积分	0 好友	1 主题

发消息

[安装部署] impdp后，捕获到impdp执行的sql语句为INSERT /*+ APPEND PARALLEL("ZJH...

1^#

发表于 2013-1-28 20:37:23 | 查看: 5533| 回复: 2

我用impdp zjh/zjh DIRECTORY=HZ2004 dumpfile=b_ryzp.dmp REMAP_TABLE=JWZH_ZFGFH.b_ryzp:zjh.b_ryzp命令执行后，在v$sql语句中捕获到如下语句：

INSERT /*+ APPEND PARALLEL("ZJH.B_RYZP",1)+*/ INTO RELATIONAL("JWZH_ZFGFH"."ZJH.B_RYZP" NOT XMLTYPE) ("SYSTEMID", "PHOTONO", "PHOTONAME", "YWBBH", "PHOTOTYPE", "PHOTOSOURCE", "PHOTOREGTIME", "LRSJ", "LRR", "LRDW", "DEPARTMENTCODE", "CREATOR", "CREATEDTIME", "SECURITYGRADE", "RESERVATION01", "RESERVATION02", "RESERVATION03", "RESERVATION04", "RESERVATION05", "RESERVATION06", "RESERVATION07", "RESERVATION08", "RESERVATION09", "RESERVATION10", "LASTUPDATEDBY", "LASTUPDATEDTIME", "REFRESHTIME", "UPLOADFLAG", "DOWNLOADFLAG", "DELETEFLAG", "PHOTO")
SELECT "SYSTEMID", "PHOTONO", "PHOTONAME", "YWBBH", "PHOTOTYPE", "PHOTOSOURCE", "PHOTOREGTIME", "LRSJ", "LRR", "LRDW", "DEPARTMENTCODE", "CREATOR", "CREATEDTIME", "SECURITYGRADE", "RESERVATION01", "RESERVATION02", "RESERVATION03", "RESERVATION04", "RESERVATION05", "RESERVATION06", "RESERVATION07", "RESERVATION08", "RESERVATION09", "RESERVATION10", "LASTUPDATEDBY", "LASTUPDATEDTIME", "REFRESHTIME", "UPLOADFLAG", "DOWNLOADFLAG", "DELETEFLAG", "PHOTO"
FROM "ET$0093000D0001" KU$

查询"ET$0093000D0001"表定义语句

CREATE TABLE "ZJH"."ET$0093000D0001"
(  "SYSTEMID" VARCHAR2(114),
  "PHOTONO" VARCHAR2(114),
  "PHOTONAME" VARCHAR2(114),
  "YWBBH" VARCHAR2(114),
  "PHOTOTYPE" VARCHAR2(24),
  "PHOTOSOURCE" VARCHAR2(69),
  "PHOTOREGTIME" DATE,
  "LRSJ" DATE,
  "LRR" VARCHAR2(69),
  "LRDW" VARCHAR2(114),
  "DEPARTMENTCODE" VARCHAR2(114),
"CREATOR" VARCHAR2(576),
"CREATEDTIME" DATE,
"SECURITYGRADE" VARCHAR2(114),
"RESERVATION01" VARCHAR2(576),
"RESERVATION02" VARCHAR2(576),
"RESERVATION03" VARCHAR2(576),
"RESERVATION04" VARCHAR2(576),
"RESERVATION05" VARCHAR2(576),
"RESERVATION06" VARCHAR2(576),
"RESERVATION07" VARCHAR2(576),
"RESERVATION08" VARCHAR2(576),
"RESERVATION09" VARCHAR2(576),
"RESERVATION10" VARCHAR2(576),
"LASTUPDATEDBY" VARCHAR2(114),
"LASTUPDATEDTIME" DATE,
"REFRESHTIME" DATE,
"UPLOADFLAG" VARCHAR2(3),
"DOWNLOADFLAG" VARCHAR2(3),
"DELETEFLAG" VARCHAR2(3),
"PHOTO" BLOB
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP
   DEFAULT DIRECTORY "HZ2004"
   ACCESS PARAMETERS
   ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "JWZH_ZFGFH"."ZJH.B_RYZP"  JOB ( "ZJH","SYS_IMPORT_FULL_01",1) WORKERID 1 PARALLEL 1 VERSION '11.2.0.0.0' ENCRYPTPASSWORDISNULL  COMPRESSION DISABLED  ENCRYPTION DISABLED    )
   LOCATION
   ( 'bogus.dat'
   )
)
REJECT LIMIT UNLIMITED

其中b_ryzp有lob类型，现在疑问有两个:
1.捕获到的sql语句insert into中提示APPEND PARALLEL 是不是直接插入并形？
2.sql语句中的RELATIONAL是函数还是insert into RELATIONAL这样语句？

分享0