incremental export says: EXP-00008: ORACLE error 1438 encountered [message #70007] |
Tue, 02 April 2002 06:08 |
kou
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Hi,
while trying to do an incremental export i'm getting this error.
# exp sys/**** inctype=incremental file=file.dmp
Export: Release 8.1.7.0.0 - Production on Tue Apr 2 16:00:04 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in EE8MSWIN1250 character set and EE8MSWIN1250 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
.
.
.
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. about to export OUTLN's tables via Conventional Path ...
. about to export DBSNMP's tables via Conventional Path ...
. about to export TRACESVR's tables via Conventional Path ...
. about to export AURORA$JIS$UTILITY$'s tables via Conventional Path ...
. about to export OSE$HTTP$ADMIN's tables via Conventional Path ...
. about to export AURORA$ORB$UNAUTHENTICATED's tables via Conventional Path ...
. about to export USER1's tables via Conventional Path ...
. . exporting table WWV_DOCUMENT
EXP-00008: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
. about to export USER2's tables via Conventional Path ...
. about to export USER3's tables via Conventional Path ...
. about to export USER4's tables via Conventional Path ...
. . exporting table TABLE1
EXP-00008: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
. . exporting table TABLE2
EXP-00008: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
. . exporting table TABLE3
EXP-00008: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
.
.
.
.
. . exporting table TABLEXX
EXP-00008: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
. exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
EXP-00008: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
EXP-00000: Export terminated unsuccessfully
This error occurs with every table. There's no problem with full export, just the incremental one.
When it says "value larger than specified precision allows for this column" , i could understand that while doing import, but where's the problem with export
???
Thanx a lot for any help
Kou
|
|
|
Re: incremental export says: EXP-00008: ORACLE error 1438 encountered [message #70009 is a reply to message #70007] |
Tue, 02 April 2002 08:04 |
Melissa
Messages: 65 Registered: January 2000
|
Member |
|
|
Problem Description:
====================
You are performing an incremental or cumulative export and you receive the
following errors:
EXP-00008: Oracle error 1438 encountered
Cause: Encountered ORACLE error.
Action: Check ORACLE DBMS manual for the ORACLE error and take
appropriate action.
ORA-01438: value larger than specified precision allows for this column
Cause: When inserting or updating records, a numeric value was
entered that exceeded the precision defined for the column.
Action: Enter a value that complies with the numeric column's
precision, or use the MODIFY option with the ALTER TABLE
command to expand the precision.
You can successfully perform a full, user, or table level export.
Problem Explanation:
====================
Every time you perform an incremental or cumulative export the expid is
incremented by 1 and will only reset if you do an INCTYPE=COMPLETE export.
Performing an export by specifying full=y does not reset the table.
There are 3 tables (INCEXP,INCFIL,INCVID) that are used by incremental or
cumulative exports. If you select expid from incfil it should be 999. The
expid is defined as number(3), so it will not be able to increment to 1000.
Search Words:
=============
EXP-8 ORA-1438
Solution Description:
=====================
Do the following:
1. Do a COMPLETE export to reset expid.
2. SELECT EXPID FROM SYS.INCFIL;
If the value equals 999, than perform a COMPLETE export.
For example: exp system/manager inctype=complete file=exp.dmp
3. After the complete export has finished, perform a cumulative or
incremental export. The export should be successful this time.
|
|
|
|