Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restoring schema/tablespace to a different database

Re: Restoring schema/tablespace to a different database

From: Gerold Krommer <g.krommer_at_doremove.fns.co.at>
Date: Wed, 25 May 2005 16:26:59 +0200
Message-ID: <1117031346.411675@newsmaster-03.atnet.at>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US