ORA-01732 while doing parallel export-import
Source database version: --> 9.2.0.6
Target database version : --> 9.2.0.6
I am doing parallel export-import
Case 1:
======
E1.Export full db with rows=n from source (only metadata).
E2.Export all schemas seperately from source with rows=y.
F1. Import E1 on target to create all metadata with constraints=Y.
F2. Import all schemas paralalley with constraints=Y.
We get this error for 10% of the MVs:
. . importing table "ISC_DBI_CFM_002_MV" 386 rows imported
. . importing table "ISC_DBI_CFM_003_MV"
Note: table contains ROWID column, values may be obsolete
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_004_MV" 1053 rows imported
. . importing table "ISC_DBI_CFM_005_MV" 229 rows imported
. . importing table "ISC_DBI_CFM_006_MV"
Note: table contains ROWID column, values may be obsolete
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_007_MV"
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_008_MV"
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_009_MV" 0 rows imported
. . importing table "ISC_DBI_CFM_010_MV"
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_011_MV" 0 rows importe
Case 2:
======
E1.Export full db with rows=n from source (only metadata).
E2.Export all schemas seperately from source with rows=y.
F1. Import E1 on target to create all metadata with constraints=Y.
F2. Disable all Foreign key constraints.
F3. Import all schemas paralalley with constraints=Y.
We get this error for 10% of the MVs(similar to Case 2):
. . importing table "ISC_DBI_CFM_002_MV" 386 rows imported
. . importing table "ISC_DBI_CFM_003_MV"
Note: table contains ROWID column, values may be obsolete
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_004_MV" 1053 rows imported
. . importing table "ISC_DBI_CFM_005_MV" 229 rows imported
. . importing table "ISC_DBI_CFM_006_MV"
Note: table contains ROWID column, values may be obsolete
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_007_MV"
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_008_MV"
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_009_MV" 0 rows imported
. . importing table "ISC_DBI_CFM_010_MV"
IMP-00058: ORACLE error 1732 encountered
ORA-01732: data manipulation operation not legal on this view
. . importing table "ISC_DBI_CFM_011_MV" 0 rows importe
Some of the MV's are imported but some errored out.
There is a bug related to ORA-01732 for import where this error comes if the MV
is already existing and we try to import it. But in our case this error comes
even when that MV is not present in the target (before import)
Regards
Neeraj