How do I create a database of different character sets in oracle9i?

oracle| Data | database
How do I create a database of different character sets in oracle9i?



When you install Oracle9i server, the installation language is automatically selected according to the operating system's locale and you can select the default character set (System language) for database installation. But what if you want to append a database with a different character set? You can now implement a database that installs multiple different character sets on the same oracle9i server side by using the following methods.



Operating Environment:

Hardware: DELL (cpu1.9g, Memory 512M)

Software: Windows2000 Server Chinese version



Configuration steps:

1. Install Oracle9i Server, set up a database EXAMPLE_CN, select the default character set (because the current system is Chinese, the default character set is ZHS16GBK).



2. Use DBCA (Database Configuration Assistant) in the installed Oracle9i server.



3. Follow the wizard (a total of eight steps) to create a new database.

First step: Choose to create a new database.

Step two: Select database mode: New DB

Step three: Enter the name of the database you want to create. For example: EXAMPLE_JP.

Fourth step: Select Database characteristics. (generally use default settings)

Step Fifth: Select the database connection option. There are two kinds: one is the private data mode (fewer connected users), the other is the shared data mode (many connected users). In this example, select the shared data mode.

Step Sixth: Initialize the parameters. Select the character set and select the desired character set from the list of character sets. In this case, select Ja16sjis (Japanese character set).

Seventh Step: Database storage.

Step Eighth: Create an option. Select Create DATABASE.

From the above steps, create a new database EXAMPLE_JP (Japanese character set).



4. In the new database EXAMPLE_JP, create a user example.



5. On the oracle9i client side, set up the user example corresponding data list. At this point, be aware that the Oracle9i client side must operate under the Japanese operating system.



With five steps, you can create a database example_jp for a Japanese character set under the Chinese operating system.



In addition, if you want to oracle9i the client side through ODBC to access the daily anthology database and the Chinese set of databases, then need to do the configuration:



Operating Environment: (Oracle9i client side)

Hardware: DELL (cpu1.9g, Memory 512M)

Software: Windows2000 Server Chinese version



1. Access to the Japanese character set database (example__ JP).

In the registry, the value name "Nls_lang" is set to simplified Chinese_china. Js16sjis, and then use ODBC to link the Japanese character set database (example__ JP). Note: At this point, the operating system language is best set to Japanese.



2. Visit the Chinese Character Set database (example__ CN).

In the registry, the value name "Nls_lang" is set to simplified Chinese_china. ZHS16GBK ", and then use ODBC to link the Chinese character set database (example__ CN). Note: At this point the language of the operating system is best set to Chinese.



Finally, introduce methods for exporting and importing multiple databases under the same oracle9i server. Assume the following: Two databases were established for EXAMPLE_CN (ORACLE_SID) and EXAMPLE_JP (ORACLE_SID), a user EXAMPLE_CN was established in example and a corresponding set of tables was established, and Create a user example in EXAMPLE_JP and set up a corresponding set of tables. At this point, the two sets of tables are exported separately.




Method



Export method

Import method

EXAMPLE

(EXAMPLE_CN)

EXAMPLE

(EXAMPLE_JP)

EXAMPLE

(EXAMPLE_CN)

EXAMPLE

(EXAMPLE_JP)

Method One

(Command line State)

1.SET ORACLE_SID=EXAMPLE_CN

2.EXP EXAMPLE

3. Follow the wizard to select the following sequence.

4. Finally generate file EXAMPLE_CN. DMP.

1.SET ORACLE_SID=EXAMPLE_JP

2.EXP EXAMPLE

3. Follow the wizard to select the following sequence.

4. Finally generate file EXAMPLE_JP. DMP.

1.SET ORACLE_SID=EXAMPLE_CN

2.IMP EXAMPLE

3. Follow the wizard to select the following sequence. (Note: Select the generated file EXAMPLE_CN.) DMP)

1.SET ORACLE_SID=EXAMPLE_JP

2.IMP EXAMPLE

3. Follow the wizard to select the following sequence. (Note: Select the generated file EXAMPLE_JP.) DMP)

Method Two

(Command line State)

1. EXP EXAMPLE@EXAMPLE_CN

2. Follow the wizard to select the following sequence.

3. Finally generate file EXAMPLE_CN. DMP.

1. EXP EXAMPLE@EXAMPLE_JP

2. Follow the wizard to select the following sequence.

3. Finally generate file EXAMPLE__JP. DMP.

1. IMP EXAMPLE@EXAMPLE_CN

2. Follow the wizard to select the following sequence. (Note: Select the generated file EXAMPLE_CN.) DMP)

1.SET IMP EXAMPLE@EXAMPLE_JP

2. Follow the wizard to select the following sequence. (Note: Select the generated file EXAMPLE_JP.) DMP)

Method Three

Export and import databases according to Oracle MANAGEMENT SERVER (OMS).






Above is only a brief, hope everybody is generous enlighten. Need to communicate, cllong@etang.com, I am very grateful!