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

ckendra
Follow / 12 Aug 2014 at 3:32pm / Oracle
Latest post by on 29 Aug 2014 at 1:21am

Session/Table Lock History

Expand content
Is there a way to see the history of session blocks caused by table locking? I can view current blocking sessions through the session browser, but would like to see a history if its possible. Thanks!

Is there a way to see the history of session blocks caused by table locking? I can view current blocking sessions through the session browser, but would like to see a history if its possible. Thanks!

Unanswered 90 1 / Create an account to join the discussion.
sdcraig
Follow / 27 Aug 2014 at 11:18am / Oracle
Latest post by on 28 Aug 2014 at 4:43pm

Oracle 11g Database Express Fuzzy Searching

Expand content
Hello: Very new to this forum. I've recently installed the above referenced software, but no clue how to use it. I use SQL daily, and would like to utilize Oracle functionality (specifically the...

Hello:

Very new to this forum.  I've recently installed the above referenced software, but no clue how to use it.  I use SQL daily, and would like to utilize Oracle functionality (specifically the TEXT features and FUZZY searching).  I would then use TOAD for Oracle and SQL syntax to query the data.

Is there a link or post somewhere that shows me how to:   a) load data;  b) create necessary indexes;  c) Link TOAD to db;  d) Begin querying.

Thank you.

 

Unanswered 44 2 / Create an account to join the discussion.
dorianpc
Follow / 6 May 2014 at 7:57pm / Oracle
Latest post by on 9 Aug 2014 at 7:31pm

Why is Rename Identifier greyed out?

Expand content
Guys, Can someone explain to me why "Rename Identifier" is greyed out in Toad, when I am trying to refactor my code? I want to do just one rename for my whole code.

Guys,

Can someone explain to me why "Rename Identifier" is greyed out in Toad, when I am trying to refactor my code?

I want to do just one rename for my whole code.

Unanswered 182 1 / Create an account to join the discussion.
rtheron
Follow / 11 Jul 2014 at 6:09pm / Oracle
Latest post by on 9 Aug 2014 at 7:28pm

Default tnsnames.ora file location config

Expand content
I prefer to use the oracle net services connection type, but I have to specify the location of the tnsnames.ora on my MAC each time I add a new database connection, is there a way to let toad know automatically...

I prefer to use the oracle net services connection type, but I have to specify the location of the tnsnames.ora on my MAC each time I add a new database connection, is there a way to let toad know automatically where this file is located?


Mine is located in ./Applications/oracle/product/instaclient_64/11.2.0.4.0/network/admin

and my .bash_profile configures relevant environment variables as:

export ORACLE_HOME=$HOME/Applications/oracle/product/instantclient_64/11.2.0.4.0/
export PATH=/usr/local/bin/athena:$ORACLE_HOME/bin:$PATH
export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib

246 5 / Create an account to join the discussion.
Sush
Follow / 7 Aug 2014 at 8:25pm / Oracle

Running reports

Expand content
Hello, I use Oracle 9i Release (9.2.0.1.0) for Windows and TOAD for Oracle 8.6.0.38. I am aware of being able to run reports via database. Can anyone please tell me the steps to do that? Thanks in...

Hello,

I use

Oracle 9i Release (9.2.0.1.0) for Windows  and TOAD for Oracle 8.6.0.38. I am aware of being able to run reports via database. Can anyone please tell me the steps to do that?

Thanks in advance.

70 0 / Create an account to join the discussion.
Jumboshrimps
Follow / 6 Aug 2014 at 6:18pm / Oracle
Latest post by on 6 Aug 2014 at 6:46pm

Copy ONE table in Toad Xpert 12.5

Expand content
I need to copy several ORACLE tables on schemas on different servers. I open Schema Browser, right click on the table I want to copy and select Copy Data to Another Schema. I select other Schema I'm...

I need to copy several ORACLE tables on schemas on different servers.

I open Schema Browser, right click on the table I want to copy and select Copy Data to Another Schema.

I select other Schema I'm connected to and press execute.

I get an error message
"Error Message:
ORA-00942: table or view does not exist"

NO KIDDING!!!! THAT'S WHY I'M COPYING THE TABLE!!!!!

Second option is to right click on the table in the Schema Browser

again, and select "Create in Another Schema".

I select other schema, select execute and get an error message:

"ORA-00942: table or view does not exist"

REALLY???????????????? OF COURSE IS DOESN'T EXIST, THAT'S WHY I'M COPYING IT!!!!!!!!!

I just to select a table from one schema drag-and-drop it to the other schema.

Is that possible?

70 1 / Create an account to join the discussion.
ashish_jha
Follow / 19 Mar 2014 at 10:02am / Oracle
Latest post by on 26 Jul 2014 at 5:12pm

RAC Testing

Expand content
In our production we have setup RAC Can anyone Please share steps to test RAC settings.

In our production we have setup RAC

Can anyone Please share steps to test RAC settings.

195 1 / Create an account to join the discussion.
nitinpbhore
Follow / 11 Mar 2014 at 9:57am / Oracle
Latest post by on 26 Jul 2014 at 1:07pm

DB link between Oracle 8i and 11g

Expand content
Hi My requirement is to create DB link between Oracle 8i and 11g. as mentioned in interopertability matric connectivity between 8i to 11g is not supported, workaround is to create one intermidiate...

Hi

My requirement is to create DB link between Oracle 8i and 11g.

as mentioned in interopertability matric connectivity between 8i to 11g is not supported, workaround is to create one intermidiate database of 10g .

is there any other workaround like can ODBC or JDBC (JDBC thin driver) connectivity is possible between 8i and 11g.

Regards,

Nitin

435 1 / Create an account to join the discussion.
AmyHill
Follow / 31 Mar 2014 at 8:16pm / Oracle
Latest post by on 26 Jul 2014 at 12:59pm

Retain leading zeros for declared variables using cursor and fetch...

Expand content
Greetings, I have an sql stmt I need to modify to retain leading zeros and I'm not sure how to modify it. Here is the code: undef mmy_schema; undef BeginDate; undef EndDate; DECLARE -- declare...

Greetings,

I have an sql stmt I need to modify to retain leading zeros and I'm not sure how to modify it. Here is the code:

undef mmy_schema;

undef BeginDate;

undef EndDate;

DECLARE -- declare variables and cursors

startDt  VARCHAR2(10) := '&&BeginDate';

stopDt VARCHAR2(10) := '&&EndDate';

mmy_schema varchar2(200) := '&&mmy_schema'

policyNo   &&mmy_schema..TableName.fieldname%TYPE;  

---------THIS poliycNo IS THE VARIABLE I WANT TO RETAIN LEADING ZEROS....HOW??? IT IS A VARCHAR2(10BYTE) data type in the schema.

The cursor is defined after this, with FETCH and loop stmts.

 

183 1 / Create an account to join the discussion.
Orangeblood26
Follow / 13 Jun 2014 at 5:43pm / Oracle
Latest post by on 26 Jul 2014 at 12:50pm

Oracle RDB Driver connection and using variables

Expand content
I'm currently working out of Toad Data Point 3.2 and have made a connection to a Oracle RDB Driver through ODBC connection within the Toad product. I am trying to "declare" a variable (see...

I'm currently working out of Toad Data Point 3.2 and have made a connection to a Oracle RDB Driver through ODBC connection within the Toad product. I am trying to "declare" a variable (see example below) but keep receiving an error. My issue is I'm trying to write a query to pull a set of data by limiting on a "where" clause, the data type of the field is a date field.

 

Example of my quick test code that is receiving an error (remember I'm connected to a ODBC connection to a Oracle RDB Driver):

declare @dt_timeframe date

the above gives me a syntax error, any guidance helps. Thanks.

Unanswered 132 1 / Create an account to join the discussion.
Dharmendra Verma
Follow / 24 Jun 2014 at 5:28pm / Oracle
Latest post by on 24 Jun 2014 at 5:31pm

Invitation to connect on LinkedIn

Expand content
From Dharmendra Verma Software Engg. at Infokall Pune Area, India I'd like to add you to my professional network on LinkedIn. ...
 
LinkedIn
 
 
 
 
From Dharmendra Verma
 
Software Engg. at Infokall
Pune Area, India
 
 
 
 
 
 
 

I'd like to add you to my professional network on LinkedIn.

- Dharmendra

 
 
 
 
 
 
 
You are receiving Invitation to Connect emails. Unsubscribe
© 2014, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA
 
111 1 / Create an account to join the discussion.
balavenkat
Follow / 17 Jun 2014 at 6:43am / Oracle
Latest post by on 18 Jun 2014 at 10:41am

TOAD - Introduction

Expand content
Hello All Am completely new to TOAD..!! so can anyone please explain in general how and what for TOAD is used for ? Please explain from step 1 of getting introduction to TOAD, or do suggest any materials...

Hello All

          Am completely new to TOAD..!! so can anyone please explain in general how and what for TOAD is used for ? Please explain from step 1 of getting introduction to TOAD, 

or do suggest any materials to know about TOAD.

P.S :    And am interested in learning about TOAD, i work with pl/sql and sql.

Regards

BalaV

235 3 / Create an account to join the discussion.
x2suggs
Follow / 21 May 2014 at 10:14am / Oracle
Latest post by on 21 May 2014 at 11:25am

Stored procedures and triggers

Expand content
Hello all. Can someone tell me where I can find information and/or documentation on using stored procedures and triggers that can be activated from a client-side application. I could add a record from...
Hello all. Can someone tell me where I can find information and/or documentation on using stored procedures and triggers that can be activated from a client-side application. I could add a record from the client-side or something of that nature but I don't really have any experience writing procedures or triggers.
Thanks in advance... Glenn
Answered 200 1 / Create an account to join the discussion.
Milton.Villegas
Follow / 8 Apr 2014 at 9:25pm / Oracle
Latest post by on 9 Apr 2014 at 3:03pm

Toad 12 and Toad db2. we found that both oracle and db2 wont work...

Expand content
Could help me understand what parts of oracle and db2 are required for the toad to work, we will try to include that parts with the toad Customer visualized applications for the vdi error "oracle...

Could help me understand what parts of oracle and db2 are required for the toad to work, we will try to include that parts with the toad

Customer visualized applications for the vdi

error "oracle and db2 cannot be visualize"

do you have any idea if toad can be visualize?.

Cannot find any info on this and this is all have from customer, any ideas or suggestions?

Unanswered 167 1 / Create an account to join the discussion.
Maheshdba
Follow / 20 Mar 2014 at 8:19am / Oracle
Latest post by on 20 Mar 2014 at 12:50pm

All users DB login information

Expand content
Hi All, We are using Oracle 10g and we enabled the auditing, NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_sys_operations boolean TRUE audit_syslog_level...

Hi All,

We are using Oracle 10g and we enabled the auditing,

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB

But we are not getting all users login information in DBA_AUDIT_TRAIL and sys.aud$.

There are information for some users but not for all users. Is it mean that other user are not audited.

How do we find user list which are currently audited.

Thanks !

Unanswered 207 2 / Create an account to join the discussion.