Oracle 9i Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle 9i Problem

  1. #1
    Join Date
    Mar 2002
    Posts
    1
    hi

    I am using Oracle9i.
    I created one more UNDO tablespace for testing purpose.
    After that i dropped this tablespace datafile (undo tablespace)
    using alter database...offline drop command.
    Deleted the file using OS command.
    When i restarted the DB as SYS user i could not able to start it.The instance is referring the Datafile which i dropped.
    How to remove this reference or kindly help me if anyone knows about this problem.

    I am sending the trace file error.


    Thanks in advance,
    S.Kumar

    The trace file messages,

    Dump file F:\oracle\admin\citimis1\udump\ORA00948.TRC
    Mon Mar 12 22:27:06 2001
    ORACLE V9.0.1.1.1 - Production vsnsta=0
    vsnsql=10 vsnxtr=3
    Windows 2000 Version 5.0 , CPU type 586
    Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
    With the Partitioning option
    JServer Release 9.0.1.1.1 - Production
    Windows 2000 Version 5.0 , CPU type 586
    Instance name: citimis1

    Redo thread mounted by this instance: 1

    Oracle process number: 12

    Windows thread id: 948, image: ORACLE.EXE


    *** SESSION ID:(7.1) 2001-03-12 22:27:06.000
    Evaluating checkpoint for thread 1 sequence 242 block 3
    *** 2001-03-12 22:27:07.000
    KCRA: start recovery buffer claims
    *** 2001-03-12 22:27:07.000
    KCRA: buffers claimed = 7/7, eliminated = 0
    ORA-00376: file 2 cannot be read at this time
    ORA-01110: data file 2: 'F:\ORACLE\ORADATA\CITIMIS1\UNDOTBS01.DBF'


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Dropping the datafile is not the same as dropping the tablespace. You will have to startup mount and then drop the undo tablespace.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width