Oracle

Oracle Community

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!

Community Discussion

dwayne.sawyer
Follow / 27 Jul 2015 at 9:46pm / Oracle

comparing different schemas shows wrong trigger when additional table...

Expand content
Hi All, I think what I'm experiencing may be a bug. Here's the scenario. Toad for Oracle 12.6.0.53 Oracle 11g I'm trying to compare two schemas (idman and lawson9) between two different databases...

Hi All,
I think what I'm experiencing may be a bug. Here's the scenario.
Toad for Oracle 12.6.0.53
Oracle 11g
I'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.

Dwayne

Unanswered 28 0 / Create an account to join the discussion.
dwayne.sawyer
Follow / 23 Jul 2015 at 7:44pm / Oracle

SYS* Indexes not excluded using Compare Multiple Schemas

Expand content
Hello all, 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...

Hello all,

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?

Thanks

Unanswered 48 0 / Create an account to join the discussion.
stones_093
Follow / 8 Nov 2011 at 2:24pm / Oracle
Latest post by on 22 Jul 2015 at 1:51am

select with DB-link does not work

Expand content
I have Toad for Oracle 11.0.0.116 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...

I have Toad for Oracle 11.0.0.116 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?

1317 3 / Create an account to join the discussion.
Sasanksahu
Follow / 20 Jul 2015 at 5:07pm / Oracle

Using value of a column in first cursor in second

Expand content
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 >...

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??? 

Unanswered 58 0 / Create an account to join the discussion.
sam72
Follow / 13 Jul 2015 at 9:39am / Oracle
Latest post by on 16 Jul 2015 at 8:34pm

querry

Expand content
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...

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.

Unanswered 89 1 / Create an account to join the discussion.
eduliu
Follow / 14 Jul 2015 at 4:35pm / Oracle

Views | Script hangs or becomes blank

Expand content
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...

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!

87 0 / Create an account to join the discussion.
iz.tamira
Follow / 17 Jun 2015 at 8:28am / Oracle
Latest post by on 27 Jun 2015 at 3:25pm

How can I access private db links?

Expand content
I created private db link. How to access another user that private link?

I created private db link. How to access another user that private link?

163 2 / Create an account to join the discussion.
john.ouimette
Follow / 24 Jun 2015 at 1:46pm / Oracle

TOAD12.7 bracketing

Expand content
How do I get the brackets around IF-ELSE-ENDIF, BEGIN-END, etc. that were in 12.6 to display in 12.7? Thanks. 12.6 12.7

How do I get the brackets around IF-ELSE-ENDIF, BEGIN-END, etc.  that were in 12.6 to display in 12.7?  Thanks.

12.6

12.7

Unanswered 120 0 / Create an account to join the discussion.
RREM
Follow / 19 Jun 2015 at 11:24am / Oracle

Toad and Oracle 11g

Expand content
Hi guys, I am using a very old version of TOAD - v6.3.3.1.g. I have been using the Database ->Schema Browser feature extensively. We have just upgraded to Oracle 11g On one of the Client machines...

Hi guys,

I am using a very old version of TOAD - v6.3.3.1.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;

  • The Database tab at the top is not highlighted so I cannot use Schema Browser.
  • I can however use SQL to select from tables but I need to use the <owner> table parameter 
  • eg select * from construction.ac_suppliers works fine but select * from ac_suppliers does not
  • I am logging on as construction

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

 

154 0 / Create an account to join the discussion.
parthipanmurali
Follow / 16 Feb 2015 at 11:02am / Oracle
Latest post by on 18 Jun 2015 at 11:03am

oracle

Expand content
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??????

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??????

Unanswered 332 2 / Create an account to join the discussion.
parthipanmurali
Follow / 5 May 2015 at 7:21am / Oracle
Latest post by on 18 Jun 2015 at 11:03am

INSERT

Expand content
i need one insert query in oracle but it will insert multiple row in table. Please help me to do.

i need one insert query in oracle but it will insert multiple row in table.

Please help me to do.

Unanswered 395 5 / Create an account to join the discussion.
iz.tamira
Follow / 17 Jun 2015 at 8:26am / Oracle
Latest post by on 17 Jun 2015 at 5:52pm

How can I know who is using DB Links?

Expand content
I have many base, users and links. I need to know that who is using db links?

I have many base, users and links. I need to know that who is using db links?

Unanswered 174 1 / Create an account to join the discussion.
skashka
Follow / 14 May 2015 at 12:00pm / Oracle
Latest post by on 16 Jun 2015 at 1:18pm

how to execute procedure conatining object type as in parameter?

Expand content
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 || '...

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?

248 3 / Create an account to join the discussion.
ss14
Follow / 20 Apr 2015 at 5:33am / Oracle
Latest post by on 3 May 2015 at 11:06am

Toad connection to a Oracle 10.2.0.3

Expand content
Hi, 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...

Hi,

     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?

Unanswered 325 5 / Create an account to join the discussion.
kaijohnson89
Follow / 1 May 2015 at 10:11pm / Oracle

Loading New PL/SQL Data Table In Toad V12.6.6.53

Expand content
I am using Toad 12.6.6.53. 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...

I am using Toad 12.6.6.53. 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?

148 0 / Create an account to join the discussion.