Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restoring schema/tablespace to a different database
Absolutely sorry.Figure me kneeling asking for forgiveness. Version is
9.2.0.5 Enterprise Edition. Both servers are W2003 Server.
Thanks for the lightning superfast response.
/Gerold
"Gerold Krommer" <g.krommer_at_doremove.fns.co.at> schrieb im Newsbeitrag
news:1117029692.539878_at_newsmaster-03.atnet.at...
> Hi,
>
> I asked aunt google on this but didn't come up with a defintive answer, so
> I thought I asked the gurus.
>
> Our customer has two databases on two servers. Each database has two
> schemas, both using their dedicated tablespace. The schemas are named the
> same,
> so server 1 has schema A and B and server 2 has schema A and B. They have
> a business need to periodically update schema B on server 2 to the same
> state as schema B on server 1, but realtime replication is not neccessary
> and not desired.
>
> Is it possible and supported to make an online backup of the tablespace
> belonging to schema B on server 1, ship it to server 2, set tablespace for
> schema B on server 2 to offline and fully restore the shipped tablespace
> now. Access to the tablespace during restore will not be possible and this
> is not a problem.
>
> I suspect the answer is yes, but wanted to ask before I try in vein in the
> test environment. I guess I'm not sure about how logically and physically
> separate two schemas are.
>
> Thanks for any hints,
>
> /Gerold
>
Received on Wed May 25 2005 - 09:26:59 CDT