Lots of questions, all angling around a specific scenario about which you
remain mysteriously silent. Why not tell us plainly what you want to
achieve, and then we can have a stab at working out how to achieve it. The
three you've come up with are complete doosies so far.
Regards
HJR
--
Oracle Resources : http://www.geocities.com/howardjr2000
========================================
"HK Chang" <hkchang_at_hgc.com.hk> wrote in message
news:9rr6o0$2spe$1_at_news.net-yan.com...
> How about if I have cold backup and recover.
>
> Is it possible to recover only a tablespace to a specific moment in time
> from a cold backup?
>
> Regards,
> HK Chang
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3be11d6f$0$8510$ed9e5944_at_reading.news.pipex.net...
> > Depends on what you mean by recover.
> >
> > You can export,import on a schema by schema basis. You can also recover
a
> > tablespace to a specific moment in time so this might allow conventional
> > recovery of a schema if your object locatiuons are sensible. I must
admit
> > though I tend to think of recover as an all or nothing event.
> >
> > If your schemas have entirely different purposes (say development and
live
> > or two different apps) you are better off with multiple databases and
> > instances.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission Uk
> > "HK Chang" <hkchang_at_hgc.com.hk> wrote in message
> > news:9rr41t$2qtm$1_at_news.net-yan.com...
> > > Is it possible to recover only one schema in the database, but the
other
> > > schemas remains unchanged?
> > >
> > > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > > news:tu234jb65vthbc_at_corp.supernews.com...
> > > >
> > > > "HK Chang" <hkchang_at_hgc.com.hk> wrote in message
> > > > news:9rqtf6$2mvr$1_at_news.net-yan.com...
> > > > > Hello,
> > > > >
> > > > > Is it possible to use single instance to manage multiple database
in
> > > > Oracle?
> > > > >
> > > > > Thanks.
> > > > >
> > > > > Regards,
> > > > > HK Chang.
> > > > >
> > > > >
> > > > No
> > > > database in sqlserver <---> schema in Oracle.
> > > >
> > > > I once had to learn to play from 16th century music notation, which
> very
> > > > much looks like modern notation. Within a few hours I discovered the
> > only
> > > > way to master it was to forget for a while about modern notation.
> > > > Learning Oracle is very much similar.
> > > >
> > > > Regards
> > > >
> > > >
> > > > --
> > > > Sybrand Bakker
> > > > Senior Oracle DBA
> > > >
> > > > to reply remove '-verwijderdit' from my e-mail address
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Thu Nov 01 2001 - 04:26:25 CST
