For copying a target type definition from one environment to another, proceed with the following steps:
- 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):
FROM target_type_attributes tta,
WHERE tt.id = tta.target_type_id
AND tt.type_name = 'dm_document';
Define the type in target environment.
Import the type definition from the CSV file created in the first step by using "Import from file" functionality in the object type screen.