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!
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!
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.
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.
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/18.104.22.168.0/network/admin
and my .bash_profile configures relevant environment variables as:
export ORACLE_HOME=$HOME/Applications/oracle/product/instantclient_64/22.214.171.124.0/export PATH=/usr/local/bin/athena:$ORACLE_HOME/bin:$PATHexport DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
Oracle 9i Release (126.96.36.199.0) for Windows and TOAD for Oracle 188.8.131.52. I am aware of being able to run reports via database. Can anyone please tell me the steps to do that?
Thanks in advance.
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?
In our production we have setup RAC
Can anyone Please share steps to test RAC settings.
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.
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:
DECLARE -- declare variables and cursors
startDt VARCHAR2(10) := '&&BeginDate';
stopDt VARCHAR2(10) := '&&EndDate';
mmy_schema varchar2(200) := '&&mmy_schema'
---------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.
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.
I'd like to add you to my professional network on LinkedIn.
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.
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?
We are using Oracle 10g and we enabled the auditing,
NAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_sys_operations boolean TRUEaudit_syslog_level stringaudit_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.