Choose a layout and drag widgets onto your Overview Page to customize it. Widgets placed on the page below can be configured by selecting the symbol.
Ask Tom is an online repository of over 12,800 questions and answers that have been answered by Tom Kyte. This content covers many topics related to building applications on top of Oracle Database.
Ask Tom is one of the leading sites online to learn about Oracle Database.
With Tom taking a personal leave, two deeply experienced Oracle Database experts, Connor McDonald and Chris Saxon, are stepping in take over on the Ask Tom Answers Team.
While no one else can ever be Tom Kyte, we are certain you will find yourself learning from these experts, as you did from Tom.
We also hope you will enjoy the freshened-up Ask Tom website.
This Oracle Developer Community page is not a replacement for the Ask Tom website.
Instead, use this page to offer (and vote on) ideas for any changes you would like to see on the Ask Tom website, to make it as useful as possible to you. To see or add to these ideas, click on Content.
If you post a question about Oracle Database technologies in Ideas, it will be removed.
Tom has traveled the world several times over, sharing his expertise along the way with tens of thousands of Oracle Database developers and DBAs.
In that same period, he's answered thousands of questions on AskTom.oracle.com.
Tom has now decided to take a "time out," to work on some new books on Oracle technology and spend more time on Planet Earth instead of its atmosphere.
Read Tom's Timeout and Thanks here.
Good afternoon, One of our client executed the code below to get rid off a slowness at the database level alter session set "_column_tracking_level"=0; What's the purpose of such command? Thank you Simon
Hi all, I would like to do the following using conditional compiling when the DB release_name is greater than 12.2.0 then a certain operation has to be performed, else not. I use the below code, it always goes to the ELSE part of the IF condition. Also, I will not be able to use dbms_db_version.ver_le_12_2 , the reason is, I am looking for release_name(from fnd_product_groups table) which has to be equal to or greater than 12.2.0 and not the database version(from v$version). Any pointers or samp …
i have this error when run from6i in oracle 12cr2 ORA-3137: TTC PROTOCOL INTERNAL ERROR:  Application Errors After 12c Upgrade
-----------Version Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production PL/SQL Release 18.104.22.168.0 - Production "CORE 22.214.171.124.0 Production" TNS for Linux: Version 126.96.36.199.0 - Production NLSRTL Version 188.8.131.52.0 - Production ----------------------------- <code> DECLARE TYPE ty_sanction_src IS TABLE OF date INDEX BY VARCHAR2(32767); type ty_snctn_src_dt IS TABLE OF ty_sanction_src INDEX BY pls_integer ; t_sctn_src_dt ty_snctn_src_ …
Hi Tom, I'm trying to restore a datafile from backup and i get error i don't understand. These are the output of my commands: RMAN> list backup of datafile 1; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 3536 Incr 1 521.13M DISK 10:00:18 25-APR-10 BP Key: 3536 Status: AVAILABLE Compressed: YES Tag: ORL_WEEKLY_DIFF …
Oracle Database 12c: Admin, Install and Upgrade Accelerated
Learn how to install and manage Oracle Database and get 7 days of content in just 5 days.
Oracle Database 12c: New Features for AdministratorsLearn the new enhanced features and options of Oracle Database 12c.
Big Data Learning Subscription
Get 24/7 access to a comprehensive set of training videos and product demos delivered by Oracle experts.