Move table sys.aud$ to another tablespace

[emdpro...@hotmail.com]

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

1)create tablespace "AUDIT" datafile '$HOME/data/aud01.dbf' size 500k
default storage (initial 100k next 100k pctincrease 0)

2)create table audx tablespace "AUDIT" storage (initial 50k next 50k
pctincrease 0) as select * from aud$ where 1 = 2

3) rename AUD$ to AUD$$

4)rename audx to aud$

5)create index i_aud2
on aud$(sessionid, ses$tid)
tablespace "AUDIT" storage(initial 50k next 50k pctincrease 0)

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

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

[Brian Peasland]

I've done ALTER TABLE MOVE to place AUD$ in another tablespace. IIRC, it
is not officially supported, but it does work without any problems.

I'm not sure what document you were talking about, but it could have
been written before the ALTER TABLE MOVE option was available. IIRC, the
ability to to ALTER TABLE MOVE was first introduced in Oracle 8i.

HTH,
Brian

--
===================================================================

Brian Peasland
d...@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

[sybrandb]

Hopefully you did read the article carefully. Oracle doesn't support
moving sys.AUD$.

--
Sybrand Bakker
Senior Oracle DBA

[EdStevens]

I could very well be wrong (often am) but I think this is kind of like
altering sessions to get a 10046 trace ... officially unsupported
(outside the direct supervision of Oracle support) but well documented,
well known, and widely used. It's my understanding that it is
desirerable to get a volatile table like AUD$ out of the system
tablespace.

[HansF]

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.