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
and it giving the following error
Error starting at line 28 in command:
alter database datafile 'C:\oraclexe\files\sys.bf' offline drop
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?