Re: Creating duplicate Tables

   Others may have better ideas but you could export table A. Rename table A to table B. Import table A. Now you have a table and a complete copy in your schema.

   Then export table A and table B. Import them into the second schema using FROMUSER and TOUSER. Then you will have four copies of A - two in schema 1 and two in schema 2.

Van

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!