Tom Kyte

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

Oracle 11g select query with Json field

3 hours 43 min ago
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?

3 hours 43 min 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 ...
Categories: DBA Blogs

Timestamp validation against current timestamp

3 hours 43 min ago
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

3 hours 43 min ago
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

3 hours 43 min ago
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

3 hours 43 min ago
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

3 hours 43 min ago
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

No data found extracting information from xml

Mon, 2020-03-30 09:46
Why can't you find data in an XML when I have proof of its existence?
Categories: DBA Blogs

Combine create and insert with if-then or case-when in sql?

Mon, 2020-03-30 09:46
Hello people, I would like to ask for your help with a simple issue. I am srry if this is too common, but for me it is not easy at all: I have a table like this - p.sometable: <code> ID AMOUNT YEAR cusomter1 42476281.61 ...
Categories: DBA Blogs

UTL_FILE write and User permission in Unix directory

Mon, 2020-03-30 09:46
I am using UTL_FILE.FOPEN('Unix_Directory_path','FileName.txt','w') in my Pl/Sql package and the file is getting written successfully but the User and permission are different than the file generated using SPOOL, both are using the same batch file in...
Categories: DBA Blogs

ADD_MONTHS Function returning last day of the month

Mon, 2020-03-30 09:46
The question I have is regarding the ADD_MONTHS function. The live sql link for the test case is as below:- https://livesql.oracle.com/apex/livesql/s/JT1FDGOHXMRWN3LG94GEYLMPJ If we have a look at this link it has 3 components:- 1. A function ...
Categories: DBA Blogs

Pages