Re: Export import problem

From: <TESTAJ3_at_nationwide.com>
Date: Fri, 12 Dec 2008 14:06:28 -0500
Message-ID: <OF231695E0.78B74033-ON8525751D.0068D544-8525751D.0068C43D@lnotes-gw.ent.nwie.net>

During an export, indexes are not copied as data but only as DDL, ie: create index statements, since internally the index has to be rebuilt as the data block where the "data" truly resides is going to be difference, could that be the difference you are seeing?

joe

---

Joe Testa, Oracle Certified Professional Senior Consultant
Data Engineering and Administration
Nationwide Investments

(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage? Ask me about "Weekend to Remember"
Dec 12-14, 2008 here in Columbus.

From:
"Shastry(DBA)" <shastry17_at_gmail.com>
To:
oracle-l <oracle-l_at_freelists.org>
Date:
12/12/2008 02:00 PM
Subject:
Export import problem
Sent by:
oracle-l-bounce_at_freelists.org

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:06:28 CST