| Object | Number | Invalid | Estimated cost | Comments | Details |
|---|---|---|---|---|---|
| DATABASE LINK | 4 | 0 | 12 | Database links will be exported as SQL/MED PostgreSQL's Foreign Data Wrapper (FDW) extentions using oracle_fdw. | |
| FUNCTION | 2 | 0 | 9 | Total size of function code: 421 bytes. | get_tab_ptf: 4 get_tab_tf: 3 |
| INDEX | 29 | 0 | 4.8 | 17 index(es) are concerned by the export, others are automatically generated and will do so on PostgreSQL. Bitmap index(es) will be exported as b-tree index(es) if any. Cluster, domain, bitmap join and IOT indexes will not be exported at all. Reverse indexes are not exported too, you may use a trigram-based index (see pg_trgm) or a reverse() function based index and search. Use 'varchar_pattern_ops', 'text_pattern_ops' or 'bpchar_pattern_ops' operators in your indexes to improve search with the LIKE operator respectively into varchar, text or char columns. | 5 domain index(es) 1 function based b-tree index(es) 11 b-tree index(es) |
| JOB | 0 | 0 | 0 | Job are not exported. You may set external cron job with them. | |
| MATERIALIZED VIEW | 2 | 0 | 6 | All materialized view will be exported as snapshot materialized views, they are only updated when fully refreshed. | |
| PACKAGE BODY | 2 | 0 | 44 | Total size of package code: 2992 bytes. Number of procedures and functions found inside those packages: 6. | emp_mgmt.create_dept: 3 emp_mgmt.hire: 11 emp_mgmt.increase_comm: 3 emp_mgmt.increase_sal: 3 emp_mgmt.remove_dept: 3 emp_mgmt.remove_emp: 3 |
| PROCEDURE | 2 | 0 | 8 | Total size of procedure code: 772 bytes. | secure_dml: 3 add_job_history: 3 |
| SEQUENCE | 4 | 0 | 0.4 | Sequences are fully supported, but all call to sequence_name.NEXTVAL or sequence_name.CURRVAL will be transformed into NEXTVAL('sequence_name') or CURRVAL('sequence_name'). | |
| SYNONYM | 0 | 0 | 0 | SYNONYMs will be exported as views. SYNONYMs do not exists with PostgreSQL but a common workaround is to use views or set the PostgreSQL search_path in your session to access object outside the current schema. | emp_details_view_v is an alias to HR.EMP_DETAILS_VIEW public.emp_table is a link to hr.employees@curr_user offices is an alias to HR.LOCATIONS |
| TABLE | 36 | 0 | 18.2 | 1 external table(s) will be exported as file_fdw foreign table. See EXTERNAL_TO_FDW configuration directive to export as standard table or use COPY in your code if you just want to load data from external files. 2 check constraint(s). | 1 binary columns 5 unknow types Total number of rows: 1552 Top 5 of tables sorted by number of rows: customer_summary has 1154 rows employees has 107 rows user_role has 55 rows t1 has 32 rows departments has 27 rows |
| TABLE PARTITION | 2 | 0 | 0.2 | Partitions are exported using table inheritance and check constraint. Hash partitions are not supported by PostgreSQL and will not be exported. | 1 range partitions |
| TABLE SUBPARTITION | 2 | 0 | 0.4 | ||
| TRIGGER | 6 | 1 | 36 | Total size of trigger code: 2120 bytes. | check_raise_on_avg: 18 update_job_history: 3 ioft_emp_perm: 3 ioft_insert_role_perm: 3 |
| TYPE | 3 | 0 | 2 | 2 type(s) are concerned by the export, others are not supported. Note that Type inherited and Subtype are converted as table, type inheritance is not supported. | 2 nested tables 1 object type |
| VIEW | 4 | 0 | 4 | Views are fully supported. | |
| Total | 98 | 1 | 145 | 145 cost migration units means approximatively 2 man-day(s). The migration unit was set to 5 minute(s) | |