AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 2 hours 24 min ago

Update production database from ETL Process

Wed, 02/13/2019 - 00:00
Hello, Ask Tom Team. I am using a Microsoft SSIS ETL Package to insert data to Oracle (source and destination). I want to do an incremental load every day but I have to flag the rows that are already loaded in the destination. It is not just s...

DB Link between Oracle 12c (Linux) and Oracle 11.2 R2 (Windows)

Tue, 02/12/2019 - 00:00
Hi everyone, I have a problem with DB Link. I'm trying to create a dblink from and Oracle 12c (installed on Linux Server) and Oracle 11.2 R2 (installed on Windows Server). I've correctly created the dblink, but when i try to query the result is: "<b...

Log Recovery in Dataguard alert log

Thu, 02/07/2019 - 00:00
Hi all, I am using Oracle 11g Active Dataguard in maximum performance mode. I notice 2 general pattern of log recovery in the database alert log. ===================== Pattern1 <code>RFS[7]: Selected log 11 for thread 2 sequence xxxxx Arc...

Parsing through a Long Character with 255 characters and Stripping out Words

Wed, 02/06/2019 - 00:00
Hi, I have a long character field for every one of my 10,000 rows and I need to write a PL/SQL that goes through every row a parses this long field for any WORD (Mix of Alpha and Numeric) up to 6 characters and spits it out and Save it to a differ...

Sortorder in Table Functions and Pipelined Table Function

Mon, 01/21/2019 - 00:00
Hey, suppose there is a function that return a numeric collection with 100.000 records. Will the rownum pseudocolumn always have the same value than the column_value pseudocolumn? Is there a difference between TF and PTF? What about Parallelism? ...

Please help, can't drop a corrupt table

Wed, 01/09/2019 - 00:00
Hi all, we have a corrupt object named "TO_BE_DROPPED" in our development database. Previously it had a different name, but someone renamed it, because it cannot be deleted, only renamed. It cannot be dropped by any means we could find. Apparently...

what are tables with MDXT in the name and can I delete them?

Mon, 01/07/2019 - 00:00
Hi, I have a datawarehouse with 5000 tables in it. <code> select count(*) from tab where TABTYPE = 'TABLE' </code> In this datawarehouse there are also tables with MDXT or MDRT or BIN in the tablename, more then 4600!! 400 actually use 4...

Replicating Data to another database in the same server

Mon, 01/07/2019 - 00:00
Hello, Ask Tom Team. Happy New Year for all of you. I have two single instance databases (A and B) in the same server. I need to replicate from A to B (some columns of some tables) in order to customers can view the data through a web applicat...

Alphanumeric Counter

Mon, 01/07/2019 - 00:00
Hi, i would like to know if it is possible to generate a alphanumeric counter like below. A001 A002 . . A999 AA01 AA02 . . AA99 AB01 AB02 . . AB99 AC01 . . . ZZZZ how can we implement this in a function? i have tried couple o...

ORA-01031 in view DML with dual reference

Mon, 01/07/2019 - 00:00
At a customer I work for there is a design standard that each DB-view should start with a so-called 'comments' block. This is to ensure that comments are stored in the data dictionary in the DB. create or replace view xxxx as with comments as ( ...