ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 32 into a target database with TSTZ version 31.

I got this error while trying to perform an import from another 19c database but apparently with a higher TZ version: The solution is to perform the TZ upgrade of the database. Check the current time zone version: Let’s see what’s the latest time zone to which we can upgrade to: We can see that…

How to include roles and grants into datapump export

For sure one way to do it, would be this one: Prepare the parameters file first: FULL=YES INCLUDE=SCHEMA:”IN (SELECT ‘PUBLIC’ FROM DUAL UNION SELECT username FROM dba_users WHERE username in (‘DB_USER1′,’DB_USER2’))” INCLUDE=PUBLIC_SYNONYM/SYNONYM:”IN (SELECT synonym_name FROM dba_synonyms WHERE owner = ‘PUBLIC’ AND table_owner in (‘DB_USER1′,’DB_USER2’))” DIRECTORY=DATA_PUMP_DIR DUMPFILE=orcl_expdp.dmp LOGFILE=orcl_expdp.log INCLUDE=ROLE:”IN (select role from dba_roles where role in…

How to include roles and grants into datapump export

For sure one way to do it, would be this one: Prepare the parameters file first: FULL=YES INCLUDE=SCHEMA:”IN (SELECT ‘PUBLIC’ FROM DUAL UNION SELECT username FROM dba_users WHERE username in (‘DB_USER1′,’DB_USER2’))” INCLUDE=PUBLIC_SYNONYM/SYNONYM:”IN (SELECT synonym_name FROM dba_synonyms WHERE owner = ‘PUBLIC’ AND table_owner in (‘DB_USER1′,’DB_USER2’))” DIRECTORY=DATA_PUMP_DIR DUMPFILE=orcl_expdp.dmp LOGFILE=orcl_expdp.log INCLUDE=ROLE:”IN (select role from dba_roles where role in…

In how much time will RMAN or Datapump finish the job?

This is how you can see it: RMAN SQL>alter session set nls_date_format=’dd/mm/yy hh24:mi:ss’; SQL>select sid, totalwork, sofar,(sofar/totalwork) * 100 per_done,start_time, sysdate + time_remaining/3600/24 end_at from v$session_longops where totalwork > sofar and lower(opname) not like ‘%aggregate%’ and lower(opname) like ‘rman%’; SID START_TIME        TOTALWORK SOFAR   PER_DONE END_AT —– —————– ———- ———- ———- —————– —————– 491 18/08/10 20:13:45…