Re: Can mount, not open. Can I get data?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Mon, 20 Dec 2004 20:13:03 +0100
Message-ID: <9v8es05akrgqu2rdqktpnbji27038scnbl@4ax.com>

On Mon, 20 Dec 2004 18:22:35 GMT, dsmcd <dsmcd_at_stopspamdormouse.net> wrote:

>Hello...
>
>I have a 8.1.7 database on Win2k-Serv which can be mounted but not openned.
>There seems to be some trouble with the DR01.DBF file. Can I still get the data
>and table structures out of it? Unfortunately, backups are corrupted as well.
>
>Any suggestions?
>
>Thx,
>D.

You won't be able to retrieve anything from an unopened database as the data dictionary is unavailable. Your only choice seems to be to hire Oracle Technical Support to bring in a tool called DUL (Data UnLoader). This will cost you big buck, regrettably.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Dec 20 2004 - 13:13:03 CST