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. >