Skip to Main Content

Questions

QuestionUpdatedAsked

We have a requirement where we are looking for DB dumps to be exported using DBMS_DATAPUMP api for specific time period like 01-Jan-2020 to 31-March-2020. I am aware of Flashback time and flashback scn number but it will export only for specific timestamp but ...
20 hours ago5 days ago

I have a Oracle pivot query that works with 19 values in the IN clause but when I add a 20th, it fails with an ORA-01427 error. This works:<code>select * from (select serial_no, buyoff_user || chr(13) || to_char(buyoff_date) || chr(13) || serial_oper_status ||...
21 hours ago4 days 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...
21 hours ago19.7 years ago

I have recursive query on Oracle 11g table with undirected graph data. Each row represents one edge. The recursive query traverses all edges starting from given input edge. The idea of query is: - input edge is at the 0th level- for n>0, edge is on n-th level ...
4 days ago6 months ago

Greetings,My question involves the use of the FAST RECOVERY AREA for online redo logs and even controlfiles. Typically, the backup mount points are on slower disks. Therefore, if we were to set DB_RECOVERY_FILE_DEST to that backup mount, my assumption is tha...
4 days ago4 days ago

Greetings,As I as was reading the 19c Data Guard manual, I came across a topic in about being able to use a backup taken at the primary to perform a block level recovery at it's standby database. I read that block level recovery can automatically be done if w...
4 days ago4 days ago

Test case can be found at: https://livesql.oracle.com/apex/livesql/s/lgh3hduetd3lqd74jvuolc78kGiven:<code>Drop table t1;Create table t1 (c1 Int Default 0 Not Null, c2 Int Default 0 Not Null);</code>Is it then possible to:<code>Alter table t1 Modify c...
4 days ago4 days ago

I have a database and I want to print the following, The last 10 rowsThe first 10 rowsThe largest zipcodes numberThe smallest zipcodes numberThis is the code I used.import pymysqldb = pymysql.connect(host="192.168.0.180",port=4000,user="maxuser",passwd="maxpwd...
4 days ago5 days ago

We have an oracle database and the hostname in listener and tnsname files is 10.<b>5</b>.6.212and there are some upgrades from the infrastructure team and they will change vlan for server and will be 10.<b>8</b>.6.212 so what should I do to prevent any impact ...
4 days ago5 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...
4 days ago12 days ago

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...
5 days ago4.6 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...
5 days ago2 weeks 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...
5 days ago11 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...
5 days ago20.9 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...
5 days 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...
5 days 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...
6 days ago11 days ago

How to find all sundays of the year without writing any block or procedure or function?...
6 days 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...
6 days ago11 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 ...
6 days ago2 weeks ago