如何导出wrapped type定义

myownstars

DB: 10.2.0.5
OS: HP-UX B.11.23
症状：
前几天用expdp/impdp做生产库和测试库同步，今天开发人员说有几个type object对象在测试库上找不到，查看dba_object果然没有，生产库上则存在；
而这些object在生产库上又是经过加密的，查看dba_source出现的是乱码，使用
expdp \"/ as sysdba\" directory=CORE_OPS_EXP schemas=JUSTIN include=type:"in ('JUSTIN_COLUMN','JUSTIN_SYSTEM_COLUMN','JUSTIN_TABLE')" dumpfile=JUSTIN_type.dmp
无一例外的出现如下错误
Export: Release 10.2.0.5.0 - 64bit Production on Sunday, 01 July, 2012 23:58:02
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_03":  "/******** AS SYSDBA" directory=CORE_OPS_EXP schemas=JUSTIN include type:in ('JUSTIN_COLUMN','JUSTIN_SYSTEM_COLUMN','JUSTIN_TABLE') dumpfile=JUSTIN_type.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1726. GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [17277], [4294896144], [1], [0xC000000477600CB0], [], [], [], []
Job "SYS"."SYS_EXPORT_SCHEMA_03" stopped due to fatal error at 00:09:40
上述两种方法都不可行，该数据库比较大，不可能再重新同步一次；
请问Maclean有没有其他思路，麻烦分析一下，谢谢！

Maclean Liu(刘相兵

ODM TEST:

[oracle@vrh8 ~]$
[oracle@vrh8 ~]$ cat type.sql
CREATE TYPE customer_typ_demo AS OBJECT
    ( customer_id        NUMBER(6)
    , cust_first_name    VARCHAR2(20)
    , cust_last_name     VARCHAR2(20)
    , nls_language       VARCHAR2(3)
    , nls_territory      VARCHAR2(30)
    , credit_limit       NUMBER(9,2)
    , cust_email         VARCHAR2(30)
    )
/
[oracle@vrh8 ~]$
[oracle@vrh8 ~]$
[oracle@vrh8 ~]$ wrap iname=type.sql oname=type.plb

PL/SQL Wrapper: Release 10.2.0.5.0- 64bit Production on Mon Jul 02 08:34:42 2012

Copyright (c) 1993, 2004, Oracle.  All rights reserved.

Processing type.sql to type.plb




[oracle@vrh8 ~]$ cat type.plb
CREATE TYPE customer_typ_demo wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
d
12c f7
BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
3JYPgAhdxcNnm4FVu+W4M6YDEuk/

/








[oracle@vrh8 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jul 2 08:35:12 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL> CREATE TYPE customer_typ_demo wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
10  abcd
11  abcd
12  abcd
13  abcd
14  abcd
15  abcd
16  abcd
17  abcd
18  abcd
19  d
20  12c f7
21  BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
22  jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
23  VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
24  3JYPgAhdxcNnm4FVu+W4M6YDEuk/
25  
26  /

Type created.









SQL> select text from dba_source where name='CUSTOMER_TYP_DEMO';

TYPE customer_typ_demo wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
d
12c f7
BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
3JYPgAhdxcNnm4FVu+W4M6YDEuk/





在另一个数据库中

SQL> create TYPE customer_typ_demo wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
10  abcd
11  abcd
12  abcd
13  abcd
14  abcd
15  abcd
16  abcd
17  abcd
18  abcd
19  d
20  12c f7
21  BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
22  jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
23  VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
24  3JYPgAhdxcNnm4FVu+W4M6YDEuk/
25  
26  /

Type created.

myownstars

也就是说可直接把加密后的代码放到别的数据库使用？谢谢回复

Maclean Liu(刘相兵

是的 ， 但是复制的时候请注意不要丢失任何字符。