ora-00942
Cannot create or drop any oracle objects
I\'m trying to update an oracle database so that it\'s schema matches a second database exactly.In doing so I\'ve hosed something. I can\'t create or drop any object.[详细]
2022-12-21 13:31 分类:问答python中的字符串切割 maxsplit
目录python 字符串切割 maxsplitpython字符串切割split和rsplit函数1. split(sep, maxsplit)2. rsplit(sep, maxsplit)总结python 字符串切割 maxsplit[详细]
2022-12-21 09:17 分类:开发莎士比亚是谁画的呢??
珍_749 2022-05-17 05:16 莎士比亚?画家?我知道的世界著名的莎士比亚是一位伟大的剧作家、诗人。威廉·莎士比亚(W. William Shakespeare;1564~1616)开发者_JS百科英国文艺复兴时期伟大的剧作家、诗人,欧[详细]
2022-12-20 14:52 分类:问答How can I improve this exception retry scenario?
I have a web service method I am calling which is 3rd party and outside of my domain. For some reason every now and again the web service fails with a gateway timeout. Its intermittent and a call to i[详细]
2022-12-20 11:51 分类:问答ORACLE :Are grants removed when an object is dropped?
I currently have 2 schemas, A and B. B has a table, and A executes selects inserts and updates on it. In our sql scripts, we have granted permissions to A so it can complete its tasks.[详细]
2022-12-19 23:41 分类:问答What's your favorite folding method (or secret techique) in Vim for HTML, Javascript and CSS? [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing[详细]
2022-12-18 20:20 分类:问答Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?
One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_SCHEMA option. However there is an issue in that triggers are not properly remapped. This lea[详细]
2022-12-17 08:35 分类:问答Oracle PLSQL - Declare a cursor on a non-existing table
I want to declare a cursor on a table that does not exist. Of course, my procedure doesnt compile. This table is a temporary table, and is created by a pre process. It will exist on runtime, but at c[详细]
2022-12-14 09:27 分类:问答Problem With Simple PL/SQL Program
Here is my simple PL/SQL program: DECLARE CURSOR c1 is SELECT typ, specifikacia_typu, spz FROM Auta WHERE (substr(spz, 1, 2) = \'KE\' OR substr(spz, 1, 2) = \'KS\') AND ROWNUM <= 2;[详细]
2022-12-11 02:42 分类:问答How does one cheaply validate the existance of a column in a table in another schema with Oracle?
The environment is Oracle 9 & 10.I do not have DBA level access. The problem is to verify that a specific column exists in a specific table, in another schema.[详细]
2022-12-10 07:02 分类:问答