Re: Corrupt System table

On Jul 5, 12:51 pm, Paul <paulwragg2..._at_hotmail.com> wrote:
> Hi,
>
> We had some corrupt blocks in some of our data files. I have managed
> to sort these out. However, I used DBV to check all data files that
> were on the same disk and it came back with 1 corrupt page in the
> SYSTEM table space.
>
> The segment is called IDL_UB2$
>
> The DB concerned is a test DB with customer databases, therefore we do
> not back up the database. I could just export all the user data,
> recreate the instance and re-import, but if I can avoid this I would
> like to.
>
> I have looked in metalink but I cannot really find out what this table
> is, or what it is used for.
> Can anybody explain it to me, and tell me whether I can just use a
> script to rebuild the table?
>
> Thanks in advance!
>
> Paul

IDL tables store PL/SQL, and are in the SYS schema. The SYS schema on its own is not exported EVER, as it contains the datadictionary, which is maintained automagically. You can look at the utlip.sql script in $ORACLE_HOME/rdbms/admin to see them in action. My bet is you won't be capable to make a valid export. Your hope should be you have a valid ascii dump for your PL/SQL floating around 'somewhere'
Otherwise you could administer a suicide pill to the database.

--
Sybrand Bakker
Senior Oracle DBA