Feed aggregator

Build Oracle APEX application that can run on Android based tabs without Internet having own LAN

Tom Kyte - 11 min 56 sec ago
hi, we have an oracle apex application running on our LAN, we want to use the same on Android based tabs. I'm a little confused how to go about it as we have no Internet access on our office PCs on which the app is running and same SOP will be appl...
Categories: DBA Blogs

Convert arbitrary length numbers from decimal to binary to decimal in PLSQL

Tom Kyte - 11 min 56 sec ago
Hi, We are storing a 100 digit length number in a varchar2 field in oracle database table column. In PLSQL code, we need to convert this 100 digit number to its binary equivalent (300+ digits), add some more digits to binary and then convert this b...
Categories: DBA Blogs

Converting Unique Index to Non-Unique

Tom Kyte - 11 min 56 sec ago
Hi, TOM! Some time ago I decided to change my unique index to non-unique because of new requirements. I googled a lot but didn't find anything about <b>convertation</b>. Though I found solutions like creating new nnon-unique index with extra cons...
Categories: DBA Blogs

BigQuery Materialized Views and Oracle Materialized Views

Pakistan's First Oracle Blog - Wed, 2020-04-08 18:33
One of the common ways of one-to-many replication setups in Oracle databases involve, on high level, having one master transaction database which holds the transactions, then a mview log is created on that table.

Then all the other reporting databases subscribe their respective materialized views (MViews) to this log table. These MViews remain in sync with the master log table through incremental refresh or through complete refresh. As long as it runs fine, it runs fine but when things break, it becomes ugly, and I mean ugly. The MViews at reporting databases could lag behind the master log due to network issue or if the master database goes down. Doing a complete refresh is also a nightmare and you have to do lots of purging and tinkering. The more subscribing MViews, the more hassle it is when things break.

BigQuery is Google's managed data warehousing service which now offers materialized views. If you have managed Oracle MViews, it brings you to tears when you learn that BigQuery MViews offers following:

Zero maintenance: A materialized view is recomputed in background once the base table has changed. All incremental data changes from the base tables are automatically added to the materialized views. No user inputs are required.

Always fresh: A materialized view is always consistent with the base table, including BigQuery streaming tables. If a base table is modified via update, merge, partition truncation, or partition expiration, BigQuery will invalidate the impacted portions of the materialized view and fully re-read the corresponding portion of the base table. For an unpartitioned materialized view, BigQuery will invalidate the entire materialized view and re-read the entire base table. For a partitioned materialized view, BigQuery will invalidate the affected partitions of the materialized view and re-read the entire corresponding partitions from the base table. Partitions that are append-only are not invalidated and are read in delta mode. In other words, there will never be a situation when querying a materialized view results in stale data.

Smart tuning: If a query or part of a query against the source table can instead be resolved by querying the materialized view, BigQuery will rewrite (reroute) the query to use the materialized view for better performance and/or efficiency.

In my initial testing, the things work like a charm and refresh takes at most couple of minutes. I will be posting some tests here very soon. But suffice is to say that delegating manaagement of Mview refresh to Google is reason enough to move to BigQuery.

Categories: DBA Blogs

Practical Oracle SQL Webinar by ACE Director Kim Berg Hansan

Gerger Consulting - Wed, 2020-04-08 14:26
ACE Director Kim Berg Hansen is the author of the book "Practical Oracle SQL, Mastering the Full Power of Oracle Database".

Kim Berg Hansen is known to present complicated SQL features in a very accessible way to developers so that they can apply these features in their daily work.

In this webinar, Kim will present several SQL techniques, taken from his new book Practical Oracle SQL, and show you how you can apply them in real life scenarios.

Kim will cover the following topics:
  • Tree Calculations with Recursion (Recursive subquery factoring)
  • Functions Defined Within SQL (Functions in the WITH clause)
  • Answering Top-N Questions (Analytic ranking functions)
  • Rolling Sums to Forecast Reaching Minimums (Analytic window clause, recursive subquery factoring, model clause)
  • Merging Date Ranges (Row pattern matching MATCH_RECOGNIZE)
Categories: Development

Kindly help with Data Integration Related Terms in below

Tom Kyte - Wed, 2020-04-08 13:46
Hello TOM, May I know what we mean by below terms with examples: Data Outages Siloed Data Data Automation Data Profiling Push Down Data movement Thanks Rajneesh
Categories: DBA Blogs

After logon Trigger

Tom Kyte - Wed, 2020-04-08 13:46
Tom, What I am trying to accomplish is basically, to monotor any one (mainly DBAs) who connects to the database using "system". I know that, you have advocated to use "audit connect by system" but, I want to have more flexibility (for example,...
Categories: DBA Blogs

Announcing: Integration Tools Update Course

Jim Marion - Tue, 2020-04-07 21:34

PeopleSoft Integration Tools is normally taught as a five-day introductory course designed to answer questions such as:

  • What is Integration Broker?
  • How do you configure it?
  • What are Service Operations?
  • How should I integrate with PeopleSoft?

But a lot of us already know the basics of Integration Broker. So last fall, we decided to add another course to our library: PeopleTools Integration Tools Update. This is a three-day class showing what's new with Integration Broker and covers topics such as:

  • Producing and Consuming REST,
  • Constructing Documents and understanding the role of Documents in integration,
  • Creating structured and unstructured JSON responses,
  • Understanding and implementing content negotiation,
  • Responding to REST verbs,
  • Using pre-built services such as Query Access Service,
  • Securing integration points.

As we integrate Chatbots and Cloud solutions with PeopleSoft, it is critical that we understand PeopleSoft's modern integration capabilities.

Our next class begins April 14, 2020. Register now to reserve your seat!

How to print ref cursor and nested table as out parameter in procedure using anonymous

Tom Kyte - Tue, 2020-04-07 19:26
Hi Sir, I want to print all out parameters using sql developer and anonymous block. Please refer below scripts. <code>CREATE TABLE EMP ( empno number(4,0) not null, ename varchar2(10 byte), job varchar2(9 byte), mgr number(4,0), hiredate da...
Categories: DBA Blogs

GoldenGate 19c error - ORA-12549: TNS:operating system resource quota exceeded

Tom Kyte - Tue, 2020-04-07 19:26
I`ve tried to start two Extract. One is started and works. But when I try start one more Extract I get error: <code> 2020-04-06T15:27:30.549+0300 ERROR OGG-02615 Oracle GoldenGate Capture for Oracle, e_rf.prm: Login to the database as user GGA...
Categories: DBA Blogs

Spool sql query output in single excel file but in two separate work sheets

Tom Kyte - Tue, 2020-04-07 19:26
I have written shell script which connect to Oracle DB (11g) and spool output into excel (.csv / .xls). This works perfectly fine to fetch data in single excel file. I want to enhance my script which will connect to DB and execute 2 different querie...
Categories: DBA Blogs

database authentication

Tom Kyte - Tue, 2020-04-07 19:26
could u please explain the difference between os authentication and database authentication and how it is done, briefly...i have read it but unable to understand it completely(w.r.t oracle 9i)
Categories: DBA Blogs

MemOptimized Rowstore

Tom Kyte - Tue, 2020-04-07 19:26
I tried to create a table learning from with a tutorial <code>create table key_val_pair( id number constraint id_pk primary key, key_val varchar2(100), key_name varchar2(100)) segment creation immediate memoptimize for read;</code> it is sh...
Categories: DBA Blogs

How to email from Python

Bobby Durrett's DBA Blog - Tue, 2020-04-07 15:25

I got an email asking how to send an alert email from a Python script. Here is an example based on a script I have setup:

You need to replace “PUT YOUR SMTP SERVER HERE” with the host name of your smtp server.


Categories: DBA Blogs

Using a video capture usb stick with Linux / Ubuntu

Dietrich Schroff - Tue, 2020-04-07 13:04
Three weeks ago i ordered a video capture usb stick at banggood and today it arrived:

So will this device work with my ubuntu?

I inserted the stick on my laptop and dmesg showed:

[123483.143071] hid-generic 0003:534D:0021.0002: hiddev0,hidraw1: USB HID v1.10 Device [MACROSILICON AV TO USB2.0] on usb-0000:00:14.0-1/input4

That was all...
But there was a module missing:

modprobe uvcvideo
and after that:
[125822.751366] usb 1-1: new high-speed USB device number 19 using xhci_hcd
[125822.901442] usb 1-1: New USB device found, idVendor=534d, idProduct=0021
[125822.901449] usb 1-1: New USB device strings: Mfr=1, Product=2, SerialNumber=3
[125822.901454] usb 1-1: Product: AV TO USB2.0
[125822.901458] usb 1-1: Manufacturer: MACROSILICON
[125822.901478] usb 1-1: SerialNumber: 20150130
[125822.902702] uvcvideo: Found UVC 1.00 device AV TO USB2.0 (534d:0021)
[125822.902835] uvcvideo: UVC non compliance - GET_DEF(PROBE) not supported. Enabling workaround.
[125822.904681] uvcvideo 1-1:1.0: Entity type for entity Processing 2 was not initialized!
[125822.904691] uvcvideo 1-1:1.0: Entity type for entity Camera 1 was not initialized!
[125822.911070] hid-generic 0003:534D:0021.0004: hiddev0,hidraw1: USB HID v1.10 Device [MACROSILICON AV TO USB2.0] on usb-0000:00:14.0-1/input4
Checking with
root@zerberus:~# ffmpeg -sources |grep video
Auto-detected sources for video4linux2,v4l2:
  /dev/video1 [AV TO USB2.0]
  /dev/video0 [HD WebCam: HD WebCam]
root@zerberus:~#  ffmpeg -list_formats all -i /dev/video1

[video4linux2,v4l2 @ 0x55b0d1ca38c0] Compressed:       mjpeg :          Motion-JPEG : 480x320 640x480 720x480
[video4linux2,v4l2 @ 0x55b0d1ca38c0] Raw       :     yuyv422 :           YUYV 4:2:2 : 480x320
/dev/video1: Immediate exit requested

Now i was able to open /dev/video1 with VLC:

The video came from a camera connected via TS832 --[5.8GHz]--> RC832...

PL/SQL, AST, DIANA, Attributes and IDL

Pete Finnigan - Tue, 2020-04-07 01:06
I have been wanting to write a detailed post about this subject for a very long time and indeed I have had some notes and screen dumps for some of this for more than 15 years for some parts of....[Read More]

Posted by Pete On 06/04/20 At 08:57 PM

Categories: Security Blogs

Install Azure CLI on MacBook Pro

DBASolved - Mon, 2020-04-06 18:58

Microsoft has enabled its cloud platform to have a command line (CLI) utility that can interact with the cloud based services.  This CLI is installed on the Mac OS X operating system by using homebrew.   Homebrew To install homebrew, use the package manager.  Homebrew makes it easy to install the Azure CLI with very few commands. […]

The post Install Azure CLI on MacBook Pro appeared first on DBASolved.

Categories: DBA Blogs

What is the Zachman Framework ?

OracleApps Epicenter - Mon, 2020-04-06 10:55
In layman word Zachman Framework is matrix for managing enterprise architecture. The Zachman Framework uses a 36-column matrix to help organize your company’s enterprise architecture and lend insight into your organization’s IT assets. One axis, normally spread about the horizontal of the matrix, consists of the following fundamental elements of human analysis in template include […]
Categories: APPS Blogs

Using Materialized View as ETL option

Tom Kyte - Mon, 2020-04-06 06:46
Hello TOM, Any comment regarding Using Materialized View as ETL option to populate data from OLTP to OLAP? Pros and Cons will be useful. Thanks, Rajneesh
Categories: DBA Blogs

SAAS Vs IAAS Vs PAAS for DBCS related query

Tom Kyte - Mon, 2020-04-06 06:46
Hello TOM, I need to use DBCS for implementing Reporting Solution on cloud. Hence need to understand SAAS, IAAS and PAAS platform for cloud. Can you please help me to understand in simple layman terms with examples of all 3. Thanks, Rajnee...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator