Tom Kyte

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

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

Timestamp validation against current timestamp

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

Second run of calling webservice using UTL_HTTP fails with ORA-12535: TNS:operation timed out

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

Generate version number

Thu, 2020-04-02 11:06
How to Generate version Number using oracle SQL like rownum?? Need Result Like this <b>0.7,0.8,0.9,1.0,1.1,1.2</b> upto 4.5
Categories: DBA Blogs

VM username and password

Thu, 2020-04-02 11:06
I require password and username for oracle db developer virtual machine for training purpose
Categories: DBA Blogs

Database Link Issues: Adding schema name raises ORA-02002: error while writing to audit trail ORA-00942

Thu, 2020-04-02 11:06
I have a database link that connects to a databases that is running 11g (11.2.0.4.0). The database it is created in was recently upgraded to 19c. After the upgrade, I can no longer access remote tables using fully qualified table names. Prior ...
Categories: DBA Blogs

Plain SQL text on cloud platform - SQL Injection and Data security standards

Wed, 2020-04-01 16:46
Hello TOM, I need to know if query through plain SQL text is accepted on cloud platform from data security standards perspective. How about SQL injection bugs/security risk for on cloud platform? Plain sql (like exec reporting_view_generato or s...
Categories: DBA Blogs

Analytic Functions Drawbacks

Tue, 2020-03-31 04:06
Hi Tom, Analytic functions are really cool, and I can see great benefits from using it. Despite its benefits, does Analytics Functions has any drawbacks, like performance issues, or any details one should be aware of when choosing to use analytics...
Categories: DBA Blogs

500 internal server error

Tue, 2020-03-31 04:06
We have an application in Oracle APEX where we do not have a large database and the number of pages used in the application would be max 250. However, there is a 500 Internal Server error that we are encountering since the last 3-4 days and we have n...
Categories: DBA Blogs

What happens when there is no space in 1 diskgroup in ASM?

Tue, 2020-03-31 04:06
Hi, We have DB that is using ASM with normal redundancy. The space consumption is really high. There was an occasion when almost 1 TB space was consumed in a month. We have been adding disks when there the remaining space gets really low. Now, we ...
Categories: DBA Blogs

OGG-02030 Failed to set logmining server parameters back to default val

Tue, 2020-03-31 04:06
I`ve try to start integrated Extract: <code>REGISTER EXTRACT EXTR_R DATABASE ADD EXTRACT EXTR_R, INTEGRATED TRANLOG, begin now ADD EXTTRAIL ./dirdat/lt, EXTRACT EXTR_R START EXTRACT EXTR_R</code> with param file: <code>Extract EXTR_R USERIDA...
Categories: DBA Blogs

Uploading files in a Rest webservice using PlSql UTL_HTTP

Tue, 2020-03-31 04:06
Hi, I'm calling REST web services using PLSQL UTL_HTTP package, in JSON, with no problems. However, now i need to invoke a WS but attaching a file. I can do it with Postman in ?form-data? mode. In PLSQL, I've tried the same thing in the...
Categories: DBA Blogs

Distributed and in-doubt transactions

Tue, 2020-03-31 04:06
Hello Ask Tom, Team. I am struggling with distributed transactions. Oracle RAC 18c (18.6) and .NET app. I want to know a few things: The RECO background process of an Oracle Database instance automatically resolves failures involving distri...
Categories: DBA Blogs

Paginated queries

Mon, 2020-03-30 09:46
Bello, Ask Tom Team. I need to build a report that connects to a 18c Oracle database. There are big tables and I need to paginate the results. I want to show 50 rows per page in the report. I have read about Fetch, Offset features since Ora...
Categories: DBA Blogs

Index Rebuild for just 1 partition

Mon, 2020-03-30 09:46
Hi, We have partitions in our table. We want to build index for just one partition. If we do that, then does it affects the application? One time we got an error like index in unusable state. First we create index in unusable state like: <code>C...
Categories: DBA Blogs

Pages