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

Tosta,
  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 www.toadsoft.com. It has many export options that are ALL SQL file based.

Pat Cummings

"Tosta" <tosta_at_wtal.de> wrote in message news:cf7oda$1g1$1_at_beech.fernuni-hagen.de...
> 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 (http://www.grisoft.com).
Version: 6.0.734 / Virus Database: 488 - Release Date: 8/4/2004