Missing Tables in Agile e6.1.1 Export Dump File (backup) - Oracle 11gR2 Export (EXP) Skips Empty Tables (Doc ID 1165344.1)

Last updated on JUNE 30, 2016

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.1.0 to 6.1.1.0 [Release 6.1.0]
Information in this document applies to any platform.
Checked for Relevance on 27-JUN-2012.
Checked for Relevance on 20-JAN-2014.

Symptoms

Having Oracle Database Server 11gR2 (11.2.0.1 or later) Enterprise Edition installed  ***

Find that all empty tables are not exported when using the traditional export (exp) utility.

When re-importing such exported dumps
- views and procedures can not be compiled, due to missing tables.

Affected tables can be identified with SQL command:

select OWNER, TABLE_NAME, TABLESPACE_NAME, SEGMENT_CREATED
from all_tables
where SEGMENT_CREATED = 'NO'
order by table_name;

Changes

Upgrading to Oracle Database Server 11gR2 (11.2.0.1 or later) Enterprise Edition

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms