This content has been marked as final. Show 3 replies
The error is listing the LTDEMO schema, not HR. It should not be necessary to manually cleanup the metadata in order to version the table again. If this was not an issue with using the wrong schema, you can try to run the following:
SQL> exec dbms_wm.RecoverFromDroppedUser ;
If that still doesn't help, you would need to file an SR.
Thanks for the response. I might have introduced little bit confusion in my text. Please ignore LTDEMO schema in error message and consider that it was HR schema. I will try as you suggested and let you know the results.
Edited by: Kumar on Jan 18, 2012 12:48 PM
Your help worked for me. Thanks :)