Кажется нашел баг в Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit for Linux.
Таблицы над которыми не производилось операции INSERT, не экспортируются утилитой exp.
c:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Nov 30 21:54:46 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> connect system/manager@suse
Connected.
SQL> create user user_test identified by manager;
User created.
SQL> grant connect, resource to user_test;
Grant succeeded.
SQL> connect user_test/manager@suse
Connected.
SQL> create table test_table (col1 number);
Table created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
c:\>exp system/manager@suse FILE=c:\export.dmp ROWS=Y OWNER=(user_test)
Export: Release 11.1.0.7.0 - Production on Mon Nov 30 22:02:02 2009
Copyright (c) 1982, 2007, Oracle. 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 WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user USER_TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user USER_TEST
About to export USER_TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export USER_TEST's tables via Conventional Path ...
. 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.
c:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Nov 30 22:03:02 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> connect user_test/manager@suse
Connected.
SQL> insert into test_table values(1);
1 row created.
SQL> rollback;
Rollback complete.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
c:\>exp system/manager@suse FILE=c:\export.dmp ROWS=Y OWNER=(user_test)
Export: Release 11.1.0.7.0 - Production on Mon Nov 30 22:05:48 2009
Copyright (c) 1982, 2007, Oracle. 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 WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user USER_TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user USER_TEST
About to export USER_TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export USER_TEST's tables via Conventional Path ...
. . exporting table [color=red][b]TEST_TABLE[/b][/color] 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.
c:\>
Пробовал эту же последовательность операций выполнить на сервере (SUSE Linux Enterprise Server 11 x86_64) - тот же эффект.
Для версий 11.1 и 10.2 таблица нормально экспортируется.