IMP-00016 required character set conversion (type 3 to 1) not supported [message #138500] |
Thu, 22 September 2005 05:21 |
anjana_ss
Messages: 2 Registered: September 2005 Location: India
|
Junior Member |
|
|
I have a db with us7ascii character set, in oracle 7.3.2
I want to convert/export some tables in to
server running on Oracle 6.0.
WHile Exporting from oracle 7.3.2 it shows using "US7ASCII
but while Importing it is giving error.
IMP-00016 required character set conversion (type 3 to 1) not supported.
I am very badly needed to do the above.
Please help, if any one can do.
regards
Anjana
|
|
|
|
|
Re: IMP-00016 required character set conversion (type 3 to 1) not supported [message #138518 is a reply to message #138515] |
Thu, 22 September 2005 06:10 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
I have some information that i am sharing. This is from the book --
Quote: | While moving data from one database, which has a character set that is different from the database where the data must be imported, you must ensure that the data conversion is handled appropriately. you can do this by setting the NLS_LANG environment variable to the character set definition of the database from which the data is being exported.
|
But this relates to 9i , hope it work for you.
regards,
tarun
|
|
|
Re: IMP-00016 required character set conversion (type 3 to 1) not supported [message #138534 is a reply to message #138500] |
Thu, 22 September 2005 06:55 |
alliejane
Messages: 59 Registered: July 2005 Location: Glasgow
|
Member |
|
|
Use the Views
NLS_DATABASE_PARAMETERS
NLS_SESSION_PARAMETERS
NLS_INSTANCE_PARAMETERS
V$NLS_PARAMETERS
to find out your database settings and set the following parameters on your OS (some views may not be available in Oracle 7)
On Unix
export NLS_LANG = AMERICAN_AMERICA.US7ASCII
On Windows
set NLS_LANG = AMERICAN_AMERICA.US7ASCII
You may need to change the AMERICAN_AMERICA bit of it depending where on the world you are..
Do this from the Operating system session and then run the import again..
Come back with errors that you may still have.
|
|
|
|
Re: IMP-00016 required character set conversion (type 3 to 1) not supported [message #139612 is a reply to message #138500] |
Wed, 28 September 2005 16:00 |
vjeedigunta
Messages: 201 Registered: March 2005 Location: Hyderabad
|
Senior Member |
|
|
exporting from oracle7 and importing it in 6 ? ?
import utility of oracle 6 doesnt understand oracle 7 version ..
create a tns entry for oracle 7 db in oracle 6 -> tnsnames.ora
and then export the oracle 7 tables using the oracle 6 export utility ..
oracle 6 $> exp system@oracle7 file=xxxx log=XXX owner=schema ........
and then import it .. it should work ..
-Sai Jeedigunta
|
|
|