Home » RDBMS Server » Server Utilities » Unable to export users logical schema,,,!!! (ORACLE 10g , RHEL 5 , 64 bit)
Unable to export users logical schema,,,!!! [message #410335] Fri, 26 June 2009 06:55 Go to next message
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

Re: Unable to export users logical schema,,,!!! [message #410365 is a reply to message #410335] Fri, 26 June 2009 09:30 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>Before this i placed a users logical schema successfully into oracle 10g from oracle 8i where

How you imported V8 to V10? Can you post import log file? Can you confirm your database versoin (4 digit)

Thanks
Previous Topic: How to load data from a file with two types of field delimeters
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Sun Dec 11 00:24:14 CST 2016

Total time taken to generate the page: 0.04277 seconds