Export Missing Table on Oracle 11g


I try to export all schema of IPOINT, export succesfully without warning but the table with empty row not exported on Oracle 11g.

using this command :

exp ipoint/xxx file=c:\ipt%date:~4,2%%date:~7,2%%date:~12,2%.dmp log=c:\log\ipt%date:~4,2%%date:~7,2%%date:~12,2%.log

Actually, the solution is simple, we need to do one of the following step

  1.  just insert 1 row in the empty table so it can be exported
  2. update parameter DEFERRED_SEGMENT_CREATION, set to FALSE and then the empty table must be recreated
  3. use expdp

expdp userid=ipoint schemas=ipoint dumpfile=ipt130723.dmp logfile=ipt130723.log directory=DATAPUMPDIR

ALTER USER IPOINT QUOTA UNLIMITED ON USERS;
CREATE DIRECTORY DATAPUMPDIR AS ‘C:\DATAPUMPDIR’;
GRANT READ, WRITE ON DIRECTORY DATAPUMPDIR TO IPOINT;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: