Tom Kyte

Subscribe to Tom Kyte feed Tom Kyte
These are the most recently asked questions on Ask Tom
Updated: 15 hours 6 min ago

After logon Trigger

Wed, 2020-04-08 13:46
Tom, What I am trying to accomplish is basically, to monotor any one (mainly DBAs) who connects to the database using "system". I know that, you have advocated to use "audit connect by system" but, I want to have more flexibility (for example,...
Categories: DBA Blogs

Kindly help with Data Integration Related Terms in below

Wed, 2020-04-08 13:46
Hello TOM, May I know what we mean by below terms with examples: Data Outages Siloed Data Data Automation Data Profiling Push Down Data movement Thanks Rajneesh
Categories: DBA Blogs

MemOptimized Rowstore

Tue, 2020-04-07 19:26
I tried to create a table learning from with a tutorial <code>create table key_val_pair( id number constraint id_pk primary key, key_val varchar2(100), key_name varchar2(100)) segment creation immediate memoptimize for read;</code> it is sh...
Categories: DBA Blogs

database authentication

Tue, 2020-04-07 19:26
could u please explain the difference between os authentication and database authentication and how it is done, briefly...i have read it but unable to understand it completely(w.r.t oracle 9i)
Categories: DBA Blogs

Spool sql query output in single excel file but in two separate work sheets

Tue, 2020-04-07 19:26
I have written shell script which connect to Oracle DB (11g) and spool output into excel (.csv / .xls). This works perfectly fine to fetch data in single excel file. I want to enhance my script which will connect to DB and execute 2 different querie...
Categories: DBA Blogs

GoldenGate 19c error - ORA-12549: TNS:operating system resource quota exceeded

Tue, 2020-04-07 19:26
I`ve tried to start two Extract. One is started and works. But when I try start one more Extract I get error: <code> 2020-04-06T15:27:30.549+0300 ERROR OGG-02615 Oracle GoldenGate Capture for Oracle, e_rf.prm: Login to the database as user GGA...
Categories: DBA Blogs

How to print ref cursor and nested table as out parameter in procedure using anonymous

Tue, 2020-04-07 19:26
Hi Sir, I want to print all out parameters using sql developer and anonymous block. Please refer below scripts. <code>CREATE TABLE EMP ( empno number(4,0) not null, ename varchar2(10 byte), job varchar2(9 byte), mgr number(4,0), hiredate da...
Categories: DBA Blogs

Common table expression using sample() referenced more than once does not produce correct results.

Mon, 2020-04-06 06:46
Hi Here is a very much simplified example of real world situation. <code> drop table lh_a; create table lh_a as (select level nro, cast(' ' as char(100)) dummy from dual connect by level < 1000000); create unique index lh_a_ind on l...
Categories: DBA Blogs

Parsing out a field in MS Access that is CSV (JSON) data

Mon, 2020-04-06 06:46
I have a CSV data file that I load into MS Access. No problem doing that. I?ve got it all loaded. My issue is that one of the records in the file contains a field that contains CSV data (JSON data) which is line item invoice data (ProductData) a...
Categories: DBA Blogs

Unable to connect to database xe using sql developer

Mon, 2020-04-06 06:46
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 u...
Categories: DBA Blogs

Number of connections and sessions in a given time

Mon, 2020-04-06 06:46
Hello, Ask Tom Team. I would like to know the number of sessions and connections to an Oracle database in a given time. Thanks in advanced.
Categories: DBA Blogs

Application Express Form

Mon, 2020-04-06 06:46
How can I make a text field bring the email of the person logged in?
Categories: DBA Blogs

SAAS Vs IAAS Vs PAAS for DBCS related query

Mon, 2020-04-06 06:46
Hello TOM, I need to use DBCS for implementing Reporting Solution on cloud. Hence need to understand SAAS, IAAS and PAAS platform for cloud. Can you please help me to understand in simple layman terms with examples of all 3. Thanks, Rajnee...
Categories: DBA Blogs

Using Materialized View as ETL option

Mon, 2020-04-06 06:46
Hello TOM, Any comment regarding Using Materialized View as ETL option to populate data from OLTP to OLAP? Pros and Cons will be useful. Thanks, Rajneesh
Categories: DBA Blogs

Online Table move to different table space.

Fri, 2020-04-03 05:26
Team, we are on 18c and trying to move a table to a different table space, using the online move it got failed like this. <code>c##rajesh@PDB1> alter session set ddl_lock_timeout =300; Session altered. c##rajesh@PDB1> show parameter ddl_l...
Categories: DBA Blogs

Oracle 18c SQL Query Pagination

Fri, 2020-04-03 05:26
Hello, Ask Tom Team. I am building a report using Microsoft SQL Server Reporting Services connecting to an Oracle 18c database. This report will show lots of data. I need to paginate the results, showing 50 rows per page. 1. How can I do i...
Categories: DBA Blogs

Regarding Oracle Error ORA-26002 table has index defined upon it

Fri, 2020-04-03 05:26
Hi There, This is regarding the error ora-26002 which we are facing since few days. We have one table T1 which is having an index on one of the column. This table T1 is being loaded through informatica using bulk mode option. (Without droppi...
Categories: DBA Blogs

Adjust connections/sessions Oracle database

Fri, 2020-04-03 05:26
Hello, Ask Tom Team. I have a production database running for several months. These are my connection parameters in the client to connect to the database (RAC 18c). I am using a .NET app. Min Pool Size=1;Max Pool Size=60;Connection Lifetime=18...
Categories: DBA Blogs

Oracle 11g select query with Json field

Thu, 2020-04-02 11:06
I want to fetch data from below table. Table Name: Insight <code>Id | Name | JSON_DATA ----+------------+------------------------------------------------------------- 1 | Sitansu. | {"country_codes": ["IND"], "regions": ["ASIA"]...
Categories: DBA Blogs

How "ONLINE" is an "alter table move ONLINE" in 12.2 and beyond?

Thu, 2020-04-02 11:06
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 ...
Categories: DBA Blogs

Pages