oracle11g 隐藏参数_oracle11g 设置什么参数，使得空表也占用一定的存储空间？

谢谢以上各位，

我发现deferred_segment_creation这个参数对11.2.0.1是个陷阱，或者是bug

即：

11.2.0.1的时候，一张空表不占用存储空间的话，exp是导不出来的，

以下是测试：

07:13:44 SQL> show parameter deferred_segment_creation

NAME                                     TYPE         VALUE

------------------------------------ ----------- ------------------------------

deferred_segment_creation             boolean         TRUE

07:14:31 SQL> create user test1 identified by test1 default tablespace users temporary tablespace temp;

User created.

Elapsed: 00:00:00.23

07:14:49 SQL> grant dba to test1;

Grant succeeded.

Elapsed: 00:00:00.03

07:15:30 SQL> conn test1/test1

Connected.

07:15:35 SQL> create table t1 (id number,name varchar(10));

Table created.

Elapsed: 00:00:00.16

07:15:36 SQL> alter table t1 add constraint pk_t1 primary key (id);

Table altered.

Elapsed: 00:00:00.05

07:15:48 SQL> create table t2 (id number,name varchar(10));

Table created.

Elapsed: 00:00:00.03

07:15:56 SQL> alter table t2 add constraint pk_t2 primary key (id);

Table altered.

Elapsed: 00:00:00.04

07:16:04 SQL> insert into t2 values(1000,'Tom');

1 row created.

Elapsed: 00:00:00.06

07:16:18 SQL> commit;

Commit complete.

Elapsed: 00:00:00.01

07:16:20 SQL> select segment_name from dba_segments where owner='TEST1';

SEGMENT_NAME

---------------------------------------------------------------------------------

T2

PK_T2

2 rows selected.

Elapsed: 00:00:00.20

07:16:30 SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracle script]$ exp system/oracle file=test1.dmp statistics=none owner='TEST1'

Export: Release 11.2.0.1.0 - Production on 星期一 5月 25 07:16:49 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.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 TEST1

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user TEST1

About to export TEST1's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export TEST1's tables via Conventional Path ...

. . exporting table                             T2          1 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.

T1表并没有导出，仅在11.2.0.1发现此现象