Re: Migrating 9i schema without using export dump

On Nov 21, 4:39 pm, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> 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

Contact Oracle Support and have your checkbook handy, as DUL isn't cheap, but it's likely the only recourse you have to resurrect this database by salvaging the data therein.

David Fitzjarrell Received on Wed Nov 21 2007 - 16:59:31 CST