oracle 导出type,如何导出wrapped type定义 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软...

最新推荐文章于 2023-11-25 10:48:21 发布

像素鱼

最新推荐文章于 2023-11-25 10:48:21 发布

阅读量121

点赞数

文章标签： oracle 导出type

这篇博客展示了如何在Oracle数据库中创建一个名为`customer_typ_demo`的对象类型，并使用`WRAP`命令将其包裹成`.plb`文件。接着，通过`SQL*Plus`在相同或另一个数据库中创建该类型。内容涉及Oracle数据库的类型定义、对象类型创建、数据迁移等操作。

摘要由CSDN通过智能技术生成

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 ~]$ 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

Processing type.sql to type.plb

[oracle@vrh8 ~]$ cat type.plb

CREATE TYPE customer_typ_demo wrapped

a000000

abcd

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

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> 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/

26 /

Type created.

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

TYPE customer_typ_demo wrapped