| move table (AUD$) to different tablespace [message #63143] |
Tue, 14 September 2004 04:02  |
shyam
Messages: 25
Registered: January 2001
|
Junior Member |
|
|
Hi frnds
I am using oracle7.3.I enabled the auditing .Now the aud$table becomes 1.5 GB and its consumes the space in system tablespace.I need to move the aud$ table.I dont want to truncate the table.if is use this commnad whehter it will give any problem
alter table aud$
default tablespace audts;
i had a confusion about it pls clrfy my dought
with regards
shyam
|
|
|
|
| Re: move table (AUD$) to different tablespace [message #63151 is a reply to message #63143] |
Tue, 14 September 2004 20:04  |
Rashmi
Messages: 20
Registered: April 2001
|
Junior Member |
|
|
Hi Shyam,
I do not think changing the tablespace for aud$ table is allowed..
Suggest u let it remain in the current tablespace only. Instead create another table (with similar columns) in different tablespace and have a daily scheduled procedure to remove the data from aud$ table and insert it in the newly created table. Also u need to look how into the regular clean up of this new table. May be u can clean up the data older than 30 days or so..
~Rashmi
|
|
|
|
| Re: move table (AUD$) to different tablespace [message #63158 is a reply to message #63151] |
Wed, 15 September 2004 00:16 |
shyam
Messages: 25
Registered: January 2001
|
Junior Member |
|
|
normally i do clean from aud table
each month.I cannot do now because the
db in archive mode and log fill full.so i dont ahve
permision to move the files from archive location.
normally i create a temp table and move to this table
and take a export after that i will truncate the table
with regards
shyam
|
|
|
|
| Re: move table (AUD$) to different tablespace [message #63159 is a reply to message #63158] |
Wed, 15 September 2004 00:28 |
Rashmi
Messages: 20
Registered: April 2001
|
Junior Member |
|
|
Hi Shyam,
When I said create a new table I meant to let it remain forever. and have daily scheduled job to do the cleanup of the aud$ table.. so the aud$ table has only one day data at any given time.
In this daily schedule procedure write stmnts to do the clean up of the data in the new table where sysdate -date < 30 days.
So at any given time the other tbale will have data not more than 30 days.
I am still unclear about the archive log and file move problem..
Can't u create a table a create table audHist as select * from aud$;
then do truncate table aud$...
What is the error thrown..?
~Rashmi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
