What are the character sets of each database?
What is complete command you are executing?
What happens when you select dump(column) from table?
In addition, another question...
Which tool are you using to display the data, and in which environment (Windows, Unix, etc)?
i am using sql developer and i am working on windows
Can you run the commands below and provide the results.
- SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';
- SELECT * FROM nls_database_parameters WHERE parameter LIKE '%CHARACTERSET%
Check the link/document below for more details.
I would like to export a table that is containing arabic data from one base to another, i tried to use export insert but i displays the output like that ????? , please is there any solution?
What is a 'base'? Army? Navy? Other? What does that have to do with Oracle?
Export creates a binary file.
You can't use 'insert' with a binary file.
I don't know how you can use 'export insert' for any purpose at all.
Why are you 'displaying' things if the goal is to move data?
If you just want to move data from one table to another, in the same or different databases then just use
INSERT INTO table2 SELECT * from table1;
Otherwise you need to better explain WHAT PROBLEM you are trying to solve.
One thing you have to be careful about is to not ask Oracle to helpfully change database information for you. One way to do this is to be careful all NLS and characterset definitions are the same throughout the process. That includes both server and client environments. Details may vary by version.
The sqldeveloper answer.
You should delve into the globalization manual to reconcile the sqldeveloper answer and my answer. In a nutshell, you want to avoid data conversions between databases that change your data. So if everything is the same, no conversion is made, even if the data isn't legal in the characterset. But the display may require a conversion to look correct. You should learn how to use the dump command in sqlplus to understand if the data has actually changed. If you can't avoid a conversion, as for example in the BCG doc, be sure you understand what will be converted. There are tools to tell you that, which ones depend on the version.
So remember, when asking questions like this, post the exact versions involved, and all the NLS and characterset information for every environment involved.
Also see Globalization Support