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

Lina Sengupta
Follow / 21 Apr 2016 at 9:02pm / Oracle

Mapping of US States with the two character State ID

Expand content
Is there any pre existing table for Mapping of US States with the two character State ID? I am parsing user entry for US states and would like to get the two character State ID. Are there any recommendations...

Is there any pre existing table for Mapping of US States with the two character State ID?

I am parsing user entry for US states and would like to get the two character State ID.

Are there any recommendations?

71 0 / Create an account to join the discussion.
Lina Sengupta
Follow / 19 Apr 2016 at 5:17pm / Oracle

TOAD for Oracle 12.6.0.53 -Package Body does not exist or you do not...

Expand content
I am a new user of Toad. I created a package then was able to compile and run it. When it came to trying some changes, these changes were not saved successfully. Next I deleted the package and tried...

I am a new user of Toad.

I created a package then was able to compile and run it.

When it came to trying some changes, these changes were not saved successfully.

Next I deleted the package and tried to create a new package and I got the Warning"

"Package Body does not exist or you do not have the necessary privilege to access it"

If this is a privilege issue?

Any help will be appreciated. Let me know if I need to give more information.

58 0 / Create an account to join the discussion.
tpetchel
Follow / 8 Apr 2016 at 7:21pm / Oracle
Latest post by on 11 Apr 2016 at 1:21pm

Create Team Project

Expand content
I have not been able to set up a team coding project using a third party VCS. I have tried with SVN TortoiseSVN and Git. I get to the same place. After successfully configuring everything up to clicking...

I have not been able to set up a team coding project using a third party VCS. I have tried with SVN TortoiseSVN and Git. I get to the same place. After successfully configuring everything up to clicking the OK button on the Create Team Project window I get the same log message: hh:mm:ss Output: VCS Provider is not set. I am running  Toad 12.7.1.11 Xpert Edition, Toad Development Suite for Oracle. My Git for Windows is v2.8.1. Any help would be much appreciated.

thanks,

Timothy Petchel

tpetchel@caci.com

142 2 / Create an account to join the discussion.
w.delange
Follow / 5 Apr 2016 at 12:22pm / Oracle
Latest post by on 5 Apr 2016 at 3:51pm

Change Oracle password using a website.

Expand content
Currently we have an application in which under certain conditions you are not able to change the Oracle password due to limitations created by the developer of the application. We are discussing with...

Currently we have an application in which under certain conditions you are not able to change the Oracle password due to limitations created by the developer of the application.

We are discussing with the developer to change that, but that will take some time, because we are on an older version and don't want to upgrade on this moment.

My question is now, has someone ever created a website/webservice, so that users can change their password?

Unanswered 165 4 / Create an account to join the discussion.
PaulZip
Follow / 29 Mar 2016 at 10:33am / Oracle
Latest post by on 29 Mar 2016 at 12:28pm

Script Output Text Colour

Expand content
I use a dark background as my default in TOAD, but this seems to cause problems with Script Output / Output tab. Unless I am missing something, there seems to be no way to change the text colour to anything...

I use a dark background as my default in TOAD, but this seems to cause problems with Script Output / Output tab. Unless I am missing something, there seems to be no way to change the text colour to anything but black, which makes the output unreadable.  See below (see image).  Can you add an option somewhere please?

80 2 / Create an account to join the discussion.
mopar969
Follow / 24 Mar 2016 at 2:02pm / Oracle
Latest post by on 26 Mar 2016 at 2:56pm

Import Multiple Data Tables t Toad Oracle at Once

Expand content
How can I import multiple data tables from an access database at once in toad oracle. Right now I have a query that I run that drops yesterdays tables and then I create new tables. Then I go into import...

How can I import multiple data tables from an access database at once in toad oracle.

Right now I have a query that I run that drops yesterdays tables and then I create new tables. Then I go into import, table data and I have to select each table from my database manually. This is time consuming, is there anyway to import all tables at once? Thanks

81 1 / Create an account to join the discussion.
Guritijo
Follow / 9 Mar 2016 at 9:36am / Oracle
Latest post by on 18 Mar 2016 at 8:45am

Access violations

Expand content
Hi, Trying to make the big step from 9.7 to 12. I installed the trial and wanted to test it in a real situation. But without knowing what I'm doing wrong I get frequently an access violation. For...

Hi,

Trying to make the big step from 9.7 to 12. I installed the trial and wanted to test it in a real situation. But without knowing what I'm doing wrong I get frequently an access violation. For the old version I have a oracle 32bits client installed. But I've also a 64bits client installed. Do I have a kind of conflict? Is it better to install 32bits of Toad? Is there a checklist with possible causes and/or solutions.

Best Regards,

Guus Goossens.

206 4 / Create an account to join the discussion.
Jian.qin
Follow / 16 Mar 2016 at 5:04pm / Oracle

Is it possible to create subfolder under View to differentiate from...

Expand content
As subject, I'd like to know if it's possible to build subfolder under View to differentiate from current views? I don't see a simple way to do that in SQL Developer, wonder if Toad for Oracle...

As subject, I'd like to know if it's possible to build subfolder under View to differentiate from current views?   I don't see a simple way to do that in SQL Developer, wonder if Toad for Oracle can offer the feature.  Thanks very much!

99 0 / Create an account to join the discussion.
student2016
Follow / 1 Feb 2016 at 1:26pm / Oracle
Latest post by on 24 Feb 2016 at 7:27am

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 257 1 / Create an account to join the discussion.
gr_tb
Follow / 16 Feb 2016 at 9:48am / Oracle

Long live Oracle Forms/EBS + Chrome - A new Chrome Plugin for Oracle...

Expand content
Hi, thought that may be useful for some... Oracle Forms and Oracle EBS on Chrome is still alive - with SSO, Cookie and JS, and no NPAPI needed > Chrome Extension for Oracle Forms and Oracle EBS...

Hi, thought that may be useful for some...

Oracle Forms and Oracle EBS on Chrome is still alive - with SSO, Cookie and JS, and no NPAPI needed

> Chrome Extension for Oracle Forms and Oracle EBS - NPAPI-less

chrome.google.com/.../nmjefghbgfcpoobigfbalocpncklkjhk

That will shake things up :)

223 0 / Create an account to join the 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.?

186 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

149 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!!!

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

191 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

245 0 / Create an account to join the discussion.