Re: Export import problem

Also I didnt get any errors/Warnings while exporting and had some warnings while importing.
When the schema size for PSI is around 10GB, my export dump is showing just 500MB. I dont think so much of defragmentation taken place. Please advice if anything to do with LOB segments.

Thanks,
Ann

On Sat, Dec 13, 2008 at 12:23 AM, Shastry(DBA) <shastry17_at_gmail.com> wrote:

> 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