Skip to Main Content

Questions

QuestionUpdatedAsked

We just hit 2.1 billion row count on a table with primary key INT. This is the worse thing to happen :( Any one know if we can do alter without requiring space on the DB for the entire table?...
35 hours ago8.5 years ago

Hi, I'm interesting to know if there is any way to execute external procedures in Autonomous database cloud service?Actually we use external procedures calls to execute important routines (functions) needed for our applications, we are using Linux and Windows...
35 hours ago1.4 years ago

We have seen in many situations in our environment where a SQL was running badly but the plan for the query has not changed. When we gather stats for the associated table.we see that same query performs significantly better. However there is no change in PHV o...
3 days ago7 days ago

Hi Tom, I went through the articles & documentation, your article answers most of the issues Asktom EBR Part 1 => http://www.oracle.com/technetwork/issue-archive/2010/10-jan/o10asktom-172777.htmlAsktom EBR Part 2 => http://www.oracle.com/technetwork/issue-arch...
3 days ago7.9 years ago

Hi Toms,eventually, after many years, I came across e question I never realized.Indeed I have to face a customer, who uses the user$.user# for application purposes. Will say after creating a user, that application stores the user# within application tables col...
3 days ago7 days ago

We are going to MOVE the TBS of AUD$ table in PROD. Purpose:AUD$ table is totally fragmented and the CLEANUP / PURGE runs very slow - even with max 1.000.000 batch size but as per test in our test environment we had some issues regarding using API (DBMS_AUDIT_...
3 days ago7 days ago

Hello,I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?According to documentation https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authoriza...
3 days ago7 months ago

Hi ,I am unable to connect to oracle database using SQL DEVELOPER. It gives me" i/o error network adapter could not establish connection". Please let me know what are the possible reasons for it and provide me the solution for the same.- I am using sql develop...
3 days ago4 years ago

Hi Tom,Why is this script failing? There is no errors on running this in Oracle 12.01 and previous versions!...
7 days ago6 years ago

What is the main purpose of white watermark and in a case secnario where all the records have been deleted and we try to lookup that table why does the data is looked untill it reaches to an end of whte watermark...
7 days ago16.5 years ago

In our project we have to create a table that should contain around 100 cr records and 60% records will be update in later time..date is the key factor on this table.. To manage this table what type of indexes and partitions are best suitable to improve the pe...
7 days ago3 weeks ago

Hi TomHere is the problem description-A reporting tables holds data with the date columns in EST. The report when viewed the same columns are reported in CST.I can add a straight offset and make the report available with the columns in CST. But what happens du...
7 days ago13.5 years ago

Hi I am migrating from Sybase IQ to Oracle 19C. there are many updates happening from one or multiple tables.My Target_TBL Table has 18 Million records per partition and there are 1000's of Partitions. (Partitioned by VersionID). APP_ID is one of the another k...
7 days ago2 weeks ago

I'm trying to figure out why my application occasionally receives the error ORA-00942: table or view does not exist.As the object in question clearly _does_ exist, I assume that the application changes the current_schema to some other schema which doesn't have...
7 days ago3 weeks ago

Howdy, I'm wondering about how SPM and things like https://blogs.oracle.com/optimizer/post/what-is-add-verified-spm would be impacted by the presence of global temporary tables within the query(s). I've been looking for documentation that would outline how SQL...
9 days ago2 weeks ago

When having two simultaneous merges into a table with a unique constraint in different sessions, the second one throws ORA-00001.Steps to reproduce:<code>create table tab1 (col1 number);create unique index ind1 on tab1(col1);--1st session:merge into tab1 dusin...
10 days ago1.3 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...
10 days ago7.2 years ago

Good Morning,It seems like Oracle has made some significant improvements to the "alter table move ONLINE" command in 12.2. For a basic heap table that is made up of varchar, char and number data types with a few b-tree indexes, it seems like we can now perfor...
10 days ago4 years ago

Howdy,The current set up I'm looking at is an OLTP production system running Oracle 19.20 (4 instance RAC) with active data guard. This system is seeding a data warehouse running Oracle 19.20 by way of Oracle GoldenGate via an integrated extract. At present th...
10 days ago5 weeks ago

hiI have a Partitioned(List) table by a VERSION_ID, which has around 15 million per partition. We have daily partitioned ID created bulk insert for 15 Million rows with 500 columns and then have 10 updates(MERGE UPDATE) for multiple columns from multiple oth...
10 days ago2 weeks ago