2 Replies Latest reply: Feb 11, 2013 5:45 PM by asahide RSS

    problem with purge temp and system tablespace

    989623
      hi,

      i am purging tablespec with sys user and it seems doing it, but tablespaces are still full

      also wanted to drop a datafile

      alter tablespace system drop
      datafile 'C:\oraclexe\files\sys.bf'

      and it giving the following error

      Error starting at line 28 in command:
      alter database datafile 'C:\oraclexe\files\sys.bf' offline drop
      Error report:
      SQL Error: ORA-01541: system tablespace cannot be brought offline; shut down if necessary
      01541. 00000 - "system tablespace cannot be brought offline; shut down if necessary"
      *Cause:    Tried to bring system tablespace offline
      *Action:   Shutdown if necessary to do recovery


      but if i shutdown how i drop it? or delete manually the file?


      sorry for the 2 question in one thread

      thanks