Category: SQLDev

SQLDev, Ubuntu

Install SQL Developer on Ubuntu 17.04

Last week I decided to blow away Windows on my ASUS laptop and install a flavor of #Linux. I’ve got a few machines running Oracle Linux so I settled on #Ubuntu. To be more specific: dbryant@asus:~$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 17.04 Release: 17.04 Codename: zesty As a …

Database, Fun Stuff, SQLDev

SQL Developer, MySQL, and a Raspberry Pi

  This post will probably not contain anything new, but maybe it will all just be in one place. Recently I decided to do something with my Raspberry Pi (RPi), as for some time now, it has been sitting on my desk acting as an XBMC server. Well no more. But what should I do? How …

Oracle, SQLDev, TimesTen

SQL Developer with Oracle TimesTen ttStats

I’ve had the opportunity to work on with the TimesTen database on the Oracle Exalytics platform, and once again I got to use my favorite tool to make life so much easier. If you’ve ever used TimesTen, then the ttIsql command line should be familiar to you. In this post, I’ll show you how to …

12C, Oracle, SQLDev

SSH Tunnel with #SQLDev 4.1 EA1 and EA2 side by side

Yesterday March 9th, the team that works on #SQLDev, dropped EA2 out there for us to play with. For some random reason, I decided to check out SSH tunneling feature.  If you are familiar with it in the EA1 release, some things have moved around and features have been added.  Let’s take a look at …

Database, Oracle, SQLDev

Close Multiple Connections in SQL Developer

ThatJeffSmith has already shown you how to clean up your Connections window in SQL Developer by using Folders. If you are like me, you may have multiple open connections to various database instances or to the same one for that matter, and maybe you want to close a certain set of connections. By using folders, …

Big Data, Database, Oracle, SQLDev

Big Data Lite VM and SQL Developer v4.1 EA1

As a regular user of #SQLDeveloper, I decided to go ahead and check v4.1 EA1 connectivity to the Oracle Big Data Lite VM.  The good news is that it works.  The better news, is the steps are the same for the SQL Developer 4.0.3, the most recent GA release.  If by chance, you haven’t already …

Database, dbaOnTap, Oracle, SQLDev

It’s Out! #SQLDeveloper v4.1 EA1

Earlier today, I saw a few hints that we might need to check out the SQL Developer Download page.  Finally having a chance to check, yep there is was, the long awaited SQL Dev v4.1 EA1.  Now please be aware that this is and Early Adopter release. This version also requires that you have JDK 8 …

Oracle, Reporting, SQLDev

Migrate Your SQL Developer User Defined Reports

  On Tap for Today: Migrating SQL Developer User Defined Reports. I’m in the process of upgrading my work computer and in an effort to make sure it is configured the way I want it, I decided to forego the automated “side-by-side” migration.  Everything was going well until I got around to SQL Developer.  The install …

ACEA, cool stuff, Database, Migration, Oracle, SQLDev

Database Objects Compare: Grants, Types, and Owners

On Tap for Today: I had a chance to have a little fun today browsing these database tables: sys.obj$, sys.objauth$, sys.user$, and table_privilege_map. This last migration, the result of at least two other blogs posts, has forced me to think about how we do object migrations.  It’s one of the few times that we had …

Data Migration, Database Copy, dbaOnTap, dbcapoeira, Oracle, SQLDev

SQL Developer Database Copy: I Really Like This Tool!

SQL Developer Database Copy Recently, my team has been involved in a pretty detailed migration from a Development Instance to our QA instance prior to a final promotion to Production.  In the past, some of the team members were moving PL/SQL packages between instances by doing this: Opening them up Copying to the clipboard Open …