Path: news.f.de.plusline.net!feed.news.tiscali.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.hanau.net!news-fra1.dfn.de!news-koe1.dfn.de!news.fernuni-hagen.de!not-for-mail From: Tosta Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools Subject: Migrate from 8i to 9i with different NLS_LENGTH_SEMANTICS Date: Sun, 08 Aug 2004 20:49:47 +0200 Organization: FernUni Hagen Lines: 29 Message-ID: NNTP-Posting-Host: bonsai.fernuni-hagen.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: beech.fernuni-hagen.de 1091990982 9177 132.176.114.21 (8 Aug 2004 18:49:42 GMT) X-Complaints-To: usenet@news.fernuni-hagen.de NNTP-Posting-Date: 8 Aug 2004 18:49:42 GMT User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.4) Gecko/20030619 Netscape/7.1 (ax) X-Accept-Language: de-de, de, en-gb, en Xref: news.f.de.plusline.net comp.databases.oracle.server:135146 comp.databases.oracle.tools:29498 Hi. I'm desperatly seeking a migration tool or -method or what ever. Your advice and hints are highly appreciated! I'm migrating a middle-sized 8i database on one machine to a 9i database on another machine. There is no network connection between the two machines. The 8i DB has WE8ISO8859P1 database character set and *byte* length semantics. The new 9i DB shall have AL32UTF8 database character set and *char* length semantics (due to the multi-byte character set); i have already created this DB with the appropriate parameters. The national character sets don't matter. I now have to get the data structure and the data from the 8i DB to the 9i one. imp/exp does not meet my requirements, for on import, the tables will be created with *byte* length semantics, as in the source DB, although 9i DB has *char* length semantics for newly created tables. Thus, exp/imp leads to a sort of exact clone of the source DB. Though I have been searching the Oracle docs, the web, and news groups for the last couple of days, I can't find a way to copy the DB according to my needs. My current idea is a tool that creates a big but simple SQL script from an entire DB with schemas, tables, data, indexes, constraints etc to re-create the whole lot somewhere else. In this way, the length semantics would be preserved. I would love to write such a program, but I have to be done very soon. Does anyone of you knows an SQL-based migrating tool, or knows any other way to do it? Thanks in advance! Cheers, Tosta.