|
|
| Re: Can I move AUD$ table to another tablespace [message #349495 is a reply to message #349459] |
Mon, 22 September 2008 01:42   |
 |
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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 #352133 is a reply to message #351852] |
Mon, 06 October 2008 05:16 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
