Oracle - Oracle - Toad World

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

aditya_kommu
Follow / 7 Feb 2016 at 9:07pm / Oracle

Scheduler Not Working(Automatic Designer )

Expand content
Hi All, My task is to excute a custom sql and export the result to excel . I have toad for oracle I have followed: https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/09/21/task...

Hi All,

My task is to excute a custom sql and export the result to excel . I have toad for oracle

I have followed:

https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/09/21/task-automation-in-toad-174-saving-you-hours.

I have wen to automated designer and right clicked  on Action and said schedule and scheduled for a time, it is showing up in Scheduled items , but  task will not excute , Can some one tell me Do I need to do anything else.?

67 0 / Create an account to join the discussion.
student2016
Follow / 1 Feb 2016 at 1:26pm / Oracle

Error ORA-06502 and ORA-06512

Expand content
Hi, i added my own "ruleset" in toad 12.8. then i clicked "save results in db" and executed the code analyzis. now I get the errors Ora-06502 and ora-06512. could anybody tell...

Hi,

i added my own "ruleset" in toad 12.8. then i clicked "save results in db" and executed the code analyzis.
now I get the errors Ora-06502 and ora-06512. could anybody tell me please why I get them?

best regards,

student2016

Unanswered 67 0 / Create an account to join the discussion.
kiyoka.takahashi
Follow / 28 Jan 2016 at 10:04pm / Oracle

SQL Navigator 7.2.0 problem with viewing procedure belongs to other...

Expand content
A user with "select any dictionary", "select any table" and "select_catalog" role is not able to view the procedure created under other user. What else does the user need...

A user with "select any dictionary", "select any table" and "select_catalog" role is not able to view the procedure created under other user. 

What else does the user need in order to view procedure source code belongs to other user?

Thanks in advance,

KT

78 0 / Create an account to join the discussion.
mvnrajan
Follow / 13 Jan 2016 at 5:47pm / Oracle
Latest post by on 19 Jan 2016 at 6:35pm

Toad hangs always

Expand content
Hello All, Toad - 11.0.0.116 (Licensed version) Oracle Server - 11.2.0.3.0 Oracle Client - 11.2.0.1.0 OS - Windows 7 Professional - Service Pack 1 My Toad was working perfectly till last week...

Hello All,

Toad - 11.0.0.116 (Licensed version)

Oracle Server - 11.2.0.3.0

Oracle Client - 11.2.0.1.0

OS - Windows 7 Professional - Service Pack 1

My Toad was working perfectly till last week. All of sudden starting this week, Every thing gets hanged and gives result after 30 to 40 Secs . Even executing 'Select sysdate from dual'  gives result after 30 Secs. But I am able to connect to Oracle server using SQL+ and SQL Developer without any issues and execute all the queries. As soon as i hit F9, it just hangs for 30 Secs.

I tried re-installing Toad with no luck.

Any help much appreciated.

Thanks!!!

131 1 / Create an account to join the discussion.
Anand Janakiraman
Follow / 13 Jan 2016 at 7:55am / Oracle

RAC Service Behavior

Expand content
Assume we have a service with preferred node as 1 and available node as 2. Scenario 1: We are shutting down the instance 1 manually what will happen to the service? Will it failover to available...

Assume we have a service with preferred node as 1 and available node as 2.

 

Scenario 1:

 

We are shutting down the instance 1 manually what will happen to the service? Will it failover to available node?

 

No it won’t and if we query the status of the service it will report that it is not running.

 

Always we have to relocate service if it is running on single node. More than one node no issues.

or 

In 11.2, you need to specify -f option if you want service failover (start in another instance)) to available instance (ie, srvctl stop instance -d xxx -i xxx1 -f) when stopping instance using srvctl and the service is running on only one node.

 

Scenario 2:

 

We are killing pmon for a instance to test or node eviction happens due to contention or high memory swapping and node 1 evicts. What will happen to the service? Will it failover?

 

Yes service failover happens only when the instance or node evicts based on the service configuration. Always ensure service is configured in more than one node.

 

 

****************************************

While creating a service it creates the service as below

 

Management policy: AUTOMATIC which means it will start the service when it comes up if we stop and start the instance manually.

 

we have a service which is running on both the nodes as preferred. When I bring down the instance 1 service will run on node 2. After patching or node eviction  if we bring up the instance or node 1 up the service will start running on both the nodes 1 & 2.

 

Any suggestion or corrections to this post are welcome.

Also would like to know how cluster decides whether to fail over or to start back a service? where can i get more readings on this?

92 0 / Create an account to join the discussion.
ChrisJohnson
Follow / 30 Nov 2015 at 7:49pm / Oracle

White Papers

Expand content
I publish a free e-magazine for SQL, R, SAS, and MS Office for sample code and tips. I would like to invite everyone here to subscribe and, if you are interested, to contribute. If you have white papers...

I publish a free e-magazine for SQL, R, SAS, and MS Office for sample code and tips.  I would like to invite everyone here to subscribe and, if you are interested, to contribute.  If you have white papers that you would like to contribute, you can email me at

chris@codeitmagazine.com

If you would like to subscribe, you can go to 

http://www.codeitmagazine.com/subscribepg.php

My recent and upcoming Oracle articles include regular expressions, connect by, date dimensions, analytic functions, flashback/rollback, and great ways to use the data dictionary.  Not only can you subscribe on the website, but it also has white papers and code files for download.

Thanks,

Chris

174 0 / Create an account to join the discussion.
ameerkhan.R
Follow / 4 Nov 2015 at 11:06am / Oracle
Latest post by on 20 Nov 2015 at 5:30pm

need to split two column by using (>) and (<=)

Expand content
i have two separate query like this, only different with this two query on first query i am using nvl(cm.CONT_FINAL_AMT,0)>nvl(cm.CONT_PAID_AMT,0) on second query i am using and nvl(cm.CONT_FINAL_AMT...

i have two separate query like this, only different with this two query

on first query i am using                                  nvl(cm.CONT_FINAL_AMT,0)>nvl(cm.CONT_PAID_AMT,0)

on second query i am using                           and nvl(cm.CONT_FINAL_AMT,0)<=nvl(cm.CONT_PAID_AMT,0)

i need a column like                item_code           model_name            color_name         >value         <=value

give me some suggestion

select

im.ITEM_CODE, wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, sum(cd.ITEM_PIECES), SUBSTR(wm.MODEL_NAME_ARB, 0, INSTR(wm.MODEL_NAME_ARB, '-')-1), ww.current_balance
from
contract_details cd, contract_master cm , wh_model_master wm , wh_color_mast wc , wh_item_master im,COMP_BRANCH CB, wh_item_warehouses ww
where

cd.MODEL_NO =im.MODEL_NO
and im.item_code=ww.item_code
and cd.COLOR_CODE =im.COLOR_CODE
and cd.COLOR_CODE =wc.COLOR_CODE
and im.WOOD_CODE =im.WOOD_CODE
and cd.CONT_NO =cm.CONT_NO
and cd.MODEL_NO =wm.MODEL_NO
and cm.BRANCH_CODE=cb.BRANCH_CODE
and cd.MODEL_NO <>'BDB0026'
and substr(wm.MODEL_NO,-4) =:m
and cd.ITEM_PIECES>NVL(cd.ITEM_DELV_PIECES,0)
and nvl(cm.CONT_FINAL_AMT,0)>nvl(cm.CONT_PAID_AMT,0)
and ww.wh_code = 'WH50'
and ww.wh_code=NVL(:wh_CODE, ww.WH_CODE)
and cm.CONT_STATUS not in('DW','DL','CN','SP')
and cm.branch_code not in ('11','13','15','16','17','18','20','21','22','23','24')
group by im.ITEM_CODE,wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, ww.current_balance
ORDER BY wc.COLOR_NAME_ENG

select

im.ITEM_CODE, wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, sum(cd.ITEM_PIECES), SUBSTR(wm.MODEL_NAME_ARB, 0, INSTR(wm.MODEL_NAME_ARB, '-')-1), ww.current_balance
from
contract_details cd, contract_master cm , wh_model_master wm , wh_color_mast wc , wh_item_master im,COMP_BRANCH CB, wh_item_warehouses ww
where

cd.MODEL_NO =im.MODEL_NO
and im.item_code=ww.item_code
and cd.COLOR_CODE =im.COLOR_CODE
and cd.COLOR_CODE =wc.COLOR_CODE
and im.WOOD_CODE =im.WOOD_CODE
and cd.CONT_NO =cm.CONT_NO
and cd.MODEL_NO =wm.MODEL_NO
and cm.BRANCH_CODE=cb.BRANCH_CODE
and cd.MODEL_NO <>'BDB0026'
and substr(wm.MODEL_NO,-4) =:m
and cd.ITEM_PIECES>NVL(cd.ITEM_DELV_PIECES,0)
and nvl(cm.CONT_FINAL_AMT,0)<=nvl(cm.CONT_PAID_AMT,0)
and ww.wh_code = 'WH50'
and ww.wh_code=NVL(:wh_CODE, ww.WH_CODE)
and cm.CONT_STATUS not in('DW','DL','CN','SP')
and cm.branch_code not in ('11','13','15','16','17','18','20','21','22','23','24')
group by im.ITEM_CODE,wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, ww.current_balance
ORDER BY wc.COLOR_NAME_ENG

Unanswered 241 1 / Create an account to join the discussion.
Daniel Norwood
Follow / 15 Jun 2006 at 7:36pm / Oracle
Latest post by on 18 Nov 2015 at 10:00am

ORA-12638: Credential retrieval failed

Expand content
I encountered this error this morning and found the following info helpful (original post found here: http://www.easywebtech.com/oracle_ORA-12638.html): ORA-12 638: Credential retrieval failed If you get...

I encountered this error this morning and found the following info helpful (original post found here: http://www.easywebtech.com/oracle_ORA-12638.html):

ORA-12638: Credential retrieval failed

If you get this error first you need to check the SQLNET.ORA file. This file is located in [Oracle_Home]/NETWORK/ADMIN/SQLNET.ORA

if you see SQLNET.AUTHENTICATION_SERVICES= (NTS)

this needs to change to SQLNET.AUTHENTICATION_SERVICES= (NONE)

after that try to login to the database

4120 3 / Create an account to join the discussion.
JULIAN_COOK
Follow / 17 Nov 2015 at 7:36pm / Oracle
Latest post by on 17 Nov 2015 at 8:05pm

Toad for Mac stuck on "Initializing connections and drivers"...

Expand content
Hi guys, My company has an Enterprise license for Toad and I am running Toad 2.3 on Yosemite (Build 201510210824). Toad worked fine until I rebooted my Mac and now it's perpetually stuck on "Initializing...

Hi guys,

My company has an Enterprise license for Toad and I am running Toad 2.3 on Yosemite (Build 201510210824).

Toad worked fine until I rebooted my Mac and now it's perpetually stuck on "Initializing connections and drivers".

A check of "Force Quit" has Toad "not responding". Anyone have an idea how to fix this? I have tried uninstalling on my Mac and re-installing but apparently there are some residual files since it tries to keep making the same connections, perhaps a complete and total uninstall will fix it.

Many thanks for any pointers in the right direction

Julian

Answered 267 1 / Create an account to join the discussion.
arice2
Follow / 10 Nov 2015 at 10:15pm / Oracle
Latest post by on 11 Nov 2015 at 2:39pm

Need help with SQL Query

Expand content
Hello All, I am new to SQL database queries and am looking for help on how to execute this one. I think I need to use a subquery, not really sure, so I will try to break it down in steps. What I would...

Hello All,

I am new to SQL database queries and am looking for help on how to execute this one.

I think I need to use a subquery, not really sure, so I will try to break it down in steps.  What I would like to do (in one query) is...

Step 1: return all the rows in the table where ERROR_CODE=3

Step 2: take all the SERIAL_NUMBERs from Step 1 and query the table again for all rows containing those SERIAL_NUMBERs

Step 3: group the results of Step 2 by SERIAL_NUMBER

Step 4: order the rows within those groups by TIME_STAMP in descending order

Step 5: order those groups by the maximum TIME_STAMP value in each group in descending order 

Thanks in advance,

Aaron

296 3 / Create an account to join the discussion.
ameerkhan.R
Follow / 9 Nov 2015 at 12:52pm / Oracle
Latest post by on 9 Nov 2015 at 1:05pm

split a column into two data column

Expand content
I'm looking to take a query result like, i have a column in table (amount) but i would like to split the column like greater than 1000 should be in A column & less than 1000 should be in B column...

I'm looking to take a query result like, i have a column in table (amount) but  i would like to split the column like greater than 1000 should be in A column & less than 1000 should be in B column.

is this posible,

Unanswered 379 3 / Create an account to join the discussion.
user5431
Follow / 8 Nov 2013 at 3:22am / Oracle
Latest post by on 4 Nov 2015 at 11:00am

Output column contains questions marks

Expand content
Hi, when I query on tables in my database for some column in toad output column there is coming questions mark e.g., "???D" . When same query is performed on SQL plus editor it is giving...

Hi,

when I query on tables in my database for some column in toad output column there is coming questions mark e.g., "???D" .

When same query is performed on SQL plus editor it is giving correct data.

Can any one please help to resolve this issue that why I am getting those questions mark in output column?

 

Thanks in Advance.

Unanswered 2187 3 / Create an account to join the discussion.
g.pandolfino
Follow / 14 Oct 2015 at 12:35pm / Oracle
Latest post by on 3 Nov 2015 at 1:41pm

Remove NULL ROWS using Import Data

Expand content
Hi, I tried to import a Excel file into a Table using the "Import Table Data" component of Toad for Oracle. During the setting i don't see a way to remove the null rows. The only thing...

Hi,

I tried to import a Excel file into a Table using the "Import Table Data" component of Toad for Oracle.

During the setting i don't see a way to remove the null rows.

The only thing that i can use to restrict the input is "Last row".
I can't use "Last "Row" because the Import step is performed for file with various number of rows.

Is there a way to remove this null rows ?

355 1 / Create an account to join the discussion.
ChrisJohnson
Follow / 30 Oct 2015 at 8:06pm / Oracle

Developing a new free e-magazine as a medium for sharing oracle sql...

Expand content
I am starting a new free e-magazine with the goal of sharing my code and tips and providing a medium for others to sharing. I'd like invite everyone to check it out. I hope it is helpful to everyone...

I am starting a new free e-magazine with the goal of sharing my code and tips and providing a medium for others to sharing.  I'd like invite everyone to check it out.  I hope it is helpful to everyone.  Also, anyone that is interested is welcome to contribute.

www.codeitmagazine.com

chris@codeitmagazine.com

213 0 / Create an account to join the discussion.
g.pandolfino
Follow / 14 Oct 2015 at 11:36am / Oracle
Latest post by on 21 Oct 2015 at 10:08am

Use Variable in Automation Designer -> Execute Script

Expand content
Hi, I tried in every way to pass a variable to a simple sql script but it doesn't work. i have tried to use #, % and other but the only way that don't see error is : after the name of variabile...

Hi,
I tried in every way to pass a variable to a simple sql script but it doesn't work.

i have tried to use #, % and other but the only way that don't see error is : after the name of variabile.

My script is:

Update table set field = :my_var where field is null;

Any suggestion?

325 3 / Create an account to join the discussion.