Re: how do I copy a tablespace?

Yes, actually, there is an easy way to backup a tablespace. The way I would do it (for me the Oracle Database resides on a Unix machine) is to use the Oracle Backup Manager. This comes with the Oracle client software. With the Backup Manager you can use the Backup Tablespace Wizard and it will do the rest. It will allow you to backup a tablespace to tape or to a directory. This seems to be the easiest way I have found..

Kevin

Tim Schaubroeck wrote:

> I do client support for a program which works with oracle databases. We want
> to be able to go to our clients office, copy his tablespace, all the schema
> and data, and bring it back to our office. We want to be able to create an
> exact copy on our office oracle server. We then will do all the necessary
> customizations to the database. Then we want to take this work back to the
> client.
>
> Can anybody either tell me what I need to do to do this? Are there any
> software programs that will make this simple, fast, and efficient for me to
> do?
>
> thank you for any help that you have to offer,
>
> Tim Schaubroeck
> schaubro_at_mindspring.com
Received on Thu Oct 01 1998 - 15:44:10 CDT