From: tstevens@mail.airmail.net (Timothy J. Stevens)
Subject: Using COPY to rebuilding database.
Date: 1997/08/08
Message-ID: <331B8C12F509FF49.CF3F2311233C3C28.1F28B7DA4AC916DC@library-proxy.airnews.net>#1/1
X-Orig-Message-ID: <33eb29f3.6501472@news.airmail.net>
NNTP-Posting-Time: Fri Aug  8 09:25:53 1997
Organization: INTERNET AMERICA
NNTP-Proxy-Relay: library.airnews.net
Newsgroups: comp.databases.oracle.server



I was recently asked how to rebuild a database where  all of the
tables had been created in the SYSTEM tablespace. The only scheme I
could think of was to use the COPY command to create the tables in
another database in separate tablespaces,  drop the old database and
then rename the new database back to the original name. Does any have
any experience with this problem and will my little scheme work.
Alternatively, is there a better way to do this

Thanks!