Questions

Hi Tom,I have a scenario where I need to refresh a partitioned table from another database. The existing process copies the data over a db link and creates a temporary partitioned table. Then we exchange the partitions with the target table and at the end we j...

I was wondering if there is some possible way that I can fetch the last record from a table. In this particular case, obviously one is unaware of the number of records in a table. All I want is to write a query whcih will simply fetch all the columns of the la...

HiWe have a rather complicated cleaning process. We have implemented it so that we divide key space to 4 separate number spaces and run them concurrently. Each of the 4 processes make decision if that row is to be deleted and if so deletes the row and dependen...

Hi Tom,We have trouble loading 400 million records from one table(temp table) to main table. We have been getting 200 million data earlier from upstream and we were able to load it 3 hrs by DBMS_PARALLEL_EXECUTE concept. Now the data is increased to 400 millio...

Hello,We would like to purge old entries in V$ARCHIVED_LOG in primary and standby databases because we have noted that some queries using V$DATABASE, V$BACKUP_SET and V$ARCHIVED_LOG especially on standby are sometimes slow.We have control_file_record_keep_time...

I'm trying to create a generic before update trigger which will compare all :old.column_values to all :new.column_values. If the column_values are different, then I would like to log the change to a separate table. When I try to compile :old.<column_variable...

Hi: I want to clean some space about some tables ,there are a few ways ,such as move ,shrink and impdp. I want to know which one is better regardless of space consideration and assume this tables can use all those methods. Can you answer my question from spa...

Hi Tom,The question which i am asking might look very simple but for the past 2 days I have been trying for a solution and checking in multiple forums but couldn't get any clue.I have a scenario where I have to run a report in automatic and manual mode.For Aut...

Greetings,I have come across two approaches to view the findings of the segment advisor. Here they are:1.) select tablespace_name, segment_name, segment_type, partition_name,recommendations, c1 from table(dbms_space.asa_recommendations('FALSE', 'FALSE', 'FALS...

How to find all sundays of the year without writing any block or procedure or function?...

Hi Tom,Thanks in advance. I am trying to replace naked decimal with '0.' Here is the example. String: '.45ML-.91ML-25MCG/.5ML-.9ML(.3ML)-25.5ML or .45'Every occurrence of naked decimal point should be replaced with '0.' resulting in '0.45ML-0.91ML-25MCG/0.5M...

1) Why the following each rman channel process memory allocated were almost all more than the _pga_max_size？2) Why the following total rman channel processes' memory allocated could be far more than the global pga_target？<code>SQL> SQL> SQL> SELECT a.ksppinm ...

I have installed and configured Apex 20.2 with ORDS 19 and Apache TomCat 9 on a Windows 2016 Server. The Database is 12c Enterprise Edition without a Container DB. I have an application built for initial registration for an event and I am expecting 3000 to 500...

I have changed oda-admin password but web front still says password expired.odacli-adm set-credential --password --username oda-admin...

Team,Was reading about Real time operations monitor in Oracle 12c @ <u>https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/monitoring-database-operations.html#GUID-DC573FB7-40C5-4D6D-BE81-EF356900B444 </u>and here is a quick demo from local d...

In one of the databases , we have list of courses , descriptions , outlines , ... We would like to implement "google" like search ( ie) a) If I type the keyword "data" , it look for databases , data mining , big data ... b) If I type the keyword such as "Proje...

Thanks in advance for all the help the team provides, much appreciated! I have a situation where the application I am working with utilizes GTTs to load data in to and filter SQLs. The problem is that in so doing the application is also injecting a cardinality...

Hi.When i do sqlplus systemand dont type a password, this happen:SQL*Plus: Release 8.0.6.0.0 - Production on Thu Jun 21 14:13:37 2001(c) Copyright 1999 Oracle Corporation. All rights reserved.Enter password: ERROR:ORA-01005: null password given; logon deniedE...

Hi TomI hope I'm phrasing this correctly...I'd like to be able to send an HTML formatted email from the database using the UTL_SMTP package. I don't see any way of setting the MIME type.Is this beyond the scope of UTL_SMTP?thanks in advance!Ken ...

We are unable to install 18c Expression Edition in Windows 10 it is extracting and in middle, it is start rollback. Finally below the below message. Below is the message.The wizard was interrupted before Oracle Database 18c Express Edition could be completely...