Skip to Main Content

Questions

QuestionUpdatedAsked

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...
47 hours ago4 years ago

Hi Tom,I am not able to fully understand below recursive query. Especially, the condition "WHERE POS > 0" and " WHERE POS = 0". my understanding is pos is result of REGEXP_INSTR (STR, '[A-Z][0-9]{5}',1, RN). 1. if the first POS > 0, how could the final conditi...
48 hours ago4 days ago

Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors ...
3 days ago20.6 years ago

I have a table with 100 million rows. Table size is around 25 GB in the DB.I need to unload this data to a csv file.What is the best fastest way to do this.I was reading about external tables to do this by using CTAS but I dont think there is an option to dire...
3 days ago4.2 years ago

Hello Connor & Chris :-),I have some confusion about the <b>begin_time/end_time</b> in <b>DBA_HIST_SNAPSHOT</b> vs <b>DBA_HIST_SYSMETRIC_SUMMARY</b> vs <b>AWR report</b>.<code>13:52:22 SYS@emcdb> desc dba_hist_snapshot Name ...
4 days ago12 days ago

Tom,What is connection pooling ? Please, can you give an example(s) that show thorough understanding of the subject matter as related to either ODBC OR JDBC application connections to the oracle database. Your site is more important and most value to the li...
6 days ago17.2 years ago

hey tom I read from couple of article which state that when we issue a dml statement and commit, the changes made to the database and undo block is stored into the redo log buffer. what purpose does this undo block do exactly?...
6 days ago12 days ago

Hello,In the context of database link, is there a possibility to get the relation between both sessions of database "A" and database "B"? (database "A" query objects from database "B" using a dblink)In other words, from database "B" can we retrieve the SID of ...
6 days ago6 weeks ago

Hi tom, Hope you are doing well. I want to ask you that, can kafka read uncommitted data form oracle database from a session where data is not committed?...
9 days ago12 days ago

HiI have a multi tenant 19c databasebelow is the directory where my archives are generated/erpprd64/oradata/prd64cdb/fast_recovery_area/PRD64CDB/archivelog/in this I have a folder with today's date2021_10_05and below are archives generated in ito1_mf_1_783_joq...
9 days ago12 days ago

Team,This is is continuation with the below link :https://asktom.oracle.com/pls/apex/f?p=100:12::::RP:P12_QUESTION_ID,P12_PREV_PAGE:9543884800346428497,11I could not continue on that link , so sorry to raise a new request.The solution provided there works wel...
9 days ago12 days ago

hi tom i wanted to ask about interactive command(CTRL+C) when using datapump import exportwhen i use an export utility and trying to kill the export jobs it works with no problemexpdp test/asdzxc@pdb22 directory=asdzxc dumpfile=countries.dump reuse_dumpfiles=y...
9 days ago12 days ago

Hey tom i wanted to ask a simple thing, i wanted to know when do we need to recover a tablespace when we alter the tablespace offline temporary. i heard that sometimes we need to recover it especially when there is an offline tablespace when we alter the table...
9 days ago12 days ago

I want to insert data from excel or csv file (Id, Name, Address, Amount) into database table by using data load but during the insert of this data i want to decide this data is related to HSBC Bank (Because i have many bank and each bank have thousand of custo...
9 days ago1 years ago

We are doing performance-testing of SQL-statements in our project. When running explain-plans on the statements, the results are often not realistic due to the fact that we have not loaded the tables with data, and therefore the indexes, in most cases, will no...
9 days ago21.1 years ago

Hi Tom,Thank you. Your blogs are really helpful. I have a specific requirement while capture the exception that might occur at the time of bulk insert. What I need to do is when an exception has occurred, while updating the information in the exception table I...
9 days ago5.5 years ago

Hi,I have a SQL written in stored procedure:SELECT /*+ PARALLEL(TB_TEST, 8) +/FROM TB_TESTWHERE DT <= TO_DATE('01/01/2015', 'MM/DD/YYYY');When i execute the procedure and monitor v$session, I could see only one session with having SQL_ID which belong to above ...
9 days ago4 years ago

I'm using the datapump api to export schema objects.My issue is the user I'm trying to export has scheduled jobs and I want to exclude themBelow is the SQL to get a list of jobs for the userselect * from dba_scheduler_jobswhere owner = 'DC_PLAY'below is my fil...
9 days ago5.5 years ago

Let's say we have a table of documents with key of doc_id. This table contains millions of documents(rows). There is also a table that assigns one or more industry codes to each doc:create table doc_ind( doc_id integer, ind_code varchar2(10))This ta...
10 days ago20 years ago

Hi Tom,I have an AQ and the Queue table [QT_WRITE_OFF] has 40,196, 299 records. The task is to do dequeue about 28 million items[which meet a certain criterion] from this queue. Unfortunately, the queue was left to grow too big and I have to find a way of de-q...
11 days ago2 weeks ago