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 …
Category: 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 …
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 …
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 …
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 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 …
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 …
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 …
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 …
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 …
