How to copy a target type definition from one environment to another

For copying a target type definition from one environment to another, proceed with the following steps:

  1. Export the type definition as a CSV file by running the following query in SQL Developer, select the data, right click and choose export (replace the name of the type in the query first):

    SELECT  tta.name,
          tta.data_type,
        tta.min_length,
        tta.max_length,
        tta.is_repeating,
        tta.is_mandatory
    FROM target_type_attributes tta,
        target_types tt
    WHERE tt.id = tta.target_type_id
        AND tt.type_name = 'dm_document';
  2. Define the type in target environment.

  3. Import the type definition from the CSV file created in the first step by using "Import from file" functionality in the object type screen.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.