I'm doing an export/import. I don't want to import all the schemas from the old database, so I use fromuser-touser option. I understand I can use SYS or SYSTEM in this option. But I do need the sys.aud$ table records from the old database into the new.
What I've done is complete the import using fromuser-touser. Then once that's complete, I create db link in the new db to the old db. I do a insert into sys.aud$ (select * from sys.aud$@olddb) to get all the sys.aud$ from the old db into the new db.
Not having much experience with auditing, does any see anything wrong with doing this?
Click Here to Expand Forum to Full Width