Questions

Hello Tom,I am trying to inline a function when using a MERGE statement and I am not sure if it is working as no error is thrown.Here is my code:<code>CREATE OR REPLACE PACKAGE my_pkgIS FUNCTION my_fnc ( p1 VARCHAR2 , p2 VARCHAR2) RETURN ...

HOW TO RESOLVE THE ERROR :- ora-01406 fetched column value was truncated ...

It took me a while pick database development over dabase administration, concerning a editions.My questions is simple, if I've decided to create an editioning view over a table with N triggres, what would I do about this??some people says all triggers must be ...

During executing a big PL/SQL blocks, some of the numeric parameters get lost/replaced with an earlier value.There is no error message, the PL/SQL block executes, but some of the function calls get the wrong parameter values.See the LiveSQL link: it defines a ...

Hello Tom,I have a table which is having around 266573283 rows. In that table i have BLOB column which stores a xml data. In that column i need to parse the xml and then get the value of on node. This node may or may not exists in all the rows. I have tried us...

Dear Colleagues,I have come across a problem when ranking regression slopes over a database link.I have a table containing dates and file volumes for downloads from several sources. I want to make a Top N for the sources most growing in their volumes. For this...

I was reading the following discussion about using Object Typeshttps://asktom.oracle.com/ords/f?p=100:11:607033327783906:::::https://docs.oracle.com/cd/B10501_01/appdev.920/a96624/10_objs.htmBut, I couldnt understand the object types usage in packages (mainly ...

Chris & Connor,We are working on a new project and were wondering as to what options are currently available / provided by Oracle for Change Data Capture, besides the DIY MViews ( MVIEW logs mostly ), triggers etc, does Oracle 11.2.0.4 and above provide an out...

Greetings, My question is in regards to Oracle's recommended process of sizing an Oracle database. When I have participated in sizing an Oracle server, we only estimated the table sizes using the field sizes multiplied by the total number of records. Then, w...

Looking for a recommendation related to large table inserts in Autonomous (ATP) database. We have a sizable history table in our database, roughly 45 GB, which stores all transactions at the end of each day. Recently, we have been experiencing performance cha...

Hi,thank you for taking my question,I wanted to know the logic behind not being able to reference :new and :old variables in dynamic sqlexecute immediate 'insert into tablea (columna, columnb) values (:old.columna,:new.columnb)';this will fail just trying to u...

Hi,How can i connect to SQL developer using oracle wallet based security.from sql plus we can connect using the command like /@sid, but how can i connect to SQL developer (or) toad using the wallet based security.Thanks in advance. ...

I need to give access to other user on current DB_LINK, can you provide command ?Current Link: sittestGrant to User: Z9XBIQ1_DWRegardsChaudhry...

I have a table called DAY_INSP and a column INS_DATE which allows dates in the future. I want to prevent that by only allowing today's date or older. Do I need to add a trigger or constraint to do this? Any help would be appreciated...

Hi,I am helping developers to track their failed call to oracle procedures in java app, thought unified auditing can do that. so I create a unified audit policy on execute on the procedure, however, the audit only record the successful execution, but when the ...

Using CTAS, created a new partitioned, compressed table from an unpartitioned compressed table. Segment size went from 6gb to about 10gb, with around 2000 partitions. I was table to replicate this growth in two separate environments. I I'm assuming this is n...

Hi Tom,Suppose I am having following SQL queryUPDATE TB38OSET G000KE =(SELECT TB39G.A6000D FROM TB39G WHERE TB39G.A0020C = TB38O.A020KF AND TB39G.A0090C = TB38O.A090KF AND TB39G.A1010Y = TB38O.B010KF AND TB39G.A6000Y = TB38O.G000KF AND TB39G.A0230Z = TB38O.A23...

We are doing upgrade of Oracle 10g DB to 19c. for the data migration, we use export the data pump from 10g DB and import it into the new 19c DB.After the data migration was completed and start the performance testing, We found that many Query SQL runs much slo...

Dear Tom,Oracle 19.22 / ibm aix 7.2We have a set of 7 tables on which flashback data archive was enabled for almost more than 7 years and was running without any issues. The databases were upgraded from 11g to 19c a couple of years back and post the upgrade as...

1. I am trying to run a dbms_data pump Export and import on Schema level by creating a pricedure, also I have the neccessary Privileges on the database on Which I am Running like EXP_FULL_DATABASE and IMP_FULL_DATABASE,read/write/execute on the data_pump_dir d...