RE: Export import problem

From: SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>
Date: Fri, 12 Dec 2008 14:02:55 -0500
Message-ID: <8833494F383585499CB855121711D2630914FF8EF9@JBXEXVS02.fplu.fpl.com>

What are your export/import parameters? Export file sizes?

Jeremy Sheehan
Oracle DBA
Jeremy.Sheehan_at_fpl.com
(561) 304-5769 - office
(561) 625-7196 - fax
P Consider the environment. Please don't print this e-mail unless you really need to.

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:02:55 CST