{"type":"doc","content":[{"type":"paragraph","content":[{"text":"The Oracle database plugin uses two operations to synchronize the database structures within a schema. In the source or build environment, the user has the option to either use the recreateBuildDB operation to drop and recreate the database objects based on a supplied SQL/DDL file. The second option is to make the changes in the build database using a tool like SQL Developer or SQL plus. The createBaseline operation is used by the build process in FlexDeploy to store this version of the schema in a DDL repository. During the deployment, the sync operation will then compare this baseline to the existing baseline in that environment. The compare generates the creates, drops, or alters that are necessary to make the target database structures look like the source database structures. Additional operations are available to recompile invalid objects, refresh materialized view, or drop unused columns. These operations can optionally be included in the defined workflow.","type":"text"}]},{"type":"paragraph","content":[{"text":"The plugin respects table locks, so if a table has locks disabled, the operations will not be able to delete them or modify them. This is a precaution against user error. If you wish to drop or change them, please enable locks first.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"DDL Repository","type":"text"}]},{"type":"paragraph","content":[{"text":"The baselines are stored in a DDL repository. You must create the DDL Repository schema, see install and update scripts at ","type":"text"},{"type":"mediaInline","attrs":{"id":"9b2c7ed3-3d60-4c02-b533-7aff198df94f","collection":"contentId-10926953762"}},{"text":" . DDL repository needs to be created in FDDB schema, script provided does not create FDDB schema, you may do that per your company standards. If you are upgrading from version prior to 5.1.07, then run ","type":"text"},{"text":"upgrade/v4.6.0.3-to-5.1.0.7/migration.sql","type":"text","marks":[{"type":"em"}]},{"text":" to upgrade your repository schema. Then, run upgrade/5.1.0.7-to-5.2.3.1/migration.sql and upgrade/5.2.3.1-to-5.4.0.4/migration.sql. If you were already at a version higher then 5.1.0.7, then only the second migration.sql needs to be executed. If you are creating DDL repository schema, then just run ","type":"text"},{"text":"install/DDLRepositoryCreateScript.sql","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"DDL repository can be created on any Oracle database, i.e. it does not need to be in source and/or target database.","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Supported Versions","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Oracle Database 11.2, 18c, 21c (Express, Standard, and Enterprise Edition)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Oracle Database 12.1, 19c (Standard, and Enterprise Edition) ","type":"text"},{"type":"hardBreak"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Features delivered by Oracle in 12.1 (like invisible columns) are not currently supported by the plugin.","type":"text"}]}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Key Features","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Manage deployments of entire schema(s).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Manage package-based deployment of objects in a schema(s).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Supports a wide range of object types.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Source changes from an SCM or \"Build Database\".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ability to sync a schema from different starting points.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Manage object renames.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ability to simulate deployments so that generated DDL can be reviewed ahead of time.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Grants are managed with each object.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Constraints are managed with each Table and View object.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"User Permission Requirements","type":"text"}]},{"type":"paragraph","content":[{"text":"The users specified in FDORA_USER and FDORA_DDL_USER require these permissions:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GRANT EXECUTE on dbms_crypto to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GRANT SELECT_CATALOG_ROLE TO ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GRANT SELECT ANY DICTIONARY TO ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_transformations to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_objects to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_queues to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_queue_tables to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_synonyms to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_indexes to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_cons_columns to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_nested_tables to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_all_tables to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_tab_privs to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_scheduler_jobs to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_scheduler_programs to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_scheduler_schedules to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_mview_logs to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_procedures to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_aq_agents to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_queue_publishers to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_queue_schedules to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_queue_subscribers to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_queue_tables to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_dependencies to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_sequences to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_source to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_triggers to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_views to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_roles to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant READ on sys.dba_users to ;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"FDORA_USER needs Create and alter Permissions for the schemas being synced. Using the schema owner as FDORA_USER may be the easiest solution, and is needed if triggers don’t have schema-qualified table references.","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Supported Oracle Object Types","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Sequence","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Table","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Index","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Constraints","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"View","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Synonym","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Function","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Trigger","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Type Body","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package Body","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Procedure","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Columns","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Index","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Grants are also carried forward with the objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The plugin requires that constraints and indexes share the same name.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Plugin Operations","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"children","parameters":{"macroParams":{"first":{"value":"6"}},"macroMetadata":{"macroId":{"value":"61ede8ed-5c82-4ae8-b099-00258a924caa"},"schemaVersion":{"value":"2"},"title":"Child pages (Children Display)"}},"localId":"e77bc2c6-fde7-434f-8ec8-af25c2808b93"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Appendix","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Setting up an SSH tunnel to a remote database","type":"text","marks":[{"type":"link","attrs":{"href":"https://flexagon.atlassian.net/wiki/spaces/FD90/pages/10926953917"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Supported and Unsupported Table and Index options","type":"text","marks":[{"type":"link","attrs":{"href":"https://flexagon.atlassian.net/wiki/spaces/FD90/pages/10926953941"}}]}]}]}]}],"version":1}

Browser not supported