Expdp Sys Aud Table Not Found

Asked By William M Hurtado 0 points N/A Posted on - 07/10/2019

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.

• Status: Open
• Question Views: 83
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Others
• Question Tags: Expdp

Answered By down snieves 0 points N/A #320327

Expdp Sys Aud Table Not Found

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.

About down snieves

Questions
6

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/10/2019
• Question Category: Others