Expdp Sys Aud Table Not Found

Asked By 0 points N/A Posted on -
qa-featured

I had created a Secondary table for my database and then I tried to export it. but I encountered the following error: “ORA-39166: The expdp sys aud table was not found.”How can I solve it? Please help.

SHARE
Answered By 0 points N/A #320327

Expdp Sys Aud Table Not Found

qa-featured

First, check how many records were deleted in which period. Secondly, how much time did you keep to check them? Now, I restore the production database in the LAB environment, then I intend to export the sys.aud $ table. Once you have restored your lab environment, create a new table/segment in a non-Sys schema. Export the segment, and then import it only into a non-sys scheme. Do not insert anything in sys.aud $ now. If you keep this segment for this review period up to your one-year threshold, you can throw it in the trash.

Login/Register to Answer

Related Questions