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@xxxxxxxxxxx
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

Other related posts: