The good folks at Oracle, namely @krisrice, approached me this past Summer with an offer I found myself unable to refuse. The short version would be something like, ‘Hey, come join our SQL Developer team.’ So next week, I will start the next chapter of my professional life as the Product Manager for Oracle’s primary [...]
oracle
Oracle: Move Table to new Schema and Tablespace
A Toad user posed this question today: Is there a way to move a (marked) TABLE mytable123 from Tablespace AAA and Schema BBB to another Tablespace USERS and Schema MYSCH? Let’s tackle the 2nd and easiest part first! Moving a table or partition to a new tablespace is pretty straightforward: ALTER TABLE table_name MOVE TABLESPACE [...]
Quotes for My ‘Book’: A Million Little Tadpoles
I thought it would be cool to include some personal stories and quotes from people who have had a good experience with Toad. So, please step up and give me some juicy bits to share with my readers! I have nothing to offer but your future celebrity as tens of hundreds of people stumble upon [...]
What’s Your Favorite IDE for PL/SQL Programming?
I stumbled upon an interesting discussion in the ODTUG group on LinkedIn this weekend. A vendor is doing some research I suppose and wanted to know who enjoyed using what IDE and why. Here’s the original question: In your opinion which is the best IDE for PL/SQL programming and why? e.g. PL/SQL Developer, Toad, Oracle [...]
Can’t See the Trees for the Forest
Yes, I know – the phrase is actually supposed to be the opposite, “Can’t See the Forest for the Trees.” One of the reasons English is such a hard second language to pick up apparently is all the idioms and non-literal phrases we use. So in case you’ve never heard this phrase before, it basically [...]

Twitter
RSS
GooglePlus
Facebook