Re: import data error -Oracle 7 on unix

From: Ronald <ronr_at_wxs.nl>
Date: Thu, 24 Jun 1999 6:20:09 +0200
Message-ID: <01HW.B3977E9900011560123E5040_at_news.wxs.nl>


On Wed, 23 Jun 1999 10:40:04 +0200, ramesh_pratapa_at_my-deja.com wrote (in message <7kq6h3$1q0$1_at_nnrp1.deja.com>):
>
> dear all,
>
> Needs suggestions on the following problem.
>
> 1. EXPORTED A TABLE IN ORACLE 7.1.6.
>
> 2. TABLE GOT CORRUPTED (DATABASE BLOCK CORRUPTED)
>
> 3. WHEN TRYING TO IMPORT THE TABLE BACK INTO DATABASE (CORRUPTED TABLE WAS
> DROPPED (127,000 RECORDS ONLY))
>
> FOLLOWING ERROR DISPLAYS AND THE TABLE IS NOT IMPORTED. THIS TABLE IS IN
> SYSTEM TABLESPACE AND THERE IS ENOUGH SPACE IN THIS TABLESPACE.
>
> IMP-0003: ORA-01578: FREE LIST (32767) EXCEEDS MAXIMUM NUMBER (24)
>
> 4. PLEASE SUGGEST HOW TO IMPORT THIS FILE BACK INTO DATABASE.
Hi Ramesh,

just create the table manually preferably in an other tablespace than SYSTEM. Next use imp ignore=y table=yourTable. You can get the DDL using exp indexfile=x.sql

This should work

-- 
Ronald - certified Oracle DBA http://home.wxs.nl/~ronr/professional.html
       - unix/sa              http://www.tresco.nl/dcl.html
       - Middleware programmer/
                      designer    mailto:R.Rood_at_tresco.nl
 
Received on Thu Jun 24 1999 - 06:20:09 CEST

Original text of this message