[Oracle]oracle exp版本11.2.0.1和11.2.0.4区别


本文总阅读量

1、对于没有分配segment的空表来说,使用不同版本exp导出时,结果存在差异

exp-11.2.0.1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
[oracle@dax-mysql-master bin]$ ./exp te/te12345678@boston177 file=/tmp/daochu.dmp log=/tmp/daochu.log
Export: Release 11.2.0.1.0 - Production on Wed Sep 4 22:46:08 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TE
About to export TE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TE's tables via Conventional Path ...
. . exporting table TEST1
EXP-00003: no storage definition found for segment(0, 0)
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.

11.2.0.1版本的exp导出时,如果表没有被分配segment,导出时会提示错误EXP-00003

exp-11.2.0.3

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
[oracle@node3 bin]$ ./exp te/te12345678@boston177 file=/tmp/daochu.dmp log=/tmp/daochu.log
Export: Release 11.2.0.3.0 - Production on Thu Sep 5 11:02:34 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TE
About to export TE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TE's tables via Conventional Path ...
. . exporting table TEST1 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

使用11.2.0.3以及高版本的11.2.0.4导出数据都可以直接导出未分配segment的空表

目录
  1. 1. 1、对于没有分配segment的空表来说,使用不同版本exp导出时,结果存在差异

Proudly powered by Hexo and Theme by Lap
本站访客数人次
© 2020 zeven0707's blog