If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Our aud$ table has over 3 million records. My manager wants to set up the following to clean out the records. We would like to export it weekly on Sunday nights and then truncate, after export, every three months. How do I accomplish this? Thanks.

It doesn't matter if the sintax is correct or not - as omegamark already mentioned you can not export tables owned by sys. No matter which user you us eto connect to database at export time, there is no way to export SYS's table!

If you realy want to export a content of a AUD$ and later want to truncate it, you can do the following (it might be "officialy unsuported" by Oracle Corp, however I've found this tip from some Oracle Suppot script):

That way system will create audit records into SYSTEM's table AUD$ which will behave exatly as the original audit table, and you can export it. Test this before you use it because I'm writing this from teh memory. I've used this in the past, before the 8i this was also the only way to simulate 8i's DDL triggers and logon triggers, because you can create triggers on SYSTEM.AUD$, which you can't on SYS.AUD$.

HTH,

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?