Topic: Backup & Recovery >> IMPORTING ERROR
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| SHAKEEL |
Posted: Nov 12, 2005 01:50:49 PM |
Total Post: 4
Joined: Nov, 2005
|
i take backp of Oracle 9i from one system installing Window XP 2004 and import that file in Oralce 9i second system having Window 2000, then i recevied that error
C:\>IMP
Import: Release 9.0.1.1.1 - Production on Fri Nov 4 02:44:04 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Username: USER_NAME
Password: *********
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Import file: EXPDAT.DMP > D:\EXPORT_FILE.DMP
Enter insert buffer size (minimum is 8192) 30720>
IMP-00016: required character set conversion (type 178 to 871) not supported
IMP-00000: Import terminated unsuccessfully
so can u solve my problem. if i import that file in any system having window 2000. it import successfully but o
|
|
|
 Arulselvaraj |
| Posted: Jan 01, 2006 02:06:50 PM |  |
|
Total Post: 15
Joined: Dec, 2005
|
Set NLS_LANG environment variable while importing to the one which is there for the database where you have taken an export.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
