RE: Export import problem

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

Other related posts: