Tom Kyte

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

SQL questions for improving skills

Sun, 2016-07-10 10:26
Hi Tom, My question is little weird. Where can i find good SQL questions (scenarios) for practice. I tried google but did not find good list. Can you please suggest any website or book/magazine? Thanks, DP
Categories: DBA Blogs

How to register a "service" with a listener without using local_listener

Sun, 2016-07-10 10:26
Hello I create a service like so: exec dbms_service.create_service('MYSERVICE','MYSERVICE'); exec dbms_service.start_service('MYSERVICE'); Then, I add the service in the listener.ora sid_list parameter like so: SID_LIST_LISTENER = (SI...
Categories: DBA Blogs

Errors during iPod touch iOS update

Fri, 2016-07-08 21:46
My IPod touch iOS update keeps saying that an error has accured and when i tap on settings it asks me to update it! I'm trying to update to iOS 8.14. Please help!!
Categories: DBA Blogs

Revert 12.1.0.2.0 CDB to stand alone non-CDB with same product version

Fri, 2016-07-08 21:46
Hello Team, We have installed Oracle 12c version 12.1.0.2.0 to be pluggable. However, many scripts would require the stand alone non pluggable mode of oracle. Can you please guide to convert CDB to non-CDB without downgrading to older versions. ...
Categories: DBA Blogs

datapump export - ORA-39126 / ORA-12838

Fri, 2016-07-08 21:46
HTP0#>expdp system/***** full=y DIRECTORY=data_pump_dir4bos dumpfile=EZTAG_UiAT.dmp logfile=myfullexp.log job_name=eztag_uat_ex5 Export: Release 11.2.0.4.0 - Production on Fri Jul 8 06:46:18 2016 Copyright (c) 1982, 2011, Oracle and/or its affi...
Categories: DBA Blogs

How to get database name in oracle db node js

Fri, 2016-07-08 21:46
<b>How to get database name in oracle db in node js without query using connection object</b> <code> var oracledb = require('oracledb'); oracledb.getConnection( { user: 'c##root', password: 'root', connectString: ...
Categories: DBA Blogs

How to load a xlsx file in to a table

Fri, 2016-07-08 21:46
I have a xlsx file ,and i am using sql loader in toad to load in to table.I also have created control file for the same. the file content is given below: ID Name Employee name Designation Status 0000700 John,Sam John sam (000070) Sr.Developer, ...
Categories: DBA Blogs

GATHER_TABLE_STATS difference between 11g and 12c (DBMS_STATS.flush_database_monitoring_info)

Fri, 2016-07-08 03:26
Hi Tom, So we are looking to be refreshing stats when the stats become stale while a lot of DML is happening on a table, and were testing how to handle this. FLUSH_DATABASE_MONITORING_INFO is the right procedure as it updates the dictionary. We ...
Categories: DBA Blogs

Anyway to Access Data in a Table That Has Been Made Invalid By Dropping an XMLSchema

Fri, 2016-07-08 03:26
Is here anyway to make a table valid again if it has an XMLType column with an XMLSchema associated it which has been deleted via dbms_xmlschema.deleteSchema with a DELETE_INVALIDATE parameter? I cannot even successfully drop the XMLType column from...
Categories: DBA Blogs

LEFT JOIN on nested table and TABLE function: unexpected results

Fri, 2016-07-08 03:26
Hi! This is my first question here, so don't hesitate to tell me if I am unclear or if key information is missing. I have been getting unexpected results while trying a LEFT JOIN on a nested table. Here's my tables: <code>CREATE OR REPLACE ...
Categories: DBA Blogs

utl_http results to ORA-12541: TNS:no listener

Fri, 2016-07-08 03:26
Hi, I have 11g DB and I have url below that I can open in the browser displaying pdf. This is pdf report generated from Jasper server. http://serv-ora11g:8081/jasperserver/flow.html?_flowId=viewReportFlow&j_username=jasperadmin&j_password=jaspe...
Categories: DBA Blogs

utl_htp is begin_request is resulting to ORA-29263: HTTP protocol error

Fri, 2016-07-08 03:26
Hi, I have URL that I can access with a browser and this displays the PDF http://serv-ora11g:8081/jasperserver/flow.html?_flowId=viewReportFlow&j_username=jasperadmin&j_password=jasperadmin&reportUnit=/KVS/Collection/col1190&output=pdf I c...
Categories: DBA Blogs

Cross Platform "Endian" Conversion from Solaris to Linux Intel-Based Exadata -- Mounting NFS to Exadata Machine

Fri, 2016-07-08 03:26
Hi, Is it possible for a Solaris NFS to be mounted on a Linux Intel-Based Exadata machine? This approach seems (at least to me) to be alluded to in this section of Oracle Database Backup and User's Guide: https://docs.oracle.com/cd/E11882_01/back...
Categories: DBA Blogs

Creating tables (maybe)

Fri, 2016-07-08 03:26
How to create a table for this one. AAA BBB CCC RED 1 2 3 BLUE 4 5 6 GREEN 7 8 9 I tried on SQL DEVELOPER.It's gave me an error. And converted into an out put like.. RED BLUE GREEN AAA 1 4 ...
Categories: DBA Blogs

cursor for loop

Fri, 2016-07-08 03:26
Hi, I have a cursor for loop which does some calculation in the cursor query. With in the loop I have insert with commit for every iteration. There are not more statement apart from INSERT & COMMIT inside the loop. Example: DECLARE cursor...
Categories: DBA Blogs

Dba vs Apps DBA

Fri, 2016-07-08 03:26
What is different between Oracle DBA and Oracle apps DBA? I so many websites where some of them used term Oracle DBA and some of them Oracle apps DBA?
Categories: DBA Blogs

Undo Table space

Fri, 2016-07-08 03:26
Hi Tom, Following are the scenarios and please let me know what will happen in the listed scenarios : 1. I have a Undo table space with least size, i do a deleting of records in a table which is huge in size(a size which undo tablespace ca...
Categories: DBA Blogs

Website validation using regexp_like.

Thu, 2016-07-07 09:06
Hi, Could you please help to get website validation query using regexp_like. e.g. www.google.com https//:www.google.com both should get validated. Thanks in advance.
Categories: DBA Blogs

Datatype issue.

Thu, 2016-07-07 09:06
Hi all, I have an issue with column datatype.Can you please look at this issue. I have two tables emp1 and emp2 with empno column in both tables in table emp1 column empno is nvarchar2 and in table emp2 column empno is number datatype I am tryin...
Categories: DBA Blogs

how to debug the SQL logic execution ?

Thu, 2016-07-07 09:06
AskTom, I have a question about the 'SQL logic execution': Can Oracle Database log the logic of the SQL execution ? (which condition of the WHERE clause failed ?) example: select 1 from Dual WHERE 1 = 1 AND 1 = 1 + 1 --line 5 ; C...
Categories: DBA Blogs

Pages