Re: incomplete tablespace recovery

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 03 Jun 1999 11:40:08 -0700
Message-ID: <3756CC08.89D43218@us.oracle.com>

David

Yes, but only if you run 8i. In earlier versions, there was no syntax to support this, so what DBA's did to get around this was to rebuild the database elsewhere, export what was needed and import to the original database. This was more complicated if you wanted to perform point in time recovery, and you need to manage any integrity issues yourself.

HTH. Pete

David Lai wrote:

> Is it possible to perform incomplete tablespace recovery? If
> yes, what is the syntax?
>
> Thanks,
>
> David

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Thu Jun 03 1999 - 13:40:08 CDT