Re: IMPORT - how many passes?

From: Peter Teoh <no_email_please_at_singnet.com.sg>
Date: Sun, 9 Nov 2003 11:02:05 +0800
Message-ID: <bok8av$2sj$1@mawar.singnet.com.sg>

2a) Make sure you match the character set of the new database to the old one (you can't change it later, and if they don't match you might get translation errors). You can run "SELECT * from nls_database_parameters" on the old database to find out the character set.

It depends on which version of database u are talking about.

As mentioned in Metalink NoteID: 66320.1 "Changing the Database Character Set or the Database National Character Set": The method described here is documented in the Oracle 8.1.x and Oracle9i documentation. It is not documented but it can be used in version 8.0.x. It does not work in Oracle7.

Take a look at the procedure, which involved issuing the command:

ALTER DATABASE [<db_name>] CHARACTER SET <new_character_set>

ALTER DATABASE [<db_name>] NATIONAL CHARACTER SET <new_NCHAR_character_set>

and using the character set scanner utility.

Thanks. Received on Sat Nov 08 2003 - 21:02:05 CST