Hi All,
I have installed Oracle 11g database and oracle 10g as client on my local pc.
Now, i'm trying to export few table's data from production which is Oracle 10g into my local pc using
exp .
I can't use expdp as I don't have access to production server.
My local database version:
----------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Production database version
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
From my local pc's command prompt i'm running as..
exp username/pass@proddb tables=(a,b,c) file=abc.dmp
When i executed above command i was hit with below error :
About to export specified tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully
When DBA exports using
exp from UNIX environment they were able to do it successfully, but when i'm trying from my windows(11g), i'm was not able to do it.
I had gone through forum and other sites before posting this.. but we can't use expdp or ask dba to run the patch availlable in MOSC.
If i install oracle 10g on my local pc, will i be able to export successfully using
exp ?
I'm trying for a work-around, share your views on this.
Thanks.