Remove everything from a schema
From: Álvaro G. Vicario <alvaroNOSPAMTHANKS_at_demogracia.com>
Date: Thu, 27 Nov 2008 13:33:12 +0100
Message-ID: <ggm423$d7e$1@huron.algomas.org>
Date: Thu, 27 Nov 2008 13:33:12 +0100
Message-ID: <ggm423$d7e$1@huron.algomas.org>
I want to remove all the contents of a schema (tables, indexes,
sequences...) in my development box so I can checkout a fresh working
copy of the web site I'm working on and generate all objects from
scratch. The server runs version 9.2.0.1.0 in a separate network machine
and I'd rather not ask the DBA to do it for me every time.
What's the easiest way to do it?
--
- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
- Mi sitio sobre programación web: http://bits.demogracia.com
- Mi web de humor al baño María: http://www.demogracia.com --