Re: how do i copy tablespace?
Date: 4 Oct 1998 13:25:00 GMT
Message-ID: <6v7svc$113_at_bgtnsc02.worldnet.att.net>
I think you can do so by using
[Quoted] the IMP/EXP (Import/Export tools of Oracle)
But if the database is very big, then you may have
portability problem. If you just want the structure of
the database, this will certainly help(Export without data)
After export, you can create the database
in some other server. But if you change the structure
of the objects, Importing back to the original server
may not work. For this, you have to drop the objects
and then do an import.
HTH Madhu Cherukuri
Tim Schaubroeck wrote in message <6v0hb4$lb6_at_journal.concentric.net>...
>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
Received on Sun Oct 04 1998 - 15:25:00 CEST