DBA Blogs

Complete refresh single partition of MV over DB link?

Tom Kyte - Tue, 2017-06-13 13:06
We use materialized views to replicate tables between instances. We'd like to increase performance of loads on the master side by TRUNCATEing/INSERTing data to specific partitions as needed. On the remote side how can we limit the complete refresh to...
Categories: DBA Blogs

Calling a web service (WSDL) through Oracle Procedure/Function

Tom Kyte - Tue, 2017-06-13 13:06
Hello Experts, We have a requirement to call a web service through Oracle Store procedure/Function? Can we get any example related to that? We have to call web service : http://10.98.171.13:7003/soa-infra/services/default/ManageQuoteTaskProc...
Categories: DBA Blogs

where to download personal edition for windows 12.1.0.2

Tom Kyte - Tue, 2017-06-13 13:06
I have downloaded latest available 12c 12.1.0.2 Enterprise Edition for Windows. I get to the screen to select which Edition of Oracle to install and installer GUI does not allow any changes ( it remains stuck on Enterprise edtion ). How does one ...
Categories: DBA Blogs

Removing deadlock

Tom Kyte - Tue, 2017-06-13 13:06
Hi Tom, How can I clear deadlock without killing a session? thanks in advance. john
Categories: DBA Blogs

Implementing OAuth in Oracle JET Applications

OAuth is a security protocol that allows applications(clients) to authorize them for secure API access. Your application registers itself with an API and gets some information describing the...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Rows to Columns Concatenating Values

Tom Kyte - Mon, 2017-06-12 18:46
Hi, <code>Seq_num ITEM_CODE ATTRIBUTE_NAME ATTRIBUTE_VALUE LAST_MODIFIED ==================================================================================================================== 25521604 "HTC-UA-BUNDLE" "Alkaline_Battery_Count" 4...
Categories: DBA Blogs

Your actual view on IT Architecture for where to put the logics: inside or outside the database

Tom Kyte - Mon, 2017-06-12 18:46
Hi Tom and team This is the first question ever I am posting here, until now I was using Asktom as a silent reader only - and I want to say thank You a thousand times to keep this site up for so long, helping many people to find explanations and s...
Categories: DBA Blogs

Reverse Key

Tom Kyte - Mon, 2017-06-12 18:46
Tom, I have many primary keys that are sequences. Thinking of using reverse keys. How do I change the index created by the primary key? Rebuild as a reverse key? Thanks. Keith Cutler More info: Reading through the books I received wi...
Categories: DBA Blogs

data retention from 68 table and show it

Tom Kyte - Mon, 2017-06-12 18:46
Hi Tom I have one requirement please let me know the solution Requirement: ============ I have 68 table names that I get from user_tab_columns using some conditions and I achieve it easily But the challenge is I want to show all the co...
Categories: DBA Blogs

MView fast refresh - snapshot to old

Tom Kyte - Mon, 2017-06-12 18:46
Hi, When executing fast refresh over DbLink on MView "snapshot to old" error is returned. Refresh is executed at database DB_MV: <code>dbms_mview.refresh( list => 'MV_TABLE_NAME');</code> Master table is located on DB_MASTER At execut...
Categories: DBA Blogs

Table creation script on a Select statement take longer than Select Statement time

Tom Kyte - Mon, 2017-06-12 18:46
Hi, I have a Select Statement completing in 20 minutes, but when I try to create a Table with the Select statement(more than 10M Records) it takes more than 2 hours to complete. I have ti use the Table in a PL/SQL program for Data manipulation. I ...
Categories: DBA Blogs

Log Buffer #513: A Carnival of the Vanities for DBAs

Pythian Group - Mon, 2017-06-12 08:57

This Log Buffer Edition includes blog posts from Oracle, SQL Server and MySQL.

Oracle:

In 12.2 you can: Convert a simple table to partitioned with multi-column automatic list partitions, partially indexed, with read only segments, filtering out unwanted data, online in one operation.

12c How to UN Expire Password for CDB Users

rman auxiliary (for duplicate)

How long will Oracle APEX remain an included feature of the Oracle Database?

How to easily delete files in the Oracle Cloud using CloudBerry Explorer

SQL Server:

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

How to setup Machine Learning Services in SQL Server 2017 CTP2

The OUTPUT Clause for the MERGE Statements

Simple script to backup all SQL Server databases

Working with Windows Containers and Docker: Into your Stride

MySQL:

MySQL on Docker: Running Galera Cluster on Kubernetes

Summary of recent performance tests for MySQL 5.6, 5.7 and 8

A Quick Look at Parallel Rsync and How it Can Save a System Hours

Docker, MySQL and Experience in Containers

HopsFS running on top of MySQL Cluster 7.5 wins IEEE Scale Challenge 2017

Categories: DBA Blogs

query for report generation in oracle 11g

Tom Kyte - Sun, 2017-06-11 06:06
how to generate a month wise,year wise report for banking?
Categories: DBA Blogs

How solve incident Error?

Tom Kyte - Sun, 2017-06-11 06:06
I search incident error suddenly and my database immediate down and show error message client connect could not hand-off. And I see alter log file and search on internet also but i can't able to find information for first argument mention in the or...
Categories: DBA Blogs

Unable to install Oracle 11g on Windows 10

Tom Kyte - Sun, 2017-06-11 06:06
Hello Oracle Experts, I am unable to install Oracle 11g on Windows 10 (64 Bit). Error Encountered : ORA 12631 UserName retrieval failed Database instance is created but the .DBF files are not created including the control files. Please note...
Categories: DBA Blogs

Why I can't get the user role when I logon the database?

Tom Kyte - Sun, 2017-06-11 06:06
Hello everyone I'm trying to solve a little problem that I have everytime I connect as another user on the database. First of all let me explain what I want to do. When the user connect on the database I want to know his role and just show on o...
Categories: DBA Blogs

Oracle 12C Database Running on 11G Grid/ASM

Tom Kyte - Sun, 2017-06-11 06:06
Hello all, I have a client who is currently running on an 11.2.0.3 DB and Grid/ASM. They want me to stand up a new database as 12.2.0.1 to export into while the current database is still running. I've gone over the documentation for upgrading but ...
Categories: DBA Blogs

Unable to run the job which is already created

Tom Kyte - Fri, 2017-06-09 17:06
Hi Tom, I need your help in fixing this. I have created the job which should call a shell script when triggered. But unfortunately I am getting error as test_job must be a job. Below are the scripts which I have used to create the job. Let ...
Categories: DBA Blogs

Query to get the count of records every two hours

Tom Kyte - Fri, 2017-06-09 17:06
I have a record creation time stamp in my table . I need to write a query to get the count of records every two hours between two specific dates. Starting from 1st January 2017 till today. I have the following table USER USER_ID CREATION_D...
Categories: DBA Blogs

Failed to CREATE tablespace or pfile to NFS (or NAS who was believed correctly configured) on Windows

Tom Kyte - Thu, 2017-06-08 22:46
Hi Team, We plan to deploy 2 Oracle labs whose datafiles are resident on NFS (or NAS). And we met a strange situation about CREATING pfile/datafile to NFS(or NAS) on Windows Server: 1) on Windows, we <u>failed to CREATE pfile(or tablespace) to NFS(...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs