Happy New Year For All , And Wish you All Best
ORA-20222 “Given capture_id \”%s\” is invalid or the corresponding capture failed”
ORA-20222: Workload was not captured in the current database. Cannot export!
ORA-06512: at “SYS.DBMS_WORKLOAD_CAPTURE”, line 1588
ORA-06512: at line 2
Regarding to Https://support.oracle.com Note :
DATABASE CAPTURE AND REPLAY COMMON ERRORS AND REASONS [ID 463263.1]
is a generic error message that can occur due other underlying error during Capture.
Check the error accompanying with ORA-20222.
Ensure correct directory name is used including check the case-sensitivity of the directory name.
The directory name is case sensitive. Ensure READ and WRITE privilege on the DIRECTORY object to the which is the capture is written.
Happy New Year Again .
Published by Osama Mustafa
Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by Osama Mustafa
One thought on “ORA-20222: Workload was not captured in the current database”
Thank you for posting the great content … I was looking for something like this … I found it quiet interesting, hopefully you will keep posting such blogs ..Oracle Training