Did you ever use the COPY command in sqlplus? It's very old, and documentation says : The COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8i. The COPY command is likely to be deprecated in a future release.
Deprecated? But it is back, with a new name, in the new SQL Developer based SQL*Plus (currently called sdsql in beta)
Here’s an entertaining little change across versions of Oracle, brought to my attention by Tony Hasler during UKOUG Tech 14. It’s a join cardinality estimate, so here are a couple of tables to demonstrate the issue – the only columns needed are the alpha_06 columns, but I reused some code from other demonstrations to create my test case, so there are lots of irrelevant columns in the create table script:
Title: Oracle Multitenant: The Beating Heart of #DBaaS
Featured Speaker: Debaditya Chatterjee, Product Manager for the Oracle Multitenant
Start time: Dec 09, 2014 01:00 PM America/Eastern
End time: Dec 09, 2014 02:00 PM America/Eastern
Today I went to UKOUG 2014 at Liverpool! In this blog you'll find the sessions I attended and a little resumé about it. Enjoy!
If you (like me) are using Microsoft.Update.Session for listing the installed windows updates, you might be surprised about something I spent a lot of time today.
Our dream team here is deploying a very cool project for a client where we automated all the install/controlling of the windows updates in an environment. After some weeks, another script is run in another environment and gets the differences between these environments and just install in this environment those updates that are differences. It means that was tested and approved. We will blog about it.
Every data platform has its value, and deciding which one will work best for your big data objectives can be tricky—Alex Gorbachev, Oracle ACE Director, Cloudera Champion of Big Data, and Chief Technology Officer at Pythian, has recorded a series of videos comparing the various big data platforms and presents use cases to help you identify which ones will best suit your needs.
As Thursday and Friday were holidays in the US, I decided to make the most of the time and take a little tour of part of the North Island. Many of my coworkers from Dbvisit have been asking me how my trip went so I figured I might post this as a blog… I […]
It would appear that some DBAs are still using the optimizer_index_cost_adj parameter to make index access paths more ‘desirable’ to the optimizer. In decades past this might have been a good strategy however with the improvement in statistics gathering in recent relesaes of Oracle this might not be the case. Let’s look at an example to see why this might do more ‘harm’ than good.
I just attended to an interesting session at UKOUG 14 - Liverpool, named "The least an Oracle DBA Should Know about Linux Administration". This session has been given by Martin Nash (@mpnsh).