...
| No Format |
|---|
-- Run on Source & post imported target db spool del_constraints.txt column owner format A35 set pagesize 4000 set linesize 132 select owner, constraint_name, delete_rule,status FROM dba_constraints where delete_rule = 'CASCADE' and owner not in ( 'XDB','SYS','SYSTEM','SYSMAN','WMSYS','OLAPSYS','MDSYS','APEX_030200','FLOWS_FILES', 'EXFSYS','APPQOSSYS','CTXSYS','ORDDATA','OUTLN','DBSNMP','ORDSYS','DBVREP','APEX_040200','LBACSYS') order by 1,2; spool off |
Check for Compressed tables (partitioned & non-partitioned)
| No Format |
|---|
-- Run on Source as a pre-check
REM ****************************
REM Compressed table list
REM ****************************
set linesize 200
spool list_compressed.txt
ttitle left '***** Table Compression Assessment *****' skip 2
btitle off
SELECT owner, table_name, compression
FROM dba_tables
where owner not in ('XDB','SYS','SYSTEM','SYSMAN','WMSYS','OLAPSYS','MDSYS','APEX_030200','FLOWS_FILES',
'EXFSYS','APPQOSSYS','CTXSYS','ORDDATA','OUTLN','DBSNMP','ORDSYS','DBVREP',
'APEX_040200','LBACSYS')
and compression = 'ENABLED'
order by 1,2;
ttitle left '***** Partitioned Table Compression Assessment *****' skip 2
btitle off
SELECT table_owner,table_name, partition_name, compression
from dba_tab_partitions
where table_owner not in ('XDB','SYS','SYSTEM','SYSMAN','WMSYS','OLAPSYS','MDSYS','APEX_030200','FLOWS_FILES',
'EXFSYS','APPQOSSYS','CTXSYS','ORDDATA','OUTLN','DBSNMP','ORDSYS','DBVREP',
'APEX_040200','LBACSYS')
and compression = 'ENABLED'
order by 1,2,3;
spool off |
Check for Encryption & encrypted columns
| No Format |
|---|
-- Run on Source as a pre-check
REM ****************************
REM *** Encryption
REM ****************************
spool list_encrypt.txt
ttitle left '***** Encryption Assessment *****' skip 2
btitle off
select * from dict where lower(table_name) like '%encrypted%';
select owner, table_name, COLUMN_NAME, ENCRYPTION_ALG
from DBA_ENCRYPTED_COLUMNS
where owner not in ('XDB','SYS','SYSTEM','SYSMAN','WMSYS','OLAPSYS','MDSYS','APEX_030200','FLOWS_FILES',
'EXFSYS','APPQOSSYS','CTXSYS','ORDDATA','OUTLN','DBSNMP','ORDSYS','DBVREP',
'APEX_040200','LBACSYS')
order by 1,2,3;
spool off |