impdp

AWS RDS to OCI Migration –(Oracle Data Pump Based)

Introduction Migrating Oracle databases from AWS RDS to Oracle Cloud Infrastructure (OCI) is a common requirement for organizations adopting OCI-native services, improving performance, or reducing licensing and operational constraints. Unlike on-premise databases, AWS RDS restricts OS-level…

Read More

Script to fix export issue while it hangs during Statistics, Marker, Type

Please run the below and do the export again. create index SYS.IMPDP_STATS_1 ON SYS.IMPDP_STATS (c5,type,c1,c2,c3,c4,statid,version);    

Read More

How to resolve ORA-39083 error during import

Error: =========== We came across below ORA error during import of Schema ORA-39083: Object type TYPE:”FMSDEV”.”SAMPLE_TYPE_TABLE” failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: CREATE…

Read More

Schema Refresh

SCHEMA REFRESH In this Post , Let us discuss the steps involved during schema refresh using datapump. Prerequisite to check on Before Export on SOURCE SIDE 1. Check the Schema…

Read More