Re: Migrating 9i schema without using export dump

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: Mon, 26 Nov 2007 06:48:05 -0800 (PST)
Message-ID: <70d5daca-9ac3-457e-bcc3-8eec1cea2227@w34g2000hsg.googlegroups.com>

On 22 Nov, 12:34, Jerome Vitalis <vitalismanN05..._at_gmail.com.invalid> wrote:
> On Wed, 21 Nov 2007 14:39:19 -0800, Johne_uk wrote:
> > 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.
>
> Have you tried some user-made scripts that do (more or less) exp's work?
> For example, IIRC, Tom Kyte has a script that "export" data in a format
> suitable to SQL loader.

Hi,

My export dumos were terminating but I found this was happening after the tables had been dumped. Therefore I could import the tables into a new instance and then create all other objects from scripts.

Thanks for all the help guys.

John Received on Mon Nov 26 2007 - 08:48:05 CST