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!
My task is to excute a custom sql and export the result to excel . I have toad for oracleI have followed:
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.?
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,
Toad - 184.108.40.206 (Licensed version)
Oracle Server - 220.127.116.11.0
Oracle Client - 18.104.22.168.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.
Assume we have a service with preferred node as 1 and available node as 2.
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.
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.
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?
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
If you would like to subscribe, you can go to
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.
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
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_balancefromcontract_details cd, contract_master cm , wh_model_master wm , wh_color_mast wc , wh_item_master im,COMP_BRANCH CB, wh_item_warehouses wwwhere
cd.MODEL_NO =im.MODEL_NOand im.item_code=ww.item_codeand cd.COLOR_CODE =im.COLOR_CODEand cd.COLOR_CODE =wc.COLOR_CODEand im.WOOD_CODE =im.WOOD_CODEand cd.CONT_NO =cm.CONT_NOand cd.MODEL_NO =wm.MODEL_NOand cm.BRANCH_CODE=cb.BRANCH_CODEand cd.MODEL_NO <>'BDB0026'and substr(wm.MODEL_NO,-4) =:mand 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_balanceORDER BY wc.COLOR_NAME_ENG
cd.MODEL_NO =im.MODEL_NOand im.item_code=ww.item_codeand cd.COLOR_CODE =im.COLOR_CODEand cd.COLOR_CODE =wc.COLOR_CODEand im.WOOD_CODE =im.WOOD_CODEand cd.CONT_NO =cm.CONT_NOand cd.MODEL_NO =wm.MODEL_NOand cm.BRANCH_CODE=cb.BRANCH_CODEand cd.MODEL_NO <>'BDB0026'and substr(wm.MODEL_NO,-4) =:mand 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_balanceORDER BY wc.COLOR_NAME_ENG
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
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
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
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,
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.
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 ?
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.
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;