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?
>
2 Oracle ways that I can think of that both involve Exporting. I'll
assume you don't know Oracle that well or are you looking for something
different than I'm reading into this. 1. Export all the tables from the
tablespace, then import them back at your office. 1. Export the user
that owns all the tables in the tablespace, import back at the office.
If that's the case, read the small chapter in the Oracle Utilities
manual about Exporting.
Hope dat helps...
Received on Thu Oct 01 1998 - 14:03:27 CDT
