Need advice to Migrate 11g to 12c using datapump [message #675613] |
Wed, 10 April 2019 04:20 |
prabhaher
Messages: 11 Registered: December 2009 Location: Muscat
|
Junior Member |
|
|
Dear all,
My current database version is 11.2.0.3. I want to migrate to 12C release 2 using datapump. I have already created the dump file using Expdp.
I created oracle database in 12c. when I imported in my CDB using Impdp I am got the block error ora-29339.
So for testing purpose I have created the tablespace in sql editor and tried to import only one schema in that tablespace. when I imported using Impdp I got error ORA-39083:Object type USER:"TESTUSER" failed to create with error:
When i googled i found, it can be solved using the query alter system set '_oracle_script'='true'
My question is how this script can be used in Impdp to create the users and import the data?
Please guide me.
Thanks in Advance
[Updated on: Wed, 10 April 2019 04:22] Report message to a moderator
|
|
|