Questions

I just upgraded to Oracle 18c XE from 11g. I have an external table that worked fine on 11g, but I keep getting the following errors on 18c.ORA-29913: error in executing ODCIEXTTABLEOPEN calloutORA-29400: data cartridge errorKUP-11604: no directory object spec...

Hi Tom,I have this data <code>select 1 LineNumber, 1 mylevel, 10 id from dualunion allselect 2 , 2 , 11 from dualunion allselect 3 , 3 , 13 from dualunion allselect 4 , 3 , 14 from dualunion allselect 5 , 4 , 15 from dualunion allselect 6 , 2 , 20 from dualuni...

Hi.I'm trying to build a query to get dates intervals. Let me explain it in a simple way.We have a table with this fields: <code>Soldier_ID | Soldier_Name | Location | Ranking | Start_Date | End_Date1001 Jones Texas ...

Hi,I have a requirement where I need to export DB dumps using DBMS_DATAPUMP api to the Object storage on Oracle Cloud Infrastructure.I found below statement on official document to export dumps at object storage using expdp utility. <code>expdp admin/password@...

This question is most common with no clear solution.I have 2 scenarios for dynamic pivoting and the solution requested could be using pivot xml(tried, but extracting is a task)/dynamic sql execution/arays if possible we could use..Scenario 1:In the first case,...

HiIn a stored function I would like to detect whether it was called from an sql query. If not then my function will perform DML. Otherwise it will save function parameters into a buffer - a package variable. The DML execution will be deferred until after the q...

hello I hope you can guide me.I need a tool to notify me of significant log messages from weblogic to some other tool (for example whatsapp)My goal is "not to be sitting in front of the console watching the logs"...

Hello! Our Billing system works with Oracle DB of version 11.2.0.4 (next year we are planning to upgrade all DBs to 19C with RAC). Oracle DBs run on LINUX servers. We got a requirement from our customer to install Anti-Malware Software on all LINUX servers ...

When I've published the ASP.NET Core Web App to Azure I get the following Error when trying to use the oracle database.<code>NetworkException: ORA-12154: TNS:could not resolve the connect identifier specifiedOracleInternal.Network.AddressResolution..ctor(strin...

Problem statement: Delete 40%(4TB out of 10TB) of unwanted data using Partitioning techniques from Oracle db(11g) and reclaim space. Details:My application DB schema size 10 TB. Oracle 11g and the schema is co located with many other schema's, hence any option...

Hello,we have a table with records that contain values that have to be filled in batch and should be consumed by the client application.The various sessions should read a record and delete it and it must be guaranteed that one record is used by only one sessio...

hi Tom,I started with your dir listing code and it's working out very nicebut I am trying to figure out how to get the rest of the file info using File object. I am having a problem with the dates specifically.Here's my attempt but as you can see theres a prob...

Hi, My requirement is to generate the list of random numbers based on the total count provided. for instance, if total count is 100, i have to generate 100 unique random numbers. Below is the sample code i used. Could you please check and let me know will the ...

We perform a duplicate database from prod to test weekly and have a script that captures the current user permissions on dev via the dbms.metadata.get_ddl package that generates DDL to another file to be used after the duplication to re-create any user that ha...

Hi Connor, Chris,Past few days we are facing issues with database packages getting invalidated and all application processes resulted into "ORA-06508: PL/SQL: could not find program unit being called"/We could find the invalid objects in user_objects for somet...

Hi Tom,Recently with the help of your valuable answers to my questions regarding system statistics, I have put "system statsitics" into production system after testing and results are wonderful. It saved my more than 50% of execution time. My questions regardi...

Hi Tom, a fan of your work.Have a question: are there any operations in Oracle preserving row order?For example, can I expect that<code>select * from (select tag from test order by tag)</code>Will return in sorted order?Or if a pipelined table function produce...

Hi Connor, Chris,I have referenced partitioned tables as belowIts a daily range partition on ORDER_DATE column.<code>CREATE TABLE ORDERS( ORDER_ID NUMBER(11), PART_DATE DATE DEFAULT trunc(sysdate), .... 150 columns ...

Hi Tom,Just wanted to know , if oracle database supports all the normal forms we know i.e1st,2nd,3rd.BCNF,4th,5th.http://psoug.org/reference/normalization.htmlIs scott schema we use , is it fully normalized/or can be normalized till 5th normal form?In genera...

I had similar requirement earlier but now i have been given a clear approach that needs to be implemented.I need to write a procedure(preferably)/function, which would on basis of app_id passed as parameter, change the column headers for corresponding values p...