Re: Migrate from 8i to 9i with different NLS_LENGTH_SEMANTICS

From: Pat Cummings <>
Date: Tue, 10 Aug 2004 01:36:01 GMT
Message-ID: <5EVRc.16082$>

  try doing a regular export without exporting the data. Then open the export file in any text editor and delete out the binary stuff. Presto... New DB create script. I have not done this recently but it worked with Oracle 7.3 and 8.0 on a windows server. If this doesn't work try downloading Free Toad from It has many export options that are ALL SQL file based.

Pat Cummings

"Tosta" <> wrote in message news:cf7oda$1g1$
> Hi Kenneth,
> thanks a lot for your reply.
> > Here's one approach among many:
> >
> > 1) Use the exp/imp to create a DDL file for all tables/indexes etc. in
> > the old db (imp with show=y)

... Deleted for brevity ....

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.734 / Virus Database: 488 - Release Date: 8/4/2004
Received on Tue Aug 10 2004 - 03:36:01 CEST

Original text of this message