ALL POSTS

Oracle: How to move a table to another schema?

A client asked me, “How can I move a table to another schema in Oracle?” The quick answer I gave him is, “not possible”. You have to rebuild it via “create table as select”. You might ask, justifiably, why would you want to do that anyway? His problem was that the application has been split into 2 parts, and he wanted to have separate schemas for each part, to ensure that there is no cross-schema table access.

Log Buffer #1: A Carnival of the Vanities for DBAs

Welcome to the inaugural Log Buffer, a Carnival of the Vanities for the DBA community. Since this is the first, the duty of hosting it falls to us, but we hope other bloggers in the community will take on future editions. Here are our favourite database-related blog articles.

Allow Me to Introduce Myself

My name is Dave Edwards, and I started at The Pythian Group a week ago my work here has been given the title Communications Specialist. This position is a new one, so I’m building it as I go.. In general terms, my job is to help Pythian tell its stories. That takes in everything from technical documentation and whitepapers, to our blog posts. Wherever words are required.

Remote DBA: How to Get Expert Help Without Losing Control

I’ve been invited by new Pythian partner GridApp to co-host a webinar with their eminent chief scientist, Matt Zito. If you don’t know about GridApp, you certainly should. They offer a rapid-provisioning and configuration management system called Clarity that substantially streamlines repetitive database management chores while simultaneously providing visibility into inventory and configuration changes.

SQLserver 2005 Query Efficiency

With the new dynamic performance views available in SQLserver 2005 you can run queries which allow you to determine these poor performers without much extra work. It is not statspack or Automatic Workload Repository (AWR) or V$ACTIVE_SESSION_HISTORY (more importantly) but it is a good start to determining what sql and what sessions are consuming the most resources in SQLserver 2005 instance.

Useful SQLserver 2005 blogs

I have been scanning some blogs by different teams involved with SQLserver 2005. There is a bit of cross linking happening so some articles are repeated on one or more blogs. Here is a short list:

Eurotrip Vacation For Me

It’s time for vacation for me.

I am off to Europe and then vising home – Sofia, Bulgaria. I will be back in 4 weeks. Yes I did earn to have a long vacation, and yes, Pythian is really nice in allowing me to have it all at once.

RMAN in 10g

There’s always these little things that you discover when you read the manuals. For example the “duration” option for RMAN backup. It looks very neat, and is actually in RMAN from 10g Release 1.

Page 233 of 250« First...102030...231232233234235...240250...Last »