Re: how to backup complete tablespace?

you can do a user export. this will export all the objects in the user's schema to a dump file. When you back to your office, do a user import to restore all the objects to your Oracle server. See Oracle Server Utility guide for detail.

Wei

rspeaker_at_my-dejanews.com wrote in article <6v2su3$g2j$1_at_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 Mon Oct 05 1998 - 22:39:07 CDT