Demantra Installation Importing Issue IMP-00058: ORACLE error 1950 encountered, ORA-01950: no privileges on tablespace( Doc ID 2094007.1)
Demantra installation issue
Install Demantra 12.2.5.1 (patch 21951481) we are getting error:
IMP-00058: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'DEV'
ORA-01950: no privileges on tablespace 'DEV'
That implies, do not have access to Apps table space even though another demantra tablespace in the installation screen for standalone databases is working normal and was able to finish the installation.
Solution:
From internal Bug 12624910
The problem is new feature introduced in 11.2 database version.
The workaround is to run the following:
ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=FALSE;
This causes the import to work properly.
Please review this Note, which has more information on DEFERRED_SEGMENT_CREATION parameter:
11.2 Database New Feature Deferred Segment Creation [Video] (Doc ID 887962.1)
The problem is new feature introduced in 11.2 database version.
The workaround is to run the following:
ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=FALSE;
This causes the import to work properly.
Please review this Note, which has more information on DEFERRED_SEGMENT_CREATION parameter:
11.2 Database New Feature Deferred Segment Creation [Video] (Doc ID 887962.1)
Same issue occurred for 12c database also and this above solution has resolved. Can be applied for 12c Database as well.
No comments:
Post a Comment