我本来有一些同义词指向某个用户下相应的表,这个用户我现在不用了,于是就先删除该用户,然后再试图删除同义词,就报错了:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist请问有没有什么办法删除这些同义词?或者重建它们,使其指向存在的用户下相应的表?
谢谢!
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist请问有没有什么办法删除这些同义词?或者重建它们,使其指向存在的用户下相应的表?
谢谢!
我的oracle版本是10g,重建同义词,重新指定为存在的用户下的表后,再删除仍旧不行。仍旧报这个错:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
后台无法删除,console应该同样无法删除吧?关键是我现在oem也无法进入,具体原因也不明,报错如下:
500 Internal Server Error
java.lang.NullPointerException at java.util.Hashtable.put(Hashtable.java:393) at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:182) at oracle.sysman.emSDK.svc.conn.ConnectionService.getConnection(ConnectionService.java:289) at oracle.sysman.emSDK.svc.conn.ConnectionService.getConnection(ConnectionService.java:261) at oracle.sysman.db.adm.inst.ChangeStateController.getRepConnection(ChangeStateController.java:1213) at oracle.sysman.db.adm.inst.ChangeStateController.setEMDUrl(ChangeStateController.java:1239) at oracle.sysman.db.adm.inst.ChangeStateController.handleGetDBState(ChangeStateController.java:735) at oracle.sysman.db.adm.inst.ChangeStateController.handleSpecifyOperations(ChangeStateController.java:677) at oracle.sysman.db.adm.inst.ChangeStateController.onEvent(ChangeStateController.java:516) at oracle.sysman.db.adm.DBController.handleEvent(DBController.java:3064) at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:376) at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:169) at oracle.sysman.db.adm.DBControllerResolver.handleRequest(DBControllerResolver.java:114) at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:688) at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:291) at oracle.sysman.eml.app.Console.doGet(Console.java:135) at oracle.cabo.servlet.UIXServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:101) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16) at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:109) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20) at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:239) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:600) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534)