Skip to Main Content

Questions

QuestionUpdatedAsked

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...
16 hours ago5 days 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...
17 hours ago6 days 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...
30 hours ago16.4 years 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...
30 hours ago1.3 years 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...
30 hours ago13.5 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...
31 hours 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...
31 hours 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...
31 hours ago3 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...
31 hours ago5 days ago

1. I have few number column with data type declared as Number, Number (5), Integer, Numeric(10). I know in few cases the maximum data is 2 digits and I see that is declared as Number(38)/ NUMBER / Numeric(30) /Integer if i don't declare as number(...
32 hours ago6 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

Here i am creating record type with reocrds emp and dept with following syntax<code>CREATE TYPE emp_dept_data IS RECORD(empno number(4),ENAME VARCHAR2(10),JOB VARCHAR2(9),HIREDATE DATE,SAL NUMBER(7,2),DNAME ...
4 days ago6 days ago

I would like to know if it is possible to configure the Oracle data format to also capture the timezone that date and time orginated. ...
5 days ago21.6 years 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...
6 days ago6 months 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...
6 days ago2 weeks ago

TomSuppose if a server is given to you , and you are asked to see if there is a database created( or in other words if a database exists in that server) or not, what is the quickest and what are the different ways in which you can find out( in both windows an...
7 days ago20.7 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...
8 days ago2 weeks ago

I doing full import of 10g export into 19c. export/import via user with exp_full_database privilege/imp_full_database have few questions? 1. is it safe to import full=y option. will it overwrite procedures with 10g version/duplicate data in system schema. ...
8 days ago2 weeks ago

ORDS Landing Page Shows "ok" For Apex And Sql Developer Instead of "GO" button. I can't access to apex workspace page.when i click on the "ok" it toke me to apage shwing "not found http status code :404 Impossible to meet the requirement with a database. Veri...
8 days ago2 weeks ago

Dear Tom,I'm trying to connect my pdb - pdb1, using tnsnames.ora. I have granted tom dba privs just for testing purpose. My database name/CDB name - TESTMy pdb name - pdb1<code>sqlplus tom/tom@pdb1ERROR:ORA-01017: invalid username/password; logon denied</code...
10 days ago3.5 years ago