This discussion is archived
2 Replies Latest reply: Feb 11, 2013 3:45 PM by asahide RSS

problem with purge temp and system tablespace

989623 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points