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 -> Re: how to backup complete tablespace?

Re: how to backup complete tablespace?

From: <rspeaker_at_my-dejanews.com>
Date: Fri, 02 Oct 1998 15:53:39 GMT
Message-ID: <6v2su3$g2j$1@nnrp1.dejanews.com>


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

Original text of this message

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