prompt Package Header : jr_migrate

create or replace package jr_migrate is

  --------------------------------------------------------------------------------------------
  -- Procedure : migrate_schema
  --
  -- Migrate instance data from a registered schema into repository
  --
  -- Pre-requisite : The schema must have been registered and generated in the repository
  --
  -- Parameters :
  --  schema_name           : Name of schema to be migrated
  --
  --  workarea_name         : Name of workarea in which to create instance data
  --
  --  folder_name           : Name of folder in which to create instance data
  --
  --  log_file_location     : Location of file on server to write a log of
  --                          what gets processed (must be named in init.ora
  --                          file as value of utl_file_dir parameter)
  --
  --  migrate_file_location : Directory on server to write sql migration script
  --
  --  log_file_name         : Name of log file (location must also be set)
  --
  --  migrate_file          : Name of migrate file for sql to migrate user data
  --------------------------------------------------------------------------------------------
  procedure migrate_schema ( schema_name            varchar2
                           , workarea_name          varchar2
                           , folder_name            varchar2
                           , log_file_location      varchar2  default null
                           , migrate_file_location  varchar2  default null
                           , log_file_name          varchar2  default 'jrmig.log'
                           , migrate_file           varchar2  default 'jrmig.sql'
                           );


end jr_migrate;
/