Oracle Full Backup ?

[KY.Chuang]

Dear all,
I tried to do a Oracle Full Backup.
But when I restored the data,
the original data of Chinese was not
correct...
Flowing is my step:
(Os:Windows 2000 Server ; Oracle:8.0.5)
(1) exp80 system/manager Full=y file=...
(2) Delete Database
(original Character Set is AMERICAN_AMERICA.WE8ISO8859P1)
(3) Recreate Database
(Character Set is AMERICAN_AMERICA.WE8ISO8859P1)
(4) imp80 system/manager Full=y file=...

Do I have any incorrect setp ?

[malay boy]

Hi,
Don't you need to create the tablespace before importing OR my brain goes "cu-cu" today.

regards
mB

[Alexander M. Ermes]

Hi there.
To clear some things first.
What you have done, is to create a logical backup.
Did you do the export and import with the parameter
NLS_LANG=american_america.we8iso8859p1; export NLS_LANG

?

If not, this might be your problem.
You should do export and import with these NLS_LANG params.
Have you got a full physical backup on tape or a copy of your files on the server to restore the old database ?
Rgds
Alexander M. Ermes

[twang]

You need to identify the following:
-- What was the database character set specified when issuing the CREATE DATABASE for the source database?
-- What was the client character set when the data was exported?
-- What was the database character set specified when issuing the CREATE DATABASE for the destination database?
-- What was the client character set when the data was imported?

It is important to note Import will do up to 2 character set conversions
depending on:

(a) character set of export file
(b) NLS_LANG of import session
(c) character set of database.

[T G Manikandan]

WHen you do a import you should have got messages like

export done is format
import uses yy character set (possible conversion)


What messages you have ?

Revert

[Yogeeraj_1]

hi,

In general, during import/export the data can and often does go through character set translation.

Unless
a) source database has CHARACTER SET X
b) client running export has their NLS_LANG set to X
c) client running import has their NLS_LANG set to X
d) target database has CHARACTER SET X

hope this helps!
regards
Yogeeraj

[KY.Chuang]

Dear all,
How to set the Character Set Parameter when I export data ???

c:\exp80 system/manager Full=y file=... ???

[Massimo Bianchi]

Character set is built in the db.
You change the NLS_LANG environtment variable to the proper value.

Massimo

[twang]

To check and modify them:
Right-click the 'My Computer' icon ->
'Properties'
Select the 'Advanced' Tab ->
Click on 'Environment Variables'

[twang]

A little more add to above reply, you can set the NLS_LANG as an environment variable in a Command prompt too, if such, be aware that it will overrite the current NLS_LANG setting in the Registry and also the System Properties. In an MS-DOS command prompt, use the set command, for example: C:\> set NLS_LANG=american_america.WE8ISO8859P1