-
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;
-
Have you done a metalink search on this? There are views that need to be installed to import/export from one version to another.
If you are upgrading a 7.3.4 database to 8i, why don't you just use the 7.3.4 client to do the export?
-
was it catexp7.sql found in $ORACLE_HOME/rdbms/admin?
-
export from 7.3 to 8.1.
with catexp7.sql i can export from 8.1 to 7.3, but i want export from 7.3 to 8.1. I try make connect from 8.1. to 7.3:
exp userid=user/passwd@ora7.3 file=... log=... tables=(xxx) ang get error:
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
Oracle v 7.3 has a export maximum size 2Gb. I have data>2Gb :(
-
I can't download the COMPATIBILITY MATRIX regarding EXPORT/IMPORT between different oracle versions/o.s. pls have reference on it.
-
is this just a one time process? or you are planning to migrate to 8i?
see gandolf's suggestion.
-
see this not in metalink: Note:132904.1
here's an excerpt:
Matrix 2: Which EXPORT utility to use when importing into an Oracle8 or a higher database release (always use IMPORT utility of the target database): +-----------+------------------------------------------------------+ | EXPORT | IMPORT into: | | from +--------+--------+--------+--------+--------+---------+ | \/ | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | +-----------+--------+--------+--------+--------+--------+---------+ | 5.x 1) 2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | | 6.x 2)| EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | | 7.x 3)| EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | +-----------+--------+--------+--------+--------+--------+---------+ | 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | | 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | | 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | | 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | +-----------+--------+--------+--------+--------+--------+---------+ | 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | | 8.1.6 | EXP815 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | | 8.1.7 | EXP815 | EXP816 | EXP817 | EXP817 | EXP817 | EXP817 | +-----------+--------+--------+--------+--------+--------+---------+ | 9.0.1 | EXP815 | EXP816 | EXP817 | EXP901 | EXP901 | EXP901 | | 9.2.0 | EXP815 | EXP816 | EXP817 | EXP901 | EXP920 | EXP920 | +-----------+--------+--------+--------+--------+--------+---------+ | 10.1.0 4)| EXP815 | EXP816 | EXP817 | EXP901 | EXP920 | 4) | +-----------+--------+--------+--------+--------+--------+---------+
-
export util
database is using in industrial system and developer's firm not permit migrate to oracle>7.3. i am wanted make full export/incremental export/cummulative export for save our data. but export file size not more 2Gb and i want use exp from 8.1.
-
The rule is, when going from version X to version Y:
- export with the lower version of X and Y, from db X
- import with version Y, into db Y
(see Tom Kyte 1-on-1 p.353)
Added later: From the manual:
Using a Higher Version Export
Attempting to use a higher version of Export with an Oracle Server often produces the following error:
EXP-37: Database export views not compatible with Export utility
EXP-0: Export terminated unsuccessfully
The error occurs because views that the higher version of Export expects are not present. To avoid this problem, use the version of the Export utility that matches the Oracle Server.
Sounds like you will have to break up the export job into pieces - generating the TABLES= statements from DBA_TABLES.
Last edited by DaPi; 10-08-2004 at 03:29 AM.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|