Skip to Main Content

Can't see the Ask Question button?

Connor and Chris will be back taking questions again soon. Click Notify Me to be emailed when we're back taking new questions.

In the meantime, you can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

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...
6 minutes ago34 hours 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...
13 minutes ago2 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...
21 minutes ago40 hours 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...
47 minutes ago3 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...
53 minutes ago17.8 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 ...
54 minutes 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...
58 minutes ago2.8 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...
59 minutes ago2 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...
60 minutes 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...
14 hours ago3 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 ...
38 hours ago2 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...
39 hours 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...
2 days ago2 days ago

Hello Tom, I would like to be able to roll up a word count (for a WordCloud control in a UI) based on a query ( a spatial query in this case).I have a table as such<code>create table items (id raw(16), text clob, geom sdo_geometry )</code>This table has a full...
2 days ago3.1 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 ago19.1 years ago

Hi.Does anyone know how to add a "Compute" inside a "group by" already set up through the action button in an Interactive Report?Is it possible to do it, has someone done something similar?Thank you...
3 days ago7 days ago

I need sizes of all columns of a table and the same details of all user tables in db. -- Query to find # of rows and sizes of All data in Table1select count(1),sum(length(column1)),sum(length(column2)),sum(length(column3)),sum(length(column4)),sum(length(colum...
3 days ago7 days ago

Good Afternoon,How can we audit all select and DML statements by a user? I tried this: AUDIT ALL BY JCANTU; Then I ran a few selects, but the select didn't appear in the audit trail so I ended up just doing a SQL Trace. Is audit all supposed to create an a...
3 days ago7 days ago

Hello,I have a problem with <b>Real-time Materialized View ‘ON QUERY COMPUTATION’</b> functionality.My Real-time MV is enabled for both <b>QUERY REWRITE & ON QUERY COMPUTATION</b>.As I understand, when the MV is fresh, we get a MAT_VIEW REWRITE ACCESS FULL run...
3 days ago3.6 years ago

I have a clob column that as different tags in it, like the example below, I am trying to get the comments tag of all the rows, one of them is returning null, I am assuming it is because it has the word "comments" more than once, this is the query I am using:...
3 days ago6 days ago