Re: transportable tablespaces on a SAN
- From: Thomas Day <tomdaytwo@xxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx
- Date: Sun, 7 Jun 2009 16:00:03 -0400
About 8 hours right now. From your answer it sounds as if the theoretical
answer is "Yes". Now it's just a matter of working out the details.
I just wanted to know if it was even possible before we started tackling the
"minor" details. (grin)
On Fri, Jun 5, 2009 at 2:41 PM, Michael McMullen <ganstadba@xxxxxxxxxxx>wrote:
> I guess you mean you have two separate servers, and you want to do
> something like export the metadata, drop the tablespace from db 1 (but not
> the datafiles) and then transport db 1 tablespace into db 2? You don’t mean
> keep both tablespaces in both databases using the same datafiles, right?
>
> A lot of details missing here but doesn’t this sound like nothing but
> trouble? How slow can a copy from the same SAN be?
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Thomas Day
> *Sent:* Friday, June 05, 2009 1:37 PM
> *To:* ORACLE-L
> *Subject:* transportable tablespaces on a SAN
>
>
>
> I have two databases, both using the same SAN for their datafiles.
> Assuming that they can both see the same logical drives, can I transport a
> tablespace back and forth by just do the metadata exp/imp?
>
>
>
> What I'm hoping is that I don't have to copy the datafiles.
>
Other related posts:
