Questions

test<code>asdfjksa</code><i>abasdflkj</i>...

After using dbms_scheduler since its introduction I was surprised to learn that it is not the way application development should go.I was explained that having scheduling outside of the database is better than having it inside the database.And the replacement ...

Environment InformationDatabase : Oracle Database 19c (Multi-Tenant Architecture) - Version 19.25.0.0.0GoldenGate : Oracle GoldenGate Microservices 19cReplication Setup : Data replication will be configured between:Source : On-premises database server (Server ...

Hello Chris. Hello Connor, I’m struggling with a performance issue … We have a single big table (167 million of rows, 118 columns). For ad hoc queries we have created a simple Apex application with 15 most important columns as filters. To avoid long running ...

(https://livesql.oracle.com/ords/livesql/s/da34i74lkmxt2mqrtp0k4xsk6 )(I was able to format better with screenshots on the Oracle forums - https://forums.oracle.com/ords/apexds/post/help-solving-a-logical-problem-using-analytical-query-3778)Hi,I am trying to s...

Hi!We have a lot of Apex apps, so we check the LAST_UPDATED_ON value in both the production and dev apps before deploying to production.Like this:<code>select d.APPLICATION_ID, d.APPLICATION_NAME, d.ALIAS, d.OWNER DEV_OWNER, p.OWNER PERP01_OWNER, d.LAST_UPDATE...

Hello,I have multiple baselines and after migrating the application many of them got not reproducible.The reason was renaming of some indexes during the migration.I have renamed those indexes back to the original name.My question is how I get Oracle to set tho...

Can someone please provide Oracle sql query to get below output?Deptno Dept Name No. of emp10 a 10 b 20 c 3020 d 40 e 50 f 6030 g 70 h 80 i 90...

Hello ASK TOM team,Recently our client has come out with a requirement to be able to rollback database part of any application deployment. Now in our case, the application deployment can mean any or all of the following from a database perspective:a) PL/SQL co...

How do I know which tablespaces have which data files and their path on disk?...

Hi Team,This is the first time I am asking question on asktom, while I am very much thankful to the solutions you have provided and kept helping people always.We want to add 60 CLOB columns to the table which is around 17TB in size. This is a datawarehouse DB...

Hi Tom, Thanks for your continuous support. We have a table with blob data type as one column. We are using secure file option as we are using 11g. We kept the blob column in a seperate tablespace. In the main table we have a column called streamID whic...

Hi Tom,Presently, it is not possible to replace a part of a LOB (the DBMS_LOB package does not have a replace function). The write procedure overwrites.Is it possible, if not why, to write at a certain position (not append) and offset the remaining portion whi...

I’m having trouble with the parallel execution of an Oracle SQL query for creating indexes on <b>separate table (assume each table have single index)</b>.The performance boost isn’t even close to what I was hoping for. I therefore need your help in determining...

Hi,I see Oracle document shows an example of insert statement for fast ingest as INSERT /*+ MEMOPTIMIZE_WRITE */ INTO test_fast_ingest VALUES (1,'test');Can fast ingest using memoptimize be used for insert statement, that is INSERT as select...INSERT /*+ MEM...

I created a new project in Visual Studio 2019 with Entity Framework v6.5.1, Oracle.ManagedDataAccess v23.8, and Oracle.ManagedDataAccess.EntityFramework v23.8.When I add an ADO.NET Entity Data Model, I select EF Designer from the database. It then prompts me f...

Dear TomI have Oracle EBS 12.8 with Oracle 12C. I upgraded my database to 19C with the latest patches, and everything is working fine, except my DBlink with another MS SQL server. Note that it was working before the upgrade. I dropped the DBlink and re-created...