Skip to Main Content

Questions

QuestionUpdatedAsked

Hi Tom !As there is put a restriction on GTTs:Distributed transactions are not supported for temporary tablesdoes that mean that inline views in a query, i.e. using WITH clause,but those with MATERIALIZED hint will not work properly?If there is neither MATERIA...
4 hours ago3.5 years ago

Hi,I have to calculate accumulated value for a column, but I have to filter some rows (and it depends on that accumulated value).For example:<code>CREATE TABLE dummy_table ( var_id NUMBER(5) PRIMARY KEY, prc number(5), qty number(5), ...
4 hours ago5.9 years ago

TomOne of our main dissapointment is that , we cannot use analytical functions in sql from within a procedure, as they are not compatible with the pl/sql engine.Further, when I try to update my knowledge with the analytical functions, I get the doubt as to th...
4 hours ago20.8 years ago

Hi Tom,I have a task to migrate data from 4 hierarchical tables into few hundred flattened tables. I have developed some options but am looking for possible improvements or more effective ways.So I have 4 tables let's say:create table t1(id number, name varcha...
4 hours ago6.7 years ago

Test case is connect to sqlplus in silent mode in korn shell and run a bunch of sql queries in one single sqlplus session..and where the out would be seen..tried the following in test.ksh#!/usr/bin/kshCURR_DIR=`pwd`echo "current directory is:" $CURR_DIR. $CURR...
4 hours ago4 days ago

Hi Tom, I want to declare multiple cursors based on the values passed through a procedure ie, only where conditions of thecursors will change. The body of the procedure issame for all the cursors. Pls. suggegst a solution.Thanking you,regards,Pratty. ...
4 hours ago21.6 years ago

Database Version 19.16.0.0.0I have a JSON document with "address", "address_name", and "state" keys among others. I'm searching for a user input in either "address" OR "address_name" in the JSON document. I also have an AND for the "state" key. Depending on th...
29 hours ago38 hours ago

Hi team,i take Level-0 backup on Sunday, then from monday to saturday i take differential incremental backups.i want to restore backup on another machine, i have control file backup of Sunday. i can restore level-0 backup easily using control file of Sunday be...
30 hours ago2 days ago

We have around 50 custom tables, which are using for the traces in db objects. Each table contains more than billion records.most of the tables don't have indexes. I want to delete data >sysdare-365 days. Which is not working it is taking very very long time. ...
30 hours ago4 days ago

<code>declare v_list varchar2(4000);begin begin v_list := :P4_STATES; exception when no_data_found then v_list :='0'; end; for y in (select * from(table(DBMS_UTILITY.comma_to_table(:P4_STATES)))) loop INSERT INTO COVIDAPI(STATES_NO) value...
30 hours ago4 days ago

Has anyone setup CMU to work for all the PDBs within a CDB ?I have it working for a single PDB but when I created a new wallet based off the GUID it doesn't work I get an ora-1017 but it works for the 1st PDB I setup.I'm running Oracle 19.14 on Windows 2019. I...
30 hours ago5 days ago

Hi team,Is it possible to explain the purpose of '%CFG' broker services and who and how is using it ?Regards Dejan...
30 hours ago4 weeks ago

Hello, Ask Tom Team.I have a two-nodes RAC database running 18.4.0 and I'm running a load test (lots of inserts). Basically, two tables are being hit. These tables are using identity column and have a relationship (fk). I'm checking OEM 13c and there is a high...
2 days ago3.3 years ago

Hi,I tried to learn PIVOT concept to Pivot the Rows to Columns, but i could not understand how it works internally and how it identify which rows should get turn into Columns. So would you Explain How it Makes Rows as Columns....
2 days ago5.3 years ago

Hi,There is a SELECT statement which returns columns (around no of coloums are 25).I suppose to apply LISTAGG function on 16 columns (with delimiter as ',') whenever those columns has distinct values during group by one another column.For example, I have below...
2 days ago6.2 years ago

hi tomi have a databse with 125 tables. i can find the total number of tables of the database by the sql select * from tab; now i would like to know the number of rows in each table of my database with out executing select count(*) from...; each time.please...
2 days ago20.8 years ago

Hi TomCan you explain briefly the difference between soft and hard parse?cheers ...
2 days ago20.6 years ago

My application has tables that are 30-40 GB (130M to 480M records) and indexes (indices) that are 10-25 GB.There is potential for significant growth.Oracle documentation recommends considering partitions when tables grow to 2GB, so I am trying to determine whe...
2 days ago5 years ago

I tried to duplicate source database to create physical standby database using the below command duplicate target database for standby FROM ACTIVE DATABASE USING COMPRESSED BACKUPSETSPFILEnofilenamecheck;I have a very big database size with multiple big data ...
5 days ago5 days ago

Good Morning Tom.I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up in Rollback segment i...
5 days ago19.8 years ago