RE: How to Change the name of the database ?
In a thread on changing a database's name, Obnoxio The Clown, John Carlson and Glyn Balmer mostly made jokes about the wording of the question. The one practical answer came from wdpan, who said to unload the data from the original database and load it into a new one. No other method was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
From: Rekaish Bhardwaj <RekaishB@compans.com> > >Hummm. >The words smart and Obnoxio don't often come to mind, let alone in the same >sentence. ;o) Shows how dumb you are. Just put the word "not" in the middle! >I had a database a few years back called Thatcher. >I remember having to rename it to Major and recently I had to rename it >again to Blair. >(I've already got a script for my next database name change, called >'mandelson_(ooh_err_missus).sql' Plonker! Those aren't databases, they're presidents of America! >Sometimes you just don't have a choice. Just wave your hands in front of them and say "you really don't need to change your database name..." I promise you, it works... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Obnoxio The Clown wrote: > > From: Rekaish Bhardwaj <RekaishB@compans.com> > > > >Hummm. > >The words smart and Obnoxio don't often come to mind, let alone in the same > >sentence. ;o) > > Shows how dumb you are. Just put the word "not" in the middle! > > >I had a database a few years back called Thatcher. > >I remember having to rename it to Major and recently I had to rename it > >again to Blair. > >(I've already got a script for my next database name change, called > >'mandelson_(ooh_err_missus).sql' > > Plonker! Those aren't databases, they're presidents of America! . . . or could be prime ministers of England. Wrong side of the pond! John Carlson Informix DBA WHSmith USA
Obnoxio The Clown wrote: > > From: Rekaish Bhardwaj <RekaishB@compans.com> > > > >Hummm. > >The words smart and Obnoxio don't often come to mind, let alone in the same > >sentence. ;o) > > Shows how dumb you are. Just put the word "not" in the middle! > > >I had a database a few years back called Thatcher. > >I remember having to rename it to Major and recently I had to rename it > >again to Blair. > >(I've already got a script for my next database name change, called > >'mandelson_(ooh_err_missus).sql' > > Plonker! Those aren't databases, they're presidents of America! . . . or could be prime ministers of England. Wrong side of the pond! Sounds like a database design issue to me . . . <G> John Carlson Informix DBA WHSmith USA
In article <7r8fdu$lug$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: Rekaish Bhardwaj <RekaishB@compans.com> > > > >Hummm. > >The words smart and Obnoxio don't often come to mind, let alone in the same > >sentence. ;o) > > Shows how dumb you are. Just put the word "not" in the middle! ... or _arse after the first one ? Sorry, Clown, it was irresistible ! [snipped] Glyn Balmer -- If it always works, why don't parachutists pull the emergency 'chute first? Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.
Simplely unload data from original database,load data to new database. In article <7r8fdu$lug$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: Rekaish Bhardwaj <RekaishB@compans.com> > > > >Hummm. > >The words smart and Obnoxio don't often come to mind, let alone in the same > >sentence. ;o) > > Shows how dumb you are. Just put the word "not" in the middle! > > >I had a database a few years back called Thatcher. > >I remember having to rename it to Major and recently I had to rename it > >again to Blair. > >(I've already got a script for my next database name change, called > >'mandelson_(ooh_err_missus).sql' > > Plonker! Those aren't databases, they're presidents of America! > > >Sometimes you just don't have a choice. > > Just wave your hands in front of them and say "you really don't need to > change your database name..." I promise you, it works... > > __________________________________________________ ____ > Get Your Private, Free Email at http://www.hotmail.com > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.