AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 13 min 12 sec ago
Constraining JSON Data
Hello AskTom-Team,
is there a possibility to contrain and check JSON data?
For example:
<code>insert into test(questionnaire_id, var_val, year)
'{
"f1": "2571",
"f11": "38124",
"f31": "332.64",
"f4...
Move Basic LOB to SecureFile LOB
Hello,
I have table with 30M rows which has BLOB column. BLOB column has about 700GB of data.
I have tried dbms_redefinition package and DBMS_REDEFINITION.start_redef_table failed after 3 days due to ORA-1555. I have increased undo_retention to 600...
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1384], [1270], [2885], [], [], [], [], [], [], []
-------------------------------------
Oracle Database 11.2.0.1.0
Archive Log Mode
RMAN Backup is performed daily, with backup control file and backup archive log file 1 time to disk.
------------------------------------
Hi Ask Tom t...
SQL to return 12 months of this year
select (to_char(add_months (sysdate,level-10),'Month')) as Month
,to_char(TRUNC(add_months(sysdate,level-10),'month'),'mm/dd/yyyy') as firstdayofthemonth
,to_char(last_day(add_months(sysdate,level-10)),'mm/dd/yyyy') as lastdayofmonth
from dual ...
Remove a hint with DBMS_ADVANCED_REWRITE and DBMS_SQL_TRANSLATOR failed
Hello Masters,
I am testing the two packages DBMS_ADVANCED_REWRITE and DBMS_SQL_TRANSLATOR and they work fine : for exemple I can remove an ORDER BY from a SELECT.
But, there is always an exception, I have problems with Hints : I want to remove...
XML Aggregation
Consider:
<code>with data as (select 'MH' initials, to_date('01092019','ddmmyyyy') cal_date, 23 quantity from dual
union all
select 'MH' initials, to_date('02092019','ddmmyyyy') cal_date, 18 quantity fro...
Oracle query running slow
Hi Team,
we have a SQL query which is a source query for the ETL load job, this take around 3 hours to run, could you please help us how we can make it run faster.
The row count of the tables involved are as follows.
D_PERSON 4618595
...
alert logs are not generating
I have check one production 12 DB environment. On this environment, there is not alert_<SID>.log files. Is the alert log file should there or missing?? if missing can we re-generate ??, So, it is difficult to monitoring the DC-Dr sync alerts and othe...
Stat gather impact on production environment
On OLTP production environment, during huge transaction period, what is an impact if we run the stat gather of used schema for transaction???, It will missed any indexes, and other operation issues???
Best practice for "archiving" legacy tables and their data
Hi,
I recently removed the last piece of front-end functionality that relied on a table, and am certain that that table and its data is no longer needed for the application to function. We'll have more similar tables in this situation in the near ...