Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Using COPY to rebuilding database.
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