Last updated on JUNE 30, 2016
Applies to:Oracle Agile Engineering Data Management - Version 184.108.40.206 to 220.127.116.11 [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.
Having Oracle Database Server 11gR2 (18.104.22.168 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
where SEGMENT_CREATED = 'NO'
order by table_name;
Upgrading to Oracle Database Server 11gR2 (22.214.171.124 or later) Enterprise Edition
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms