Export import problem

From: Shastry(DBA) <shastry17_at_gmail.com>
Date: Sat, 13 Dec 2008 00:23:36 +0530
Message-ID: <5b294dab0812121053n12a75530h7275f0ce79c7a391@mail.gmail.com>


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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 12 2008 - 12:53:36 CST

Original text of this message