Home » RDBMS Server » Security » Can I move AUD$ table to another tablespace (Linux, 10g)
Can I move AUD$ table to another tablespace [message #349459] Sun, 21 September 2008 23:28 Go to next message
Bangla
Messages: 49
Registered: August 2008
Member
I want to move sys.AUD$ table to another tablespace rather than system. What I need to do?
Re: Can I move AUD$ table to another tablespace [message #349495 is a reply to message #349459] Mon, 22 September 2008 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can but it is not supported unless you are in 10.2.0.3 and up and can use DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION procedure.
See Metalink notes 72460.1 "Moving AUD$ to Another Tablespace and Adding Triggers to AUD$" and 1019377.6: "Script to move SYS.AUD$ table out of SYSTEM tablespace".

Regards
Michel

[Updated on: Mon, 22 September 2008 01:43]

Report message to a moderator

Re: Can I move AUD$ table to another tablespace [message #351826 is a reply to message #349495] Fri, 03 October 2008 06:53 Go to previous messageGo to next message
hellcat
Messages: 84
Registered: January 2006
Location: Zug, Switzerland
Member
Hi,

We're running one DB on Windows (32 bit) platform, Oracle version 10.2.0.4. Unfortunately DBMS_AUDIT_MGMT is not available (from Metalink) as a patch for the Windows platform (only HP-UX, Solaris and AIX).

Am I right that in that situation there is no Oracle supported way to move sys.aud$ to a different tablespace than system?

Thanks!

/hc

[Updated on: Fri, 03 October 2008 06:55]

Report message to a moderator

Re: Can I move AUD$ table to another tablespace [message #351841 is a reply to message #351826] Fri, 03 October 2008 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are right but you can ask for Oracle to provide you such a procedure (if you have a support contract).

Regards
Michel
Re: Can I move AUD$ table to another tablespace [message #351852 is a reply to message #351841] Fri, 03 October 2008 08:19 Go to previous messageGo to next message
hellcat
Messages: 84
Registered: January 2006
Location: Zug, Switzerland
Member
Thanks for the confirmation, I'll see what I can do...
Re: Can I move AUD$ table to another tablespace [message #352133 is a reply to message #351852] Mon, 06 October 2008 05:16 Go to previous messageGo to next message
hellcat
Messages: 84
Registered: January 2006
Location: Zug, Switzerland
Member
Update:
According to Oracle support, DBMS_AUDIT_MGMT will be fully supported with 11.1.0.7 and onwards for the Windows platform. Although it's not officially supported to move SYS.AUD$ to a different TS than SYSTEM, we got the blessing from Oracle supporty to do it manually anyway.

Regards,

/hc
Re: Can I move AUD$ table to another tablespace [message #352144 is a reply to message #352133] Mon, 06 October 2008 05:31 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the update.
I infer in what you said that Oracle refuse to backport the package to pre-11g versions.

Regards
Michel

[Updated on: Mon, 06 October 2008 05:32]

Report message to a moderator

Previous Topic: Find User Usage Log
Next Topic: Table load in oracle 9i
Goto Forum:
  


Current Time: Thu Mar 28 08:12:19 CDT 2024