Re: Move table sys.aud$ to another tablespace

On Fri, 04 Aug 2006 05:53:33 -0700, emdproduction wrote:

> In metalink, there is an article talking about moving sys.aud$ to
> another tablespace.

I believe you refer to MEtalink note 1019377.6

I encourage you also to read note 72460.1

>
> Can't we just do "alter table AUD$ move tablespace"???
>

Reading the two notes, I get the impression they are simply an 'update' of things happening in Oracle7. IIRC, the 'MOVE' clause was introduced in Oracle 8 (8i) and it does not appear in the Oracle7 docco.

> Anything wrong with doing alter table stetement on sys.AUD$ table?

As a test, I tried this on XE. No ill effects (yet).

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.