Questions

Hello Tom,I have a live table (Investor) with customers records and another table (Invdatew) has the same records but have one extra column for date,. After each end of day I use dbms_job to insert the the exact data from live table to the other one plus sysda...

Hi,I have procedure via database link, and getting this errorORA-02064: distributed operation not supportedThis is because need to apply pragma autonomous_transaction. But is there any other way? some of the procedure we need to reuse, and we only need to per...

Dear Experts,Need your guidance/suggestions to resolve this issue:Part of oracle advance queueing implementation, we've to dequeue the message as soon as it has been enqueued into the queue. This should happen immediately without any manual intervention/schedu...

Hello,Could you please clarify the meaning of the view V$RESERVED_WORDS and especially its contents?At first glance, the documentation has a clear explanation. The view contains reserved words, and columns RESERVED, RES_TYPE, RES_ATTR, and RES_SEMI describe, f...

Hi,I have a query which i am trying to load the data using 2 options:1. Materialized View Refresh with Non-Atomic Refresh2. Insert into Select Materialized View Refresh: When i try to Complete refresh a Materialized View in 12c Database residing on Exadata, Th...

I want to get difference between two dates say(10-FEB-2000 - 02-JAN-1999)and the result has to be displayed in following format1 year, 1 month, 8 days ...

Hi,I am carrying out an update on dept table with update query as - "update dept set dname = initcap(dname) where deptno=20;"As, I have not committed, row lock will be placed on the row. I want to find out the rowid of dept table locked from V$LOCK. Currently,...

Good day,I want to backup my Snippets but cannot find the file to back it up as I cannot locate the XML file with my Snippets therein. I went to system23.1.1.345.2114 and in there I went to o.sqldeveloper.snippet and this folder is empty despite me setting "So...

Hi Gurus,I have a schema as described in the link https://livesql.oracle.com/ords/livesql/s/ct0zdah8slxq66h8fnpfhwdby.<code>drop table t;create table t( instance number , id_sup number , id number , srt number , v01 number , v02 number , v03 number ...

Hi Senior, My database is 12C PLSQL. Is it possible to alter table and add IDENTITY for primary key, if the data in the table is beyond <b>200Crore</b> or <b>2Billion</b> data. As I am concerned about database crashing or Cache overflow.Please guide ...

We have a context index that is SYNCing every 6 seconds. Here is the DDL for the index: CREATE INDEX "SSS"."QUOTE_NUMBER_CONTEXT" ON "SSS"."QUOTE" ("NUMBER_") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('SYNC (EVERY "SYSDATE+1/14400")');This was working p...

Hello,Mastering Oracle PL/SQL book has been released 21 years ago with Connor McDonald as one of the author:https://github.com/Apress/mastering-oracle-pl-sqlI would like to know what you would modify if you would update the book for Oracle 19c:- any topic to b...

Hi,Recently while preparing to run the Release Upgrade for 19.24 I was doing a cold back of my ORACLE_HOME and I noticed that I had a ton of old .log, .trc, and .trm files. I deleted old files in the trace directory, audit directory, and some of the log direc...

Hi Tom & Team,we have ORACLE Database 19C and it is editionable.ALPHA/BETA/ORA$BASEwe have created our tables with XXX_E (non editionable) and created views(editionable) on top of it.Active edition is ALPHA.in BETA(Inactive edition), when we increase column le...

If I only wanted to do multi-master replication of just a few tables (<5) between two Oracle databases in Oracle 19c here in 2023, without having to pay for the Golden Gate license, what are my options?I want something like the "Advanced Replication" feature f...

Hi Tom, I have sql statement with pdf book url attribute. I need virtual column till me the url is valid or not found. So I need page http status code either java function in oracle apex, or sql query.example: select title_no, title_name, pub_date, 'https://li...

I'm using a UDT with dataset inside there as a table and i want to use that UDT on Merge statement. When using that UDT, i put that UDT inside "ON (" as following: "... ON (SELECT * FROM TABLE (UDT)) ..." then, how can i to use that UDT inside INSERT statment ...

Hi Tom,first at all, thanks for all your support. I wish a blessed christmas time for you, your team and families.I´m looking forward for the best practise of a cursor to fetch just one (or a few) row(s) on my own sorting and lock them. Without locking the who...

We have a production DB that is used for reporting is been attempted to clone with NetApp Snapmirror technology. The current clone is done with old method placing the tablespaces of PROD DB in backup mode and then copying the files using OS “cp” tool to the d...

I'm using external tables everyday to load csv files but I'm having great difficulty loading my first FIXED WIDTH file. I've tried several different access parameter variations and the CREATE TABLE command compiles without error but when I select the table, I ...