Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> show block corrupted while importing???

show block corrupted while importing???

From: Leslie Lu <leslie_y_lu_at_yahoo.com>
Date: Thu, 21 Jun 2001 12:37:17 -0700
Message-ID: <F001.003328AF.20010621124712@fatcity.com>

Hi,

I need to export data from one db and import it into another db. The table name, structure in both db are exactly the same. It's Oracle815 on Sun Solaris.

I got error in index file. How does that happen? And what will be the possible solution? Thanks.

Export file created by EXPORT:V08.01.05 via conventional path
import done in US7ASCII character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. importing ICSS's objects into ICSS
. . importing table "INVENTORY_ITEM" IMP-00058: ORACLE error 1578 encountered ORA-01578: ORACLE data block corrupted (file # 10, block # 27164)
ORA-01110: data file 10:
'/orafs03/oradata/CP40PV2/ld_index02.dbf'



Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Leslie Lu
  INET: leslie_y_lu_at_yahoo.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 21 2001 - 14:37:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US