Ann, Did you log the import to a file? What does the log say? All of this information is not helpful at all. It just shows that the import did not work. What are the errors? Tom ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shastry(DBA) Sent: Friday, December 12, 2008 1:54 PM To: oracle-l Subject: Export import problem Hi all, I have one requirement, ie. to create a schema PSI_DUP same as PSI (existing). I did export the PSI schema first and later created PSI_DUP similar to PSI. Overall schema size is showing as 10GB where as When i do export import I am not getting the import successful with warnings. Could you please help me if any suggestions? SQL> SELECT SUM(bytes)/1024/1024/1024 AS size_gig FROM DBA_SEGMENTS WHERE OWNER= 'PSI'; SIZE_GIG ---------- 10.2319717 SQL> SELECT SUM(bytes)/1024/1024/1024 AS size_gig FROM DBA_SEGMENTS WHERE OWNER= 'PSI_DUP'; SIZE_GIG ---------- .428199768 SQL> select sum(bytes)/1024/1024/1024 as size_gig, segment_type from dba_segments where owner='PSI' group by segment_type; 2 3 4 SIZE_GIG SEGMENT_TYPE ---------- ------------------ .2784729 INDEX .060081482 LOBINDEX .151634216 NESTED TABLE 2.0647049 TABLE 7.67707825 LOBSEGMENT SQL> select sum(bytes)/1024/1024/1024 as size_gig, segment_type from dba_segments where owner='PSI_DUP' group by segment_type; 2 3 4 SIZE_GIG SEGMENT_TYPE ---------- ------------------ .023841858 INDEX .011444092 LOBINDEX .340461731 TABLE .052452087 LOBSEGMENT SQL> Thanks, Ann