Migrating 9i schema without using export dump

Giganews Newsgroups
Subject: Migrating 9i schema without using export dump
Posted by:  Johne_uk (edga…@tiscali.co.uk)
Date: Wed, 21 Nov 2007

Hi,

I have a 9i db running on linux that is corrupt and will not export
certain schemas using exp. I need one of the schemas from the instance
and as I can't use export I'm wondering what the best way is to get
all of the objects extracted.

I can probably extract many of the tables etc from the data dictionary
but there are thousands of rows in the tables and I dont thinks is
really feasible to create scripts to insert data into the tables.

I'm aware that this is no easy fix here but am hoping there is
something I have overlooked. Is there a third party product on the
marker that could assist with migration work.

PS I've looked at fixing the corrupt DB via metalink but it was just
making things worse.

Thanks in advance
John

Replies