Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Move table sys.aud$ to another tablespace

Re: Move table sys.aud$ to another tablespace

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Fri, 04 Aug 2006 16:13:08 GMT
Message-ID: <pan.2006.08.04.16.15.35.264515@gmail.com>


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.
Received on Fri Aug 04 2006 - 11:13:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US