Hi,I am working on a Archiving application. Aim is to bring year and years of data from Production DB into another DB named as Archiving DB and then delete from the Production DB. Currently I am testing deletion on an Archiving DB to test my package performanc... | 5 hours ago | 7 days ago |
Why Do /*+ materialize */ Hints Generate Redo?What modifications are materialized subquery factoring clauses making that is needing to be protected by redo?Session A executes a SELECT statement six times. The first three executions are without the /*+ materia... | 5 hours ago | 7 days ago |
Hi there, masters.I'm facing a rather weird situation regading the TSTZ configuration. A full detailed description of my initial problem is here in this post I made some months ago: https://community.oracle.com/tech/developers/discussion/4490678/ora-39405-sta... | 6 hours ago | 2.2 years ago |
HiI have a query that is spooling results to a text file via an automated process Monday to Friday. Below are the variables that are used in the query. The queries returns data in Oracle SQL Developer, but returns only the headers with no data when I use Toa... | 6 hours ago | 8 days ago |
I have a table with two columns that need to be defined as primary keys, order_number and item_number. A table can have only one primary key, but I can define composite primary keys in the table_constraint syntax. How do I define two columns as composite pri... | 7 hours ago | 24.1 years ago |
Dear AskTom Team,first of all thanks for all the support you are giving all of as for some many years.I already read many of your answer about the topic <b>PL/SQL Collection</b> slowing sql execution.I alredy tried all the hints (such for example the <b>cardin... | 7 hours ago | 8 days ago |
Hi Tom,I have a question about having an ID column in all tables of an OLTP system. In my application, all tables have ID (Not sure why it was designed that way) column which gets populated by Sequence and this ID column value is not used as a referential key ... | 30 hours ago | 3 days ago |
hi tomcan u explain me in detail about "start with connect by" sql statement (tree structure).i know there is documentatin but it is very confusing. ... | 31 hours ago | 23.2 years ago |
Hi Tom,I want to send email through PL/SQL by using utl_mail package, I have completed below steps1. Installed scripts <b>@$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb</b>2. granted execute to user3. created ACL and granted... | 31 hours ago | 4.4 years ago |
Hi Tom/Team,I have installed Oracle 11g Database on my Windows 10 64-bit machine.All installation has been completed successfully. I have checked connections by sqlplus and it's running fine. I am able to run queries as well there. So database is working fine ... | 2 days ago | 5.4 years ago |
Dear Ask Tom team,Could you please clarify why using a longer declared size of VARCHAR2 affects CPU consumption during SQL execution? Assuming that there are no essential flaws in my benchmark design.Based on my findings, the declared size of VARCHAR2 does imp... | 5 days ago | 8 days ago |
I have an issue, where i am trying to upload data from my xml file into the table using oracle apex data parser api . I have 6 columns in xml file and in which 1 column is not having any data in any of the records . When i try to insert the data , instead of s... | 6 days ago | 2 weeks ago |
Hi TOM,Not long ago it was easy to determine if your DB is on premise or on cloud: their banners (from v$VERSION) were different.Now Entreprise and Standard original editions can be on premise or on cloud so we can no more determine in which environment we are... | 6 days ago | 2 weeks ago |
Dear Team.Firstly I would like to thank you for your valuable time and quick responses.I have two users userA, userB.userA has a table abc and userB want to access it.When userA grant select, insert, update, delete to userB directly then userB can access it wi... | 7 days ago | 6.8 years ago |
Hi Team,I have a question about the background execution of dequeue procedures Oracle <b>Advanced Queuing</b>.We are using Oracle 19c & in our case, we are enqueuing AQ messages through DML triggers using dbms_aq.enqueue. Then we dequeue using dbms_aq.dequeue ... | 9 days ago | 2 weeks ago |
Dear Tom, please help me with the below.Session 1:update table set field = 'A' where field2 = 'B';it is not committed/rollbackedSession 2:update table set field = 'C' where field2 = 'B';The session will be waiting for session 1 to get committed, but where the ... | 9 days ago | 7.7 years ago |
Hello Tom,Please, I need a big help.I have a job scheduled in Enterprise Manager 12c. This job do a full export, but two days ago I started to get the error below:ERROR at line 1:ORA-31626: job does not existORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512... | 9 days ago | 7.4 years ago |
I have a table that I converted to interval daily PARTITIONs.Ie<code>partition by range (date_col) interval (numtoyminterval(1, 'DAY')) (partition P_OLDDATA values less than (to_date('01-JAN-2021','DD-MON-YYYY')) ); </code>My issue is that there were some deve... | 9 days ago | 2.6 years ago |
I need a example using DBMS_CRYPTO.SIGN.I'm need to sign a hash using RSA-SHA1 and I need to know if can i use DBMS_CRYPTO.SIGN?... | 13 days ago | 2 weeks ago |
Dear Tom,I am temporarily supporting a RAC, ASM database on 19c. I have to create a new tablespace. For the existing tablespaces I see that datafile names look like +IPAG_DATA/t5cnp1db/datafile/avos_dat.362.1067066741 I understand that +IPAG_DATA is the asm di... | 13 days ago | 2 weeks ago |