As a DBA, why should I care? And how do I get Started?….. Imagine you are on call, at 02:14 the database suddenly becomes unresponsive. By the time the first notice reaches you and you have dragged yourself out of sleep and started your PC – 4 critical financial batches importing invoices already failed. Users…
Oracle SQLcl – Stop Emailing TNS Entries: CONNMGR Gets Export/Import in 26.1….. I’m fully aware I stated in an earlier blog post that we had reached the final part of the SQLcl series. Turns out I can’t quite stick to that statement. SQLcl is so powerful, and Oracle keeps releasing new amazing features with every…
Oracle SQLcl – Run It Again: Putting the REPEAT Command to Work….. We have now reached the final post in my series covering the SQLcl commands I find most useful and reach for on a daily basis. This post will cover the REPEAT command. It does only one thing and is very simple to use….
Another Round of SQLcl Ammo: The HISTORY Command….. So, we still haven’t reached the last post in my blog series describing powerful commands in Oracle SQLcl. Today’s focus will be on the command “HISTORY”. This command is a strong feature built into the SQLcl utility, and I use it many times during the week —…
Oracle SQLcl – Stop Typing and Start Aliasing….. I’ve realised it’s good I didn’t decide a fixed number of posts to write on this topic beforehand. I wouldn’t have been able to stick to the decided amount. The tool is so rich and provides so many amazing new features that really increase my productivity. Moving…
Using SQLcl DDL command to fetch DDL for Database Objects.…. In part one of my post about SQLcl I voiced my opinion that SQLcl is a powerful command-line tool that brings a wide range of capabilities to both DBA’s and Developers. This second part dives into one of those capabilities that will be appreciated by…
Supercharging Data Movement with SQLcl’s LOAD and UNLOAD….. As many of you SQLcl users probably already know, it is a very powerful command line tool putting very useful and time-saving tools right at your fingertips. It has many advantages over SQL*Plus. It is built on Java, which gives it capabilities SQL*Plus could never have. With SQLcl,…