Discuss in the Community


Abu Fazal Abbas
Follow /4 Aug 2015 at 6:45pm / Oracle

Migrate Oracle database using Transportable Tablespace

I have been working with Oracle Databases since last 6 years. However, surprisingly I never had the opportunity to use the Transportable Tablespace option of migrating data from one Oracle database to another. Recently, I had the opportunity of using...
108 0 /
Follow /4 Aug 2015 at 5:31pm / SQL Server

Machine Learning Data Sets

Machine Learning Data Sets When starting out with data mining and machine learning you will need to have access to sample data in order to learn the technology.  Often times leveraging data outside of your corporate data sets makes it easier to learn...
100 0 /
Follow /4 Aug 2015 at 1:12pm / Oracle

OGG -12c ggsci: fatal: libclntsh.so.12.1: open failed

After Installation of Oracle Golden Gate on Oracle Solaris 11.2 – Sparc “ggsci” command was not working. Installation of Software was successful without any Issues. Error Stack while executing “ggsci” command...
92 0 /
Follow /4 Aug 2015 at 9:10am / Oracle

ORA-27211: Failed to load Media Management Library – EMC Networker – Oracle RMAN

Recently one of our DBA configured online database backup on a EMC Networker.  But when we execute the backup script then its failed to load the media management library. The below is the error stack from rman logfile: RMAN-00571: ===============...
70 0 /
Porus Homi Havewala
Follow /2 Aug 2015 at 12:28pm / Oracle

New Version of Oracle REST Data Services (ORDS) 3.0.1

Happy to see that a new version of Oracle REST Data Services (ORDS) 3.0.1 is now available for download. The new Oracle REST Data Services can now be installed independently of Oracle Application Express (APEX). The previous version, Oracle REST Data...
313 0 /
Deiby Gomez
Follow /1 Aug 2015 at 11:05pm / Oracle

Logging Levels in Oracle 12c

Since the architecture of Oracle Database 12c has changed, now we have two kind of databases "Pluggable Databases (PDB)" and "Container Databases (CDB)". With these many things changes as well, for example the Logging Levels and that's...
399 0 /
Jen McCown
Follow /1 Aug 2015 at 5:09pm / SQL Server

Beginning T-SQL slide deck and recording – #SQLSatBR

I had a great time in my Beginning T-SQL presentation here at SQL Saturday Baton rouge! Here is the BeginningTSQL slide deck (PDF). Here is an older recording of the class, as I haven’t yet had time to process today’s recording. Thanks to...
257 0 /
Damir Vadas
Follow /1 Aug 2015 at 2:28pm / Oracle

Apex 5-unpublished requirement

Finally the day when I decided to upgrade to Apex 5 has come. Time shift of initial Apex 5 release and curiosity to see how mine apps will fit in new Apex were main sparks to upgrade mine Apex 4.2x version to current latest, Apex version 5.0.1. As I always...
226 0 /
Fernando Garcia
Follow /1 Aug 2015 at 2:33am / Oracle

Oracle, vistas y sentido común.

Como hemos visto hace algunos días en el post " Oracle Turístico. Las vistas que no miramos (III )", en Oracle es posible la actualización de vistas. En ocasiones las actualizaciones pueden llevarnos a escenarios que no...
176 0 /
David Fitzjarrell
Follow /31 Jul 2015 at 8:44pm / Oracle

What’s In A (User) Name?

"So each one of you agrees to disagree with whatever the other one agrees with, but if you both disagree with the same thing, aren't you really in agreement?" - Norton Juster, The Phantom Tollbooth Recently a blog post caught my attention...
221 0 /
Ajith Narayanan
Follow /31 Jul 2015 at 3:46pm / Oracle

Oracle Backup & Recovery Series - 4 (RMAN BKP Configuration)

In my previous posts, all the settings for recoverability was discussed, If you have not read them yet, maybe you can start reading them now. In this blogpost we will start discussing on the backup configurations we should be concentrating on. 1) Multiplexing...
116 0 /
Fernando Garcia
Follow /31 Jul 2015 at 12:57am / Oracle

Acerca de las funciones analíticas.

Dentro del lenguaje SQL de Oracle podemos encontrar varios tipos de funciones. Es probable que coincidas conmigo en que las llamadas "single row" y las "agregadas" son los tipos de funciones mas famosas de todas. Como sus nombres lo...
135 0 /
Brad Wulf
Follow /30 Jul 2015 at 7:15pm / Toad for MySQL

Amazon Aurora is now GA! Get the most out of it by using Toad for MySQL

Amazon Aurora is now GA. If you aren’t familiar, Amazon says it best here: ‘ Amazon Aurora is a fully managed, MySQL-compatible, relational database engine that combines the speed and reliability of high-end commercial databases with the...
616 0 /
Follow /30 Jul 2015 at 12:09am / Oracle

Presentation will be

There is no much left for 2015 but there is too much work waiting me, presenting in different country means a lot of work and preparation, i am still waiting different events but till now this is confirmed:- SIOUG2015 HROUG2015 OOW15 UKOUG TECH15 So Excited...
119 0 /
Follow /30 Jul 2015 at 12:06am / Oracle

Database Certified with EBS 12.2

After Waiting too long finally I can upgrade my Oracle EBS Database ,Regarding to Oracle Blog "Database Certified with EBS 12.2". You can Read more about this here Cheers Osama
106 0 /
Dan Hotka
Follow /29 Jul 2015 at 4:57pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 7)

Hi! I have been discussing how I would find and tune problem SQL. Datatype mismatch has always been a problem for the optimizer. Oracle only compares like data types (more importantly, the same data types). So, if you are comparing a number...
170 0 /
Deiby Gomez
Follow /29 Jul 2015 at 3:30pm / Oracle

OTN Tour - Guatemala

Note: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. OTN TOUR 2012 Tuve la oportunidad de participar en el primer OTN Tour que se realizó...
289 0 /
Deiby Gomez
Follow /29 Jul 2015 at 8:26am / Oracle

Oracle y la función APPROX_COUNT_DISTINCT

Note: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. Como parte de las nuevas características con las que cuenta Oracle, tenemos...
260 0 /
Follow /28 Jul 2015 at 10:55pm / NoSQL

9 Elements of the Modern Data Center

Data centers are becoming increasingly important in today’s modern world. They hold and disseminate information to people when they need it. Because these data centers are crucial to how we run our lives and businesses it is important to understand...
400 0 /
David Fitzjarrell
Follow /28 Jul 2015 at 10:36pm / Oracle

It Isn’t The Index

"If you want sense, you'll have to make it yourself." - Norton Juster, The Phantom Tollbooth One of the more confusing statistics in Oracle is, apparently, one called the clustering factor. Associated with an index (as evidenced by...
288 0 /
Lenka Vanek
Follow /28 Jul 2015 at 9:45pm / Toad for Hadoop - Blog

Apache Sqoop Direct Mode – Optimized Data Transfer

Many Hadoop analytic tasks are dependent on data traditionally maintained primarily in a relational database such as Oracle. For instance, an analysis of web logs might need to access the CUSTOMER table in Oracle to obtain the customer’s geographic...
495 0 /
Natik Ameen
Follow /28 Jul 2015 at 4:55pm / Oracle

Database Rankings July 2015

Here is an interesting Database rankings survey on the db-engines site, which measures the general interest in the different databases, based on the criteria below. This provides some insight into the trend in the adoption of these databases. Database...
57 0 /
Jen McCown
Follow /28 Jul 2015 at 3:00pm / SQL Server

Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR

You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday, July 31, and if you register before June 30 you’ll get the Early Bird rate of $99…it’s $125 to attend...
409 0 /
Follow /28 Jul 2015 at 12:00pm / SQL Server

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route...
433 0 /
Craig Mullins
Follow /28 Jul 2015 at 12:35am / IBM DB2

DB2 Compression: z/OS versus LUW

Data compression for non-mainframe DB2 is quite a bit different than it is for DB2 for z/OS. In mainframe DB2, specifying COMPRESS YES on the CREATE TABLESPACE statement will cause DB2 to implement Ziv-Lempel compression ( http://www.data-compression...
812 0 /