RE: Export import problem
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <shastry17@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Dec 2008 14:07:44 -0500
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:
