Re: import data error -Oracle 7 on unix

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