The procedure ADMIN_COPY_SCHEMA can be used to copy a schema and its contents. The same object names will be used and placed into the target schema specification. The new tables can be created with or without data from the source. The syntax for the copy schema procedure is:
SYSPROC.ADMIN_COPY_SCHEMA
([SourceSchema], [TargetSchema], [CopyMode], [ObjectOwner],
[SourceTBSP], [TargetTBSP], [ErrorTableSchema], [ErrorTable])
CALL SYSPROC.ADMIN_COPY_SCHEMA ('ERP', 'TEST', 'COPY', NULL, '', ' ','ERROR', 'ERP_ERROR_INFO');
If ADMIN_COPY_SCHEMA copies a schema, guess what ADMIN_DROP_SCHEMA does? It drops a specific schema, and all of the objects contained it.
