| Export Error EXP-00008 [message #70372] |
Tue, 04 June 2002 11:19  |
Pawan
Messages: 33
Registered: June 2002
|
Member |
|
|
I exported a user from an oracle database that uses NLS_LaNGUAGE=AMERICAN_AMERICA.US7ASCII AND
NLS_NCHAR_CHARACTERSET US7ASCII
and imported in the database that uses
NLS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1 AND
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
I got message that there is a possible conversion.
I'm able to see data using sql statements.
but when I try to export this user from new database
I get error: I also tried to set environment variable
NLS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
===============================================
Export log:
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MHB_RBS
. exporting object type definitions for user MHB_RBS
About to export MHB_RBS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export MHB_RBS's tables via Direct Path ...
. . exporting table AGENT
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
. . exporting table CARRIERRELATION
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table COBRATRACKER
======================================================
|
|
|
|
|
|
| Re: Export Error EXP-00008 [message #70376 is a reply to message #70372] |
Tue, 04 June 2002 13:10  |
Pawan
Messages: 33
Registered: June 2002
|
Member |
|
|
Source Database: the database from which I exported is
NLS_RDBMS_VERSION 8.1.7.0.0
Target Database: the database to which I did import. and now I'm trying to export is
NLS_RDBMS_VERSION 8.1.6.0.0
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
