Oracle database

If you plan to use dbimport.pl to create your database instance, before importing the Oracle .dmp file, the Oracle database administrator must set deferred_segment_creation=false to ensure that any empty tables in the .dmp file are imported.

Enter the following SQL alter system command to dynamically alter the Oracle database instance:
alter system set deferred_segment_creation=false scope=both;