Questions

Hi tom, I have a table with compression, also have partitions and subpartitions. You can see The create DDL on the below. As you can see all of my objects are compressed or nocompressed. Bu i can't see this information on the all_tables table. Compression ad c...

Hello Tom,I am wondering what is the benefit of using a recovery catalog over a control file? What are some of the decisions one should consider before going either way?Please and thank you ...

I am using Windows 11 64 bit / Oracle 19c .Everything works fine except when I create a nested table and associate it with my table as a column . I can neither query it nor drop the table . When I query I get a message that the connection to the database was r...

I encountered inexplicable freezing of pl/sql procedure while trying to fetch and insert data into table, however same operation runs successfully when called with sql query in any IDE.I am trying to realise ETL process in data warehouse database.I need to loa...

Hey Tom,I have a Java application that runs thousands of different types of queries against an Oracle database millions of times. I wanted to save the query preparation time by using the oracle.jdbc.implicitStatementCacheSize JDBC property to cache prepared qu...

I have an interesting request from our Warehouse Team.They require us to enable supplemental logging on ALL COLUMNS on core tables, we already have force logging for our DG.Our DB size 60TB.Interestingly our SLA's on processing is 3/4 seconds.Can I both Supp a...

<code>declare    raw_hash  RAW(20);begin    /* 4000 + 1. */    select standard_hash(    [literal string of length 4000]                          || '-'                        )      into raw_hash      from dual    ;end;/-- ORA-01489: result of string concatena...

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 ...

I have to open a url having image and display from oracle forms in a separate browser window. Since the image will change for every transaction, the image should show in same window. My forms is running on Oracle EBS R12....

I have a Oracle 23ai (Version 23.4.0.24.05) installed in a VM but currently not used. I would like to upgrade the same to 23.9. Is this possible as I could not find any articles? Any guidance on this.....

Hi Tom,I have a table like thiscreate table temp1(f_name varchar2(100), f_date date, f_amount integer);Records in this table will be like this:Ajay 15-JUL-02 500Bhavani 15-JUL-02 700Chakri 17-JUL-02 200Ajay ...

QuestionWe're evaluating different approaches to implement the Outbox Pattern in Oracle 19c for reliable event publishing in our microservices architecture, but we're concerned about the significant I/O overhead and performance implications. Could you provide ...

HiCan we update data in Materialized view directly using update statement. If yes,will that updated to table as well. What if there are more than one table in view?Please help me on this....

In some 10gr2 and 11gr2 Customer´s databases I need, inside sqlplus , print some data vertically, much like your PRINT_TABLE function, but my user is "read-only" , I´m not allowed to create nothing (ie, no stored PL/SQLs, no tables, nothing permanent) insid...

Hi Tom,Suppose I am having following SQL queryUPDATE TB38OSET G000KE =(SELECT TB39G.A6000D FROM TB39G WHERE TB39G.A0020C = TB38O.A020KF AND TB39G.A0090C = TB38O.A090KF AND TB39G.A1010Y = TB38O.B010KF AND TB39G.A6000Y = TB38O.G000KF AND TB39G.A0230Z = TB38O.A23...

I think there is a way to do this but I can't remember.We have 40 tables 500GB+ in size that we maintain between sites using fast refresh. It's a setup that's worked remarkably well for a long time which we don't want to change.We'll be rolling out a 3rd site ...

Hello.We just upgraded our main database from 12cR2 to 19c(exactly 19.25).Some of parameters are changed, including log_buffer.Previously we set log_buffer parameter to 20M, and also speicified in parameter file.After upgrade we removed because out consultant ...

Hi Tom,I’m encountering an issue with my Oracle Database 23Free. It throws the ORA-12954 error: "The request exceeds the maximum allowed database size of 12 GB." After investigating the database files, I discovered that the SYSAUX tablespace is the main contri...

I have developed a news application using Oracle APEX, and I am now preparing to move it into a production environment. I would like to estimate the required resources for both the Oracle database and the application server (Tomcat) to support approximately 60...

Hi, I know that there was one question about Apex automation successfull rows. But it was very basic example.I have a procedure that performs some DML operations inside a loop. Depending on certain conditions, it updates or deletes rows.My question/use case is...