Oracle error ORA-00604 Recursive SQL Level 1 Error ora-00942 table or attempt does not exist ORA-06512 in line 11

The error is as follows:

Search a lot of methods, but there is no way to solve, but eventually found a good solution,

Thanks to the man's blog, "http://blog.itpub.net/519536/viewspace-689469."

The content is purely reproduced, suggest to the original blog to see the details

Processing methods
Now that you know what caused the user to fail to delete, the table sdo_geom_metadata_table was not found. The way to deal with it is to find it.
We can consider using the Catmd.sql script to re-initialize the table used by the Oracle spatial restore method.

1) directory where the Catmd.sql script is located
$ORACLE _home/md/admin

2) Run Catmd.sql script with sys user
[Email protected]> @?/md/admin/catmd.sql

...... A lot of running information is omitted here ...

3) In this attempt the user deletes
[Email protected]> drop user sec_target cascade;

User dropped.

OK, user delete succeeded.

Oracle Error ORA-00604 recursive SQL Level 1 Error ora-00942 table or attempt does not exist ORA-06512 in line one