You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Oracle great and have the most points for this month!
NOTE: This forum is for non-product questions and discussions on the Oracle database platform. Please post Toad-family product questions in their respective product forums. Thanks!
Hi All,I think what I'm experiencing may be a bug. Here's the scenario.Toad for Oracle 18.104.22.168Oracle 11gI'm trying to compare two schemas (idman and lawson9) between two different databases (LawTest and Lawprod). I have about 13 examples like the one I'm going to show, but just going to show this one because it's short and sweet.Both schemas reside in both databases, so there is an idman in lawtest and lawprod, just as there is a lawson9 in lawtest and lawprod.I'm comparing the triggers and the trigger example I'm going to use is HRSUPER_AI.There is a idman.HRSUPER_AI and a lawson9.HRSUPER_AI in both databases.The lawson9. HRSUPER_AI is disabled on both databases.Also, each version of the trigger on each database matches its counterpart on the other database, for example: lawtest.idman.HRSUPER_AI matches lawprod.idman.HRSUPER_AI as well as lawstest.lawson9.HRSUPER_AI is equal to lawprod.lawson9.HRSUPER_AI. Therefore when you compare the two schemas from the two databases you should get zero differences because the trigger in each database.schema matches.
In fact, if I run the multiple schemas compare with only the "Trigger" options >> Object Types to Compare is selected, I do indeed get zero differences.However, the problem occurs when I select "Tables" or "Views" in addition to the "Triggers" Object Types to Compare.either of these combinations will count as differences to these triggers and when I double click the results line that references the difference I get a comparison that looks like this:
And sometimes I even get a difference that's highlighted but that difference would be the schema name in the trigger's name line.
Has anyone else run into this issue or is this a bug? Am I missing something as far as parameters to turn on/off that prevents this kind of comparison?
Thanks for any assistance.
While using the utility for comparing multiple schemas, I have an inclusion Option set up like this:
One of my schema's however returns a differences like this:
Based on the logic of the inclusion option, shouldn't these objects be excluded?
I have Toad for Oracle 22.214.171.124 on a Windows 7 pc. I have a select on a table in a different Oracle database by using a db-link. WHen I execute this statement with ctrl+CR or F9 I get an error message: "ORA-02019: connection description for remote database not found". When I execute this as a script (F5) the sql executes ok. Anyone knows what is wrong?
FOR vll_use IN cur_vll LOOP v_item := vll_use.item; v_dest := vll_use.dest; v_aggqty := vll_use.aggsupqty;
FOR sk_lir IN cur_sk_lir LOOP v_aggqty := v_aggqty - sk_lir.needqty;
CASE WHEN v_aggqty > 0 THEN UPDATE suppordersku sk SET status = 2 WHERE sk.item = v_item AND sk.loc = v_dest AND sk.needarrivdate = sk_lir.needarrivdate; DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty); WHEN v_aggqty = 0 THEN UPDATE suppordersku sk SET status = 2 WHERE sk.item = v_item AND sk.loc = v_dest AND sk.needarrivdate = sk_lir.needarrivdate; DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty); ELSE UPDATE suppordersku sk SET needqty = ABS (v_aggqty) WHERE sk.item = v_item AND sk.loc = v_dest AND sk.needarrivdate = sk_lir.needarrivdate; DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty); END CASE; END LOOP;
FOR sk_gui IN cur_sk_gui LOOP v_aggqty := v_aggqty - sk_gui.needqty;
How to avoid entering second loop i.e. cur_sk_gui if value of v_aggqty =0 after 1st loop???
suppose there is an office id column with 10 values and having billing status of 'c','l','d','i','n' i want the querry for the count using the decode function and the count should be equal to the office_id consumer numbers.
When I try to display the script behind a view - i.e., click on the "Views | Script" tab, Toad would keep spinning. If I click on another tab, like "Data," it would display the data without any issue. But when I click back to the "Script" tab, it would be blank. This only happens recently. What would be the cause? And any way to fix this? Thanks!
I created private db link. How to access another user that private link?
How do I get the brackets around IF-ELSE-ENDIF, BEGIN-END, etc. that were in 12.6 to display in 12.7? Thanks.
I am using a very old version of TOAD - v126.96.36.199.g.
I have been using the Database ->Schema Browser feature extensively.
We have just upgraded to Oracle 11g
On one of the Client machines, I have Discoverer Desktop and I have installed Toad on that machine.
It is working to some extent but I have an issue as follows;
Previously, I would just select * from ac_suppliers
Anybody know of any setting that I can use to make my Database - Schema Browser active. Thannks in advance
when i have start oracle 12c database using sql developer but it shows initialization or shutdown in progress. any one help me come over the error??????
i need one insert query in oracle but it will insert multiple row in table.
Please help me to do.
I have many base, users and links. I need to know that who is using db links?
create or replace procedure GETINFO(P_IDS in IDS_TABLE) is --- IDS_TABLE is a table of object type conatins id1,id2,id3 cols. begin for I in 1 .. P_IDS.COUNT LOOP DBMS_OUTPUT.PUT_LINE(P_IDS(i).ID1 || ',' || P_IDS(i).ID2 || ',' || P_IDS(i).ID3); END LOOP; end GETINFO;
how to execute this procedure to get the out put?
Sorry I am very new to this tool. I would need to connect to a Oracle 10.2.0.3 . What I have done so far download the sqlplus client and the relevant OCI directory all into one directory. I have set the path, ORACLE_HOME and TNS_ADMIN all to this folder where the sqlplus client . There after I tried to run my toad it say no client is found. I am not sure must is my toad the issue ? My toad say 12. 6.0.53 does this correspond to the Oracle version?
I am using Toad 188.8.131.52. When I try to create a table and import an Excel Sheet with more than 256 columns it gets cut off and the columns become non-custom. It goes back to excel letters instead of the custom names I have. Does anyone know of a work around for this?