Why Is Table AQ$_STREAMS_QUEUE_TABLE_P Not Exported With Data Pump ? (Doc ID 1631774.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Oracle Database - Personal Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.5.0 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Goal

You run a full database export:

$ expdp system/manager directory=my_dir dumpfile=expdp_f.dmp logfile=expdp_f.log full=y flashback_time=systimestamp

Export: Release 11.2.0.3.0 - Production on Tue Mar 4 14:09:45 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=my_dir dumpfile=expdp_f.dmp logfile=expdp_f.log full=y flashback_time=systimestamp
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
...
. . exported "STRMADMIN"."STREAMS_QUEUE_TABLE"           17.01 KB       0 rows
. . exported "STRMADMIN"."AQ$_STREAMS_QUEUE_TABLE_C"     5.812 KB       0 rows
. . exported "STRMADMIN"."AQ$_STREAMS_QUEUE_TABLE_G"     13.18 KB       0 rows
. . exported "STRMADMIN"."AQ$_STREAMS_QUEUE_TABLE_H"     9.054 KB       0 rows
. . exported "STRMADMIN"."AQ$_STREAMS_QUEUE_TABLE_I"     9.023 KB       0 rows
. . exported "STRMADMIN"."AQ$_STREAMS_QUEUE_TABLE_L"     7.843 KB       0 rows
. . exported "STRMADMIN"."AQ$_STREAMS_QUEUE_TABLE_S"     11.39 KB       3 rows
. . exported "STRMADMIN"."AQ$_STREAMS_QUEUE_TABLE_T"     6.226 KB       0 rows
...

You noticed that the following tables are not exported:

-  STRMADMIN.AQ$_STREAMS_QUEUE_TABLE_D
-  STRMADMIN.AQ$_STREAMS_QUEUE_TABLE_P

The tables are owned by STRMADMIN, are visible in DBA_SEGMENTS, and do not contain any rows. All objects are valid in the database.

Why are tables STRMADMIN.AQ$_STREAMS_QUEUE_TABLE_D and STRMADMIN.AQ$_STREAMS_QUEUE_TABLE_P not exported by Data Pump ?

 

Solution

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