Search

Top 60 Oracle Blogs

Recent comments

TOI

How to do EXPORT / IMPORT between #Exasol and #Oracle

The commands IMPORT and EXPORT provide an easy way to transfer data between Exasol and other data sources like an Oracle database. You may at first get this error message: Oracle instant client not available. Please ask your administrator to install it via EXAoperation.

Here’s how to do that yourself without having to ask your admin </p />
</p></div>

    	  	<div class=

#Exasol’s annual conference in Berlin #XP18

We have had our annual conference Xperience in Berlin again – it was an amazing event with a packed agenda full of customer success stories and technical news. This year at the Umspannwerk.

Users, schemas & privileges in #Exasol

Exasol Logohttps://uhesse.files.wordpress.com/2018/05/exasol_logo.png?w=150 150w" sizes="(max-width: 161px) 100vw, 161px

Getting started with #Exasol

One nice and easy way to make yourself familiar with Exasol – the leading In-Memory Analytic Database – is the Community Edition. It’s free and can be downloaded here as a virtual machine running on VirtualBox.

A good description how to install the Community Edition can be found here.

There’s an Exasol SQL Client called EXAplus. You can use it as GUI, then it looks like this:

What is #Exasol?

Exasol is the name of a company based in Nuremberg, Germany and the name of its major product: An in-memory analytic database.

That database leads the recent TPC-H benchmarks, delivering outstanding performance while running on commodity hardware.

Technically, Exasol is a clustered RDBMS using a shared nothing architecture. Availability is achieved with spare nodes, like in this diagram:

How to cancel SQL statements in #Oracle 18c

https://uhesse.files.wordpress.com/2015/10/helps.png?w=600&h=558 600w, https://uhesse.files.wordpress.com/2015/10/

How to cancel SQL statements and disconnect sessions in #PostgreSQL

https://uhesse.files.wordpress.com/2018/01/postgresql.png?w=150 150w, https://uhesse.files.wor

#Accenture #Enkitec Group at #ukoug_tech17

https://uhesse.files.wordpress.com/2017/12/

Why INSERT causes TX – row lock contention or TM – contention in #Oracle

https://uhesse.files.wordpress.com/2015/10/helps.png?w=600&h=558 600w, https://uhesse.files.wordpress.com/2015/10/

#Accenture #Enkitec Group at #DOAG2017

Yes, it’s that time of the year again when DOAG (Deutsche Oracle Anwender Gruppe) is about to host its annual conference – probably the largest Oracle event in Europe!