>> I need to create duplicates of certain tables. <<

Why?? One of the fundamental rules of RDBMS design is that a table
models one and only one kind of entity or relationship. If two tables
have the same structure, then they have split a set.

A lot of newbies will divide up their data by attribute splitting
(i.e. MalePersonnel and FemalePersonnel tables instead of a single
Personnel table; one table per time period; one table for location;
etc.) It is a common disaster made by people who don't know what a
table is so they mimic a magnetic tape file system or worse.