Re: Migrate from 8i to 9i with different NLS_LENGTH_SEMANTICS
From: Pat Cummings <pcummings-down-with-spammers_at_elmore.rr.com>
Date: Tue, 10 Aug 2004 01:36:01 GMT
Message-ID: <5EVRc.16082$4s6.4055_at_tornado.tampabay.rr.com>
Date: Tue, 10 Aug 2004 01:36:01 GMT
Message-ID: <5EVRc.16082$4s6.4055_at_tornado.tampabay.rr.com>
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/2004Received on Tue Aug 10 2004 - 03:36:01 CEST