Export from 7.3 with 8.1.7 client
Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it
should work.
EXP-00008: ORACLE error 942 encountered
ORA-00942: Tabelle oder View nicht vorhanden
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
But why am I getting these error messges? What scripts need to be run to
solve this problem?
Oracle 7.3: Solaris 2.5;
Oracle 8.1.7: Win2k;
export a 7.3.3 database with a 8.1.7 export utility
I found solution for this problem:
Make export:
mknod export_pipe p
chmod 666 export_pipe
nohup split -b 1024m
exp userid=user/passwd file=/..../export_pipe...
Make import:
mknod import_pipe p
chmod 666 import_pipe
nohup cat xaa xab xac>import_pipe&
imp userid=user/passwd file=/.../import_pipe ignore=yes