Skip to Main Content

Questions

QuestionUpdatedAsked

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...
15 hours ago5 days ago

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...
15 hours ago18 hours ago

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 ...
16 hours ago21 hours ago

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@...
16 hours ago12 days ago

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,...
16 hours ago7 days ago

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...
30 hours ago5 days ago

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"...
30 hours ago5 days ago

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 ...
30 hours ago5 days ago

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...
30 hours ago5 days ago

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...
4 days ago6 days ago

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...
4 days ago7 days ago

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...
4 days ago17.9 years ago

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 ...
4 days ago2.7 years ago

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...
4 days ago2.9 years ago

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...
4 days ago6 days ago

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...
4 days ago15.3 years ago

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...
4 days ago7 days ago

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 ...
5 days ago6 days ago

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...
5 days ago8.4 years ago

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...
6 days ago6 days ago