I doing full import of 10g export into 19c. export/import via user with exp_full_database privilege/imp_full_database have few questions?
1. is it safe to import full=y option. will it overwrite procedures with 10g version/duplicate data in system schema.
what about other default schema for eg . *sys schemas/XDB,APEX . will it overwrite?
other components dependancies [workspace manager] .
how to safely import only application schema including other components dependancies.
2. how to find out dependancies of application schema on components [ dba_features_usage ?]?
1) Yes. DataPump knows about this kind of stuff. Just remember that you do NOT use SYS for Datapump. Use SYSTEM for a full import.
Note that because of this, you'll see occasionally warnings in the logs due to objects already present so check your logs carefully at the end to ensure you don't miss any errors pertaining to *your* objects.
2) Yes DBA_FEATURE_USAGE_STATISTICS
but also DBA_DEPENDENCIES to see what objects of yours are referencing Oracle owned schemas, eg
SQL> select distinct owner, name
2 from dba_dependencies
3 where owner NOT in ( select username from dba_users where oracle_maintained = 'Y' )
4 and referenced_owner in ( select username from dba_users where oracle_maintained = 'Y')
5 and owner != 'PUBLIC';
OWNER NAME
------------------------------ -------------------------------------------------------------
MCDONAC PRD
MCDONAC MASK_TRANSLATE
MCDONAC NUMLIST
MCDONAC XML_PAYMENT_WINDOW
MCDONAC E_ADDRESS_OBJ
MCDONAC T_TYPE
...
...