Export import problem
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 13 Dec 2008 00:23:36 +0530
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:
