Exp Command not exporting 0 rows tables in oracle 11g

Posted on 2013-06-17
Last Modified: 2013-08-29

We are not able export 0 rows table using oracle 11g standard or enterprise edition.Can any body help me in this regards.

Question by:gotetioracle
LVL 48

Expert Comment

Comment Utility
you may want to look at this forum:

not sure why you want this export - but maybe that thread will assist
LVL 29

Accepted Solution

MikeOM_DBA earned 500 total points
Comment Utility
Perhaps in its fixed:

SQL>  select * from v$version;
Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE      Production
TNS for IBM/AIX RISC System/6000: Version - Production
NLSRTL Version - Production

SQL>  show parameter deferred

NAME                        TYPE          VALUE
--------------------------- ------------- ------------------------------
deferred_segment_creation   boolean       TRUE


Open in new window

Here is a snippet of the log from a test export, notice all the zero rows tables:
==> expdp / directory=mom dumpfile=scott.dmp schemas=scott

Export: Release - Production on Wed Jun 19 17:26:57 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "OPS$ORACLE"."SYS_EXPORT_SCHEMA_01":  /******** directory=mom dumpfile=scott.dmp schemas=scott
Estimate in progress using BLOCKS method...
. . . E t c . . .
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
. . exported "SCOTT"."HEALTHCHECK"                       49.29 KB    1797 rows
. . exported "SCOTT"."CARD_FILE"                         6.023 KB       8 rows
. . exported "SCOTT"."DEPT"                              5.937 KB       4 rows
. . exported "SCOTT"."EMP"                               8.570 KB      14 rows
. . exported "SCOTT"."EMP2"                              8.976 KB      14 rows
. . exported "SCOTT"."GROUPMEMBERSHIP"                   5.640 KB      13 rows
. . exported "SCOTT"."ITEM_RATE"                         5.984 KB       7 rows

.. . .   E t c   . . ..

. . exported "SCOTT"."WDIC"                              7.453 KB      10 rows
. . exported "SCOTT"."WELL"                              5.468 KB       1 rows
. . exported "SCOTT"."WELLTEST_MSR"                      6.156 KB      12 rows
. . exported "SCOTT"."BONUS"                                 0 KB       0 rows
. . exported "SCOTT"."CT"                                    0 KB       0 rows
. . exported "SCOTT"."EMP3"                                  0 KB       0 rows
. . exported "SCOTT"."GARE"                                  0 KB       0 rows
. . exported "SCOTT"."GARA_CATEGORIE"                        0 KB       0 rows
. . exported "SCOTT"."INTERNAL_EXAMPLE"                      0 KB       0 rows
. . exported "SCOTT"."SO_WELLTEST_PLUS"                      0 KB       0 rows
. . exported "SCOTT"."WSF_TABLE"                             0 KB       0 rows
Master table "OPS$ORACLE"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
Dump file set for OPS$ORACLE.SYS_EXPORT_SCHEMA_01 is:
Job "OPS$ORACLE"."SYS_EXPORT_SCHEMA_01" successfully completed at 17:29:06

Open in new window


Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SSN Format in Oracle 2 59
CREATE TABLE syntax 4 44
query in Oracle forms Builder 2 26
ORA-12560: TNS:protocol adapter error 8 42
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now