In the first 11g release, it is still possible to logon as sysdba as well assysasm. This will definitely be changed with the next coming release, 11gR2. At present, when Oracle 11g is installed a ques...
As part of EBS database migration on Exadata, we recently deployed a brand new Exadata X5-2L (eighth rack), and migrated an Oracle EBS Database from the typical storage/server technologies. Below are...
This video gives users an overview on the pivot grid in Toad Data Point. The pivot grid allows users to summarize their data and gain insight. The video discusses the many ways users can get to and us...
Oracle OpenWorld Experiences- Part 1 The WHAT. “I LOVE Toad!” “Toad rocks!” “I couldn’t live/do my job without it.” “I am where I am today because of Toad.” “Toad? Absolutely essential in our org....
Introduction In the first part of this two-article tutorial, we introduced using Oracle Database 12c CDB and PDBs on Oracle Cloud service with Toad for Oracle. In part two of the tutorial we shall dis...
Introduction Oracle Database 12c was added to Oracle Cloud Platform about a year ago in Q3-Q4 2016. Oracle Database 12c introduced the CDB and PDBs, which make it feasible to run multiple pluggable da...
Everyone takes shortcuts. It’s normal. But we shouldn’t be doing it. It comes with some disadvantages. Sometimes it doesn’t look pretty, sometimes the shortcuts cause performance problems, sometimes ...
A brand new Exadata X5-2L eighth rack (I knew the latest is X7 now, but it was for a POC, so no worries) has been deployed recently at a customer for Oracle EBS Exadata migration POC purpose. Its wasn...
Like many other Integrated Development Environments on the market, Toad for Oracle has historically operated in a Multiple Document Interface (MDI) mode: one single application window with multiple do...
In my previous post, I showed how easy to import data from CSV, JSON, Excel files using Pandas package. Another popular format to exchange data is XML. Unfortunately Pandas package does not have a fun...
Introduction In an earlier article we discussed using PostgreSQL database on localhost with Toad Data Point. In this continuation article we shall discuss using PostgreSQL database on AWS RDS and Dock...
Remember those old Staples commercials that talked about an "Easy Button?" Aren't there so many things you wish there was an easy button for? What about Toad? Some people say there are too many button...
