Skip to Main Content

Questions

QuestionAsked

Hi,I came across an "No more data to read from socket" error while trying out a codesample from here: https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9533477800346658909 This is our non-working environment: SQLDeveloper 4.2.0.17.089 (Bui...
0122.4 years ago4.7 years ago

<i></i>Hi, Tom.I noticed strange behavior dbms_random.value using in sub-select.In LiveSQL example dbms_random.value is not unique for rows in sub-select.Oracle, under a certain meaningless condition (or 1!=0), transfers the ration column to the main selectBec...
0122.4 years ago3 days ago

Hello Tom,Greetings !!We are looking for tools which can help monitor database similar to Oracle OEM 13C along with Infrastructure issues. We face issue even related to infrastructure due to high volume of data.Please suggest if there are tools available which...
0122.4 years ago3 days ago

I‘m never sure on how to use the cache parameter to true when creating a new temporary lob using the dbms_lob.createtemporary function?There seems to be trade-off between the improved speed when caching and the possible impact of filling up the buffer cache wi...
0122.4 years ago3 days ago

I am converting Manufacturing ERP into Apex and daily approx. 20000 entries so user are very speedy and not using mouse I have facing a challenges in navigation1) How define hotkey/Short cut key for button so when using shortcut key functionality define on tha...
0122.4 years ago3 days ago

How could I filter the results in order for it to produce only certain alter statements. For example, I do not want to include changes in initrans and table storage in the result.This is part of the code:c:=dbms_metadata_diff.compare_alter(tipo,'object name' ...
0122.4 years ago3 days ago

Below pkg proc execution time is 2-4 hrs.Pls helpto identify areas of improvementexplplan for update stmt :"STATEMENT_ID","PLAN_ID","TIMESTAMP","REMARKS","OPERATION","OPTIONS","OBJECT_NODE","OBJECT_OWNER","OBJECT_NAME","OBJECT_ALIAS","OBJECT_INSTANCE","OBJECT_...
0122.4 years ago3 days ago

Amazon Web Services usurps ownership of the SYSDBA functions, which IMO seems to work pretty well. According to the DBA_ADVISOR_RECOMMENDATIONS view, there's still work to be done. Do you have any thoughts on what parameter tuning is still appropriate? Object ...
0122.4 years ago3 days ago

Hi,We have custom triggers on a few Oracle EBS tables to track & log any insert, update & delete. The trigger captures any changes made through the front end screens. However, if a user does an insert, update or delete to a table in the back end using SQL Plus...
0122.4 years ago5.5 years ago

Hi Team,I would like to understand the scenario, where we have:- TDE enabled at tablespace level.- RMAN encryption turned offWill the backup be still encrypted?As per oracle document - Doc ID 819167.1First paragraph in Solution section, it states:"RMAN does ...
0122.4 years ago1.9 years ago

Hello Tom!We have a situation where we are using Java to access data in an Oracle database. Some of the objects are broken out into three tables as follows:* Primary table (e.g. MY_OBJECT)* Secondary table (e.g. MY_OBJECT_2)* Custom table (e.g. MY_OBJECT_C)The...
0122.4 years ago11.4 years ago

We have below table...<code>boards(account_id number, b_key varchar2(36),status varchar2(2), ....)</code>.This table is range partitioned on account_id. There is composite primary key (account_id, b_key) on this table.When we are executing query on this table ...
0122.4 years ago2 months ago

Hi Mr Tom,I am posting a question first time on your site, hopefully will get an answer soon.I am trying to get hierarchy of a table using foreign key constraints. I want to pass a table name E.g. Customers and I want all children, grand children and so on of ...
0122.4 years ago14.8 years ago

How to store old values as well as new values in the oracle table ?.there is one database block in whichthe user enters data in many columns. we need to track only two columns ( for eg) to store old valueas well as new value. How to database trigger or how to ...
0122.4 years ago3 days ago

Hi Tom, i get this error: SQL Error: ORA-00933-00000 - "SQL command not properly ended" when i run this query:<code>update aset propertyaddress = nvl2(a.propertyaddress, b.propertyaddress,b.propertyaddress)from nashvillehousing ajoin nashvillehousing bon a.par...
0122.4 years ago3 days ago

question:- I want to calculate the total rows of two different table and then calculate the difference of two rows between these tables:---I have written two queriesselect (select count(*) from batchhr.tr_time_mar_intrfce_src ) cnt, (select count(*) from batch...
0122.4 years ago5.6 years ago

I have a DB on ExaCC Gen1 platform with a big LOB segment and when I try to compress it I ran into undo problems.Table size 2,68GLOB segment size 14TBUNDOTBS1 size 544GUNDOTBS2 size 128GSys@DBname1> show parameter undo_retentionNAME ...
0122.4 years ago2 weeks ago

What query can be used to find the duplicates using a group of columns among which one is a varchar type from a million of records. The varchar type column matching must be case insensitive and space insensitive.In the attached data all rows corresponds to the...
0122.4 years ago4 weeks ago

I have two questions both referring to the documentation in Oracle 19c SQL Language Reference PARALLEL hint "For a statement-level PARALLEL hint" section.https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Comments.html#GUID-D25225CE-2DCE-4D9F-...
0122.4 years ago2 weeks ago

1) I created Employee master FORM from emp table2) In employee form deptno is the select list and I put button for new department add. It will call dept page form which has property chained = false3) After adding new dept control goes back to employee form but...
0122.4 years ago2 weeks ago