DBA Blogs

Using Oracle Big Data Lite Virtual Machine with Ravello trial - update

This is an update of a previous blog post. Since Ravello trial now supports 16GB RAM per VM, the process is much simpler.  Big Data Lite Virtual Machine is the most straight-forward way to...

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

Apex 5.1 Application Builder Overview

Flavio Casetta - Fri, 2017-01-20 04:00
Categories: DBA Blogs

Links for 2017-01-19 [del.icio.us]

Categories: DBA Blogs

Fetch Ref cursor to another ref cursor

Tom Kyte - Thu, 2017-01-19 12:26
Hi, First of all Thank you Gurus! for your time and effort to solve user issues. I have a requirement where I have to consume first row of the big query result set and fetch the rest of the result into a refcursor(for some reason I can't change...
Categories: DBA Blogs

Is it known error with timestamp field update in a compound trigger internal procedure?

Tom Kyte - Thu, 2017-01-19 12:26
I have faced with the error: "ORA-03113: end-of-file on communication channel Process ID: 3942 Session ID: 13 Serial number: 58997" and after that the session is disconnected: "ORA-03114: not connected to ORACLE". In LiveSQL it caused "Intern...
Categories: DBA Blogs

Fetch records in multiple variables

Tom Kyte - Thu, 2017-01-19 12:26
Hi Chris/Connor, I have 3 varaibles in procedure - V_CLIENT_ACCESS_TO_CSP VARCHAR2(100); V_CLIENT_ACCESS_TO_OCA VARCHAR2(100); V_CLIENT_ACCESS_TO_GCMS VARCHAR2(100); I need to fetch the values into these variables using below query - S...
Categories: DBA Blogs

Building a complex logic for grouping the day of the week and time

Tom Kyte - Thu, 2017-01-19 12:26
Hi Tom and Team, Good Afternoon. I have a Location table contains below data in my DB. LOCATION_I LOCATION_SCHED_DAY LOCATION_SCHED_HOUR_FROM LOCATION_SCHED_HOUR_TO NUMERIC_DAY 1528011 MONDAY 9:00 ...
Categories: DBA Blogs

Is there a way to create local hash partition index?

Tom Kyte - Thu, 2017-01-19 12:26
Is there a way to create local hash partition index? I can create global hash partition index, but local does not work.
Categories: DBA Blogs

Is it possible to reuse the same Connection (established from an external JDBC client) within a java stored procedure?

Tom Kyte - Thu, 2017-01-19 12:26
Title: Is it possible to reuse the same Connection (established from an external JDBC client) within a java stored procedure? My application design is as follows Java client (using standard JDBC/Callable statement ) calls > Oracle Function , ...
Categories: DBA Blogs

Difference BW 11G & 12C

Tom Kyte - Thu, 2017-01-19 12:26
Hi, I would like to know the Difference between 11g and 12c, and also Iwanna know which feature makes 12C Cloud and not 11G?
Categories: DBA Blogs

ORA-00904 INVALID IDENTIFIER IN MERGE THOUGH COLUMN IS ALIASED

Tom Kyte - Thu, 2017-01-19 12:26
Hi Tom, This is my first here. Really getting fuzzy about this. This is my sql wherein i want to apply the updates on the table <b>ru_receipt_updates</b> to the rows of <b>trans_hdr</b> table located on another server. Though the columns on th...
Categories: DBA Blogs

Pipelined Functions

Tom Kyte - Thu, 2017-01-19 12:26
Hi Team, I am returning a data set to an interface via a ref cursor using the below code:- OPEN pRefCur FOR SELECT ct.ct_value1 AS A, ct.ct_value2 AS B, getArray(ct.ct_value4, ct.ct_value12) AS C, getArray(ct.ct_value5...
Categories: DBA Blogs

Getting ORA-31626: job does not exist and ORA-06512 from my export data pump job

Tom Kyte - Thu, 2017-01-19 12:26
Hello Tom, Please, I need a big help. I have a job scheduled in Enterprise Manager 12c. This job do a full export, but two days ago I started to get the error below: ERROR at line 1: ORA-31626: job does not exist ORA-06512: at "SYS.DBMS_SY...
Categories: DBA Blogs

Issue with OR expanding and subquery

Tom Kyte - Wed, 2017-01-18 18:06
<code>Hi Tom I have an issue with OR expansion. Using literals, the OR conditions are expanded neatly. However, I am unable to make the optimizer come up with a plan that uses the index, when I use a subquery. drop table t1; drop table t2; ...
Categories: DBA Blogs

Degree of Parallelism (DOP) of Index

Tom Kyte - Wed, 2017-01-18 18:06
Hi Team, As part of a daily housekeeping practice I executed the below commands for an index rebuilding activity : ALTER INDEX DLM_RAMBO_ILQ_PK REBUILD ONLINE PARALLEL 12 NOLOGGING; ALTER INDEX RAMBO_ILQ_IDX2 REBUILD ONLINE PARALLEL 12 N...
Categories: DBA Blogs

Rename index with DBMS_METADATA

Tom Kyte - Wed, 2017-01-18 18:06
Hi, I am trying to change the name of an index using DBMS_METADATA ,but it seemingly does not works on the index name. Please let me know if I am doing something wrong. Best Regards, Manas drop table a; create table a (a clob); drop...
Categories: DBA Blogs

Refreshing SQL Profiles

Tom Kyte - Wed, 2017-01-18 18:06
Recently I had a performance issue where the solution was to drop the exising SQL profile. SQL profiles contain "auxiliary statistics specific to a SQL statement". These can of course get stale if the data in the tables referenced by the statement ...
Categories: DBA Blogs

Security lockdown - revoke all privileges from PUBLIC

Tom Kyte - Wed, 2017-01-18 18:06
Hi guys, I'm working on a system which requires good security, and therefore must operate on a minimum privilege basis. Naturally I've read the CIS recommendations and applied them, as well as DISA STIG, and disabled all default accounts etc. ...
Categories: DBA Blogs

spool output columns in seperate csv column - call from SQL developer

Tom Kyte - Wed, 2017-01-18 18:06
additional question to the question from yesterday : : http://asktom.oracle.com/pls/apex/f?p=100:12:0::NO::P12_ORIG,P12_PREV_PAGE,P12_QUESTION_ID:Y,1,9532893700346545049 I'm using the SQL developer for starting scripts. additional question: ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs