Results 1 to 2 of 2

Thread: error import

  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: error import

    Hi,
    when I try to import a file dump I get these errors:

    IMP-00003: ORACLE error 604 encountered
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 34367)
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\DBLOCALE\SYSTEM01.DBF'

    The database is in noarchivelog mode and I haven't backup file.
    I tried to create a new datafile (SYSTEM02.DBF) in tablespace system and after to drop SYSTEM01.DBF but It is impossible.

    How Can I resolve this problem??

    Thanks
    Raf

    P.S. It possible drop a datafile in tablespace system without delete all the tablespace?

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •