Datapump Is Not Exporting All The Data/Rows For Portal Schema. (Doc ID 750532.1)

Last updated on NOVEMBER 16, 2016

Applies to:

Portal - Version 10.1.2.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 18-Aug-2014


Goal

Why the export log, shows no rows exported, using "datapump" as follows:

             expdp portal/password@<passwd> schemas=portal directory=datapump_dir dumpfile=portal.dump logfile=expportal.log


SQL> select count(*) from PORTAL.WWPRE_VALUE$;


COUNT(*)
----------
33201




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