Tom Kyte

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

Oracle Reports 11g showing junk characters fron nvarchar2 column stored in Oracle database 12c

Tue, 2018-04-10 00:46
Dear Sir, Our Oracle 12c database and Weblogic 11g are hosted in SunOS 5.11 11.2 environment. The output from nls_database_parameters is given below: NLS_RDBMS_VERSION 12.1.0.2.0 NLS_NCHAR_CONV_EXCP ...
Categories: DBA Blogs

Export all table in a schema into csv files

Tue, 2018-04-10 00:46
Hello, I want to export all table in a schema into csv files. I want that the csv files having the same name as the tables. I have following SQLPlus Code: <code>connect username/password set serveroutput on; set lines 80 set head off...
Categories: DBA Blogs

Problem with large tables and LIKE query

Tue, 2018-04-10 00:46
Hi, we have an application that uses Oracle database to hold company data. One of it's table, called PWORKSPACEOBJECT holds all 'displayable' objects in GUI client. Most of the time users are searching for some data only by typing *some text* ...
Categories: DBA Blogs

ORACLE SQL Question sum credits and debits

Mon, 2018-04-09 06:26
I have a transaction table called TRANSACTION DETAIL.... TRANSACTION DETAIL CNN TYPE AMT DATE C1 C 1000 10-Jan-16 C2 C 1200 10-Jan-16 C3 C 2000 11-Jan-16 C4 D 1000 12-Jan-16 C3 D...
Categories: DBA Blogs

Unable to get expdp/impdp utility run successfully, getting ORA-39002: invalid operation ORA-39070: Unable to open the log file.

Mon, 2018-04-09 06:26
Dear Tom, very Good day to you. I am trying to use expdp/impdp utility to backup tables,schema etc and it is not executing successfully. The followings are what I am getting in regard to errors <code>ORA-39002: invalid operation ORA-39070: Un...
Categories: DBA Blogs

Where is the web address of the "Partition" introduction details on AskTom ?

Mon, 2018-04-09 06:26
Hello, AskTom Team. A few months ago, I have glanced a link about "<b><i>Partition</i></b>" introduction details. But now I haven't seen it. Please tell me what web address is. Best Regards Quanwen Zhao
Categories: DBA Blogs

Why does the year to month interval return an erroneous value compared to the day to second interval?

Mon, 2018-04-09 06:26
Hi Tom, While I was working through an example in a book, I ran into a problem I couldn't figure out. It involves two scripts and its results which are provided below: Script 1: <code> SELECT loan_id,due_date, tool_out_date, NUMTOYMINTERVAL...
Categories: DBA Blogs

Error: ORA-06533: Subscript beyond count

Mon, 2018-04-09 06:26
Please help me in editing the below Pl/SQL code: <code>create or replace Function user_score_scurve (scurve_in varchar2, inpt IN number) RETURN number IS params_number number; TYPE type_params IS table OF number; Params ...
Categories: DBA Blogs

Split 1 row into 2 rows based on column values without UNION

Sun, 2018-04-08 12:06
Hi, I will be glad if you could help me to know if the below can be achieved without using UNION I want to split a row into 2 based on a column value create table xx_test_split ( id number, amount number, discount_amount number, currency ...
Categories: DBA Blogs

Oracle Query CPU Utilization

Sun, 2018-04-08 12:06
I am looking at instance sizing and have some questions on how Oracle uses CPU cores. Assume this is a Standard Edition database so no queries will be running in parallel mode. Assuming system background processes are negligible: *) When a single ...
Categories: DBA Blogs

DBA career advice

Sun, 2018-04-08 12:06
I work in mid-size company in India. I'm Oracle Developer last 1 year. I want to become DBA. How to become professional Oracle DBA like Core DBA or Oracle Application DBA in INDIA? Which book should be read for me? What should be work do by me ...
Categories: DBA Blogs

How can i change my sys password

Sun, 2018-04-08 12:06
How can i change my sys password
Categories: DBA Blogs

How to pass a bind variable inside string inside exexute immediate string?

Fri, 2018-04-06 23:26
The benefits of using bind variables inside dynamic SQL statements have been discussed many times here. I have dynamic SQl statement like this where "id" is a pls_integer: <code>---- ENSURE THAT BULK PROCESSING IS DISABLED ---- b...
Categories: DBA Blogs

Custom pivot with count and sum summaries and horizontal sorting

Fri, 2018-04-06 23:26
Hello Team, Good Day! I have linked livesql script for data creation. Data basically looks like this. <code> 1 symnum NUMBER 22 2 symname VARCHAR2 100 3 remnum NUMBER 22 4 remname VARCHAR2 32 5 grade NUMBER 22 </code> ...
Categories: DBA Blogs

Move data within partitions

Fri, 2018-04-06 23:26
Hi Tom. I'm working on a database with a partitioned table (by date). There are weekly partitions plus a edge partition where values higher than a certain value are stored. The last partition has never been used and is empty. Counting recor...
Categories: DBA Blogs

Soundex

Fri, 2018-04-06 05:06
Buen dia Connor, espero estes bien. Estoy realizando una practica e investigacion sobre chatbots, en mi algoritmo estoy buscando por dos metodos el parseo o proceso de las palabras para hacer el NLP y darles sentido, se que existe la funcion soun...
Categories: DBA Blogs

How to start a job on two conditions with DBMS_SCHEDULER : another job has finished and we are on monday ?

Fri, 2018-04-06 05:06
Hi, I have a job (JOB1) which runs every night at 0:30. I have another job (JOB2) which must be run after JOB1 completes but only once a week, on monday. For the moment, I manage this by starting JOB2 on monday at 4:00 because most of the time J...
Categories: DBA Blogs

To generate list of unique Random Numbers based on the number count required

Mon, 2018-04-02 09:46
Hi, My requirement is to generate the list of random numbers based on the total count provided. for instance, if total count is 100, i have to generate 100 unique random numbers. Below is the sample code i used. Could you please check and let me ...
Categories: DBA Blogs

Group by is failing on remote database query

Mon, 2018-04-02 09:46
Hello, My issue is the good old ORA02070 and I've found different workarounds but none of them fits my particular problem. It happens when I try to do a group by on remote database query. I need to compare data between the local and remote dat...
Categories: DBA Blogs

DB stuck at check point not complete.

Mon, 2018-04-02 09:46
Our DB stuck and check poin not complete. As per the logs DBA says.. ELECT for update running on the db causing the high number of block changes and caused the issue After this issue we are unable to generate ASH or AWR for that time. How to iden...
Categories: DBA Blogs

Pages