Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using COPY to rebuilding database.

Using COPY to rebuilding database.

From: Timothy J. Stevens <tstevens_at_mail.airmail.net>
Date: 1997/08/08
Message-ID: <331B8C12F509FF49.CF3F2311233C3C28.1F28B7DA4AC916DC@library-proxy.airnews.net>#1/1

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! Received on Fri Aug 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US