AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 2 hours 48 min ago

Local index for ONE foreign key field takes 50% of table size

Mon, 04/25/2016 - 00:00
Hi, I have following partitioned table with 7 fields: Rdate date, CalcID NUMBER(5,0) not null, ContractID NUMBER(9,0) not null, AqId NUMBER(1,0) not null, Balancetype varchar2(1 byte) not null, S1 number, S2 number and local non-uniq...

provide proper guidance for me with quick reply

Fri, 04/15/2016 - 00:00
i have drop my tablespace but not datafiles, so now i try to drop that datafiles also but it's through an error what is the reasion for that... if we have one tablespace ts1 in that ts1 we have 2 datafiles.. but i use to drop only tablespace d...

RMAN duplication fails.

Tue, 04/12/2016 - 00:00
Hi I am trying to duplicate database . When I do do that , at the end of the process , I am getting RMAN-06025 . why does it try to apply the non exisiting log imn the auxillary db? Thanks RMAN> run { 2> 3> allocate auxili...

Views on each table - your opinion

Tue, 04/12/2016 - 00:00
Hello AskTom team, Thanks for taking my question. We are a product company. I have a request from my business that all the base tables should be converted to views. I told them NO because there are some "heavy" SQL's that might have performance...


Thu, 04/07/2016 - 00:00
Hi Team Have a scenario to select a particular set of rows from a table for further processing. We need to ensure that multi users do not work on the same set of rows. We use SELECT FOR UPDATE SKIP LOCKED in order to achieve this. EG:a simp...