Tom Kyte

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...

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)

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...

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...

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...

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...

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...

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...

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.

How can I make a text field bring the email of the person logged in?

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...

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

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...

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...

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...

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...

I want to fetch data from below table. Table Name: Insight <code>Id | Name | JSON_DATA ----+------------+------------------------------------------------------------- 1 | Sitansu. | {"country_codes": ["IND"], "regions": ["ASIA"]...

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 ...

Hello, I am a newbie developing an app on APEX 19.2. I have a table with a field <b>START_DATE</b> of data type <i>TIMESTAMP WITH LOCAL TIME ZONE</i>. I also have a form with this field, for which I have specified <b>Identification Type</b> as Da...

Hi Tom, Please help me in addressing this issue. I am using the below procedure to call HTTPS wsdl, this works fine for the first time when calling this procedure on SQL prompt logging into DB server(AIX) via Putty. But fails when I try to ex...