Re: sys.aud$ not in sysaux tablespace by default - what gives?

hi,Paul Drake

   i think you can .
  from oracle 8i, i had move the aud$ and the indexes to others tablespace, had no problem.   many sys segments can not be move ,i think the reason is during DB startup oracle will *read* the segment header in the fixed datafile block. i had some test on it and trace the startup,bootstrap$ is the first eggs, then system rollback segment,CLUSTER C_OBJ#,INDEX I_OBJ#, table tab$....etc . It is interesting .  

Best regards

msn: biti_rainy_at_hotmail.com
a dba from alibaba(china)

• from the mail-----
  >It was my understanding that the segment sys.aud$ would be created in
  >the sysaux tablespace in 10g.
  >I guess I assumed too much.
  >
  >10.1.0.3 Std Ed lin32
  >RHEL 3.0 ES Update 2 (current)
  >
  >sys.aud$ is still in the system tablespace, not in sysaux.
  >checked metalink.
  >used a search engine.
  >found no docs covering the SUPPORTED altering of this.
  >
  >Does anyone know if it is supported by Oracle to move this table from
  >the System tablespace into the sysaux tablespace?
  >
  >Paul
  >--
  >http://www.freelists.org/webpage/oracle-l
  >
  >.
  

--
http://www.freelists.org/webpage/oracle-l