Hi we have an oracle 10g r2 database running in production which hosts BI database
it is in noarchivelog mode.
we normally take a exp dump of the 15G database on a ext3 filesystem and take a backup of the filesystem daily.
bold the oracle is running on suse linux itanium server 10 SP2
bold
always i find that
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
now if i import this into another database which i create afresh after restoring it from the backup (HPDP) i bump into
"IMP-00017: following statement failed with ORACLE error 1452"
i tried to import it into a oracle database which was installed in SLES 10 SP3 installed on x86_64 platform and not itanium as in production
how can i avoid these errors
please help. tried some googling and found a few things about NLS_LANG
. NLS_LANG parameter
should i change the NLS_LANG parameter on the OS or database where i am importing this?