All tablespaces can be taken offline...for some you use the "alter tablespace" command, for others, you can use the "rm" command :-) On 7/31/05, Lex de Haan <lex.de.haan@xxxxxxxxxxxxxx> wrote: > which document? you can definitely take SYSAUX offline -- some stuff won't > work, > obviously :-) > in Oracle 10g, you *must* have a SYSAUX tablespace, but you can take it > offline, > as you found out. > > kind regards, > > Lex. -- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- //www.freelists.org/webpage/oracle-l