RE: Transportable Tablespaces question
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: Howard Latham <howard.latham@xxxxxxxxx>
- Date: Mon, 7 Dec 2009 09:42:09 -0500
I've tested it 3 times for the import process. Works like a charm for me, but
I'm only using 2 8GB data files. I'll see if I can get a test environment for
data guard to try to test this.
Jeremy
P Consider the environment. Please don't print this e-mail unless you really
need to.
From: Howard Latham [mailto:howard.latham@xxxxxxxxx]
Sent: Monday, December 07, 2009 9:30 AM
To: SHEEHAN, JEREMY
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Transportable Tablespaces question
When it works its like magic! . There can be glitches and as the process can
take a long time - if you are copying large tablespaces you might not get many
test attempts. My mistake was not to have a test area set up to iron out any
glitches.
2009/12/7 SHEEHAN, JEREMY
<JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>>
Hey all,
I'm going into my first round of transportable tablespaces. I've done the
work, got it working with relatively no problems. I was certainly concerned at
first when I read how easy it was to do this... Naturally it made me somewhat
wary.
I'm ready to migrate this on over to production, but I have a Data
Guard/Physical Standby configuration with my prod environment. My question is
this...
Is it really as easy as just moving the data files to the standby server and
letting Oracle take it in? Again, it seems so simple that it makes me wonder
if there is more involved, you know? If anyone can shed some light on this,
that would be fantastic!
Thanks in advance!
Jeremy
Consider the environment. Please don•'t print this e-mail unless you really
need to.
--
Howard A. Latham
Other related posts:
