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;

Advertisements