Re: how to backup complete tablespace?

you could do something like

select table_name from sys.dba_tablespaces where tablespace_name = '<customer tablespace to be backed up>';

then export all the tables belonging to that tablespace. Take the export file back to your office and import into your database.

-Roy-

In article <6v0h8i$lb6_at_journal.concentric.net>,   schaubro_at_mindspring.com (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 tables
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 02 1998 - 10:53:39 CDT