| Unable to export users logical schema,,,!!! [message #410335] |
Fri, 26 June 2009 06:55  |
sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA
|
Member |
|
|
Hi All,
I tried to export a user schema from oracle 10g but is throwing the following error.
********************************************************************************************
Error:
_______
[oracle@mail2 new]$ exp sachin/sachin file=newkefsdump.dmp owner=kefs log=newlogklms.log
Export: Release 10.2.0.1.0 - Production on Fri Jun 26 17:16:45 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user KEFS
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: : invalid identifier
EXP-00000: Export terminated unsuccessfully
[oracle@mail2 new]$
***************************************************************************************
Before this i placed a users logical schema successfully into oracle 10g from oracle 8i where in which 8i was using US7ASCII char set.
I feel there is mismatch in char sets.
Someone guiding from here on will be a great help.
Thanks in Adv.
Sanjay
DBA
[Updated on: Fri, 26 June 2009 07:02] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
