A. SOURCE: SOURCE_DB – PRODUCTION 1. Connect the database SOURCE_DB as SYS user. 2. Execute the query “SELECT dbms_flashback.get_system_change_number FROM dual;” to get the FLASHBACK_SCN value. 3. Prepare the parameter file as mentioned below for both the schemas sepearately. SOURCE_DB_SCHEMA ( Assuming schema size is >100GB ) USERID=USERID/PASWORD@SOURCE_DB DIRECTORY=REFRESH_DIR DUMPFILE=REFRESH_SOURCE_DB_TO_TARGET_DB_%U.DMP SCHEMAS=SOURCE_DB_SCHEMA EXCLUDE=STATISTICS LOGFILE=REFRESH_SOURCE_DB_TO_TARGET_DB.LOG PARALLEL=4 FLASHBACK_SCN= [...]

As per the requirement from the Application, we had to change the database character set on one of the existing test databases. This can be done by using CSSCAN Utility and CSALTER Script. Database character set migration has two stages: Data scanning (csscan) Data conversion (csalter.plb) The CSSCAN Utility is used to denitrify possible database [...]