Re: Lost partition containing indexes

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 08 Jul 2003 19:48:38 +0200
Message-ID: <ms0mgvke59gnct160nq5ntt2uh8gmd3ann@4ax.com>

On Tue, 8 Jul 2003 09:32:11 -0600, Donald Thompson <dlt_at_checkmysigforemail.com> wrote:

>I have an oracle backup, but not a filesystem backup for the indexes. I
>sort of assumed that the oracle backups just contained the data for the
>DB, not necessarily the indexes.

They contain backups for datafiles. Indexes are located in datafiles.

Next question: do you have an export. The export has the create index statement. imp indexfile=<any filename> will get them out the dump.

Other than that you are lost.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 08 2003 - 12:48:38 CDT