Skip to Main Content

Questions

QuestionUpdatedAsked

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...
7 hours ago4.6 years ago

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...
7 hours ago19.7 years ago

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...
12 hours ago13 days ago

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...
13 hours ago7 days ago

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...
14 hours ago7 days ago

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...
15 hours ago20.8 years ago

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...
22 hours ago5 years ago

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...
23 hours ago3.6 years ago

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...
31 hours ago6 days ago

How to find all sundays of the year without writing any block or procedure or function?...
31 hours ago5.1 years ago

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...
45 hours ago6 days ago

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 ...
45 hours ago13 days ago

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...
2 days ago7 days ago

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

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...
2 days ago2 years ago

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...
2 days ago1.1 years ago

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...
2 days ago6 days ago

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...
2 days ago19.7 years ago

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 ...
2 days ago19.4 years ago

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...
2 days ago2 years ago