RE: Export import problem

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 12 Dec 2008 14:07:44 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE095D9@EXCNYSM0A1AJ.nysemail.nyenet>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 12 2008 - 13:07:44 CST