Thanks everybody for your help.
It was a pretty simple procedure at the end of the day and I've learned a valuable lesson, remember which DB its all going to!
Thanks again.
Hadley
On Wed, 2004-01-28 at 10:13, Hadley Willan wrote:
Hello,
I've accidently created a whole bunch of tables and sequences in template1.
I didn't actually want the information in template1 but with the slip of a key my script piped all the commands into it and now all the info is there, doh!.
Problem is now that I try to create the DB I want, all the view and structures are already there.
How to I recreate an empty template1?
Thanks