The following error messages are observed when activating a config file that contains temporary tables:
sp_ctrl > activate config <configfile_name>
WARNING, not all objects activated successfully. Check activation log.
The corresponding event log entries are:
Warning 2011-05-12 15:48:10.136680 16769 4119836352 Activation: Cannot replicate temporary table. Skipping ("OWNER"."TABLENAME") (activating sid SIDname) [module ocf]
Shareplex does not allow replication of temporary tables.
Shareplex did not bring the temporary table(s) into replication. However, if “list config” shows an active config, then Shareplex has successfully activated other tables. For future activation, avoid including temporary tables in config file.
Refer to Shareplex Reference Guide, Shareplex Administrator Guide and Release Notes for the type of objects that Shareplex replicates.
