Re: Copying Tables.

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Mon, 08 Mar 1999 19:12:52 GMT
Message-ID: <36e620e3.18882511@newshost.us.oracle.com>

On Mon, 08 Mar 1999 13:25:14 -0500, Stan <delphi_at_yahoo.com> wrote:

>I am trying to make a very large table for testing purposes. I have a
>table with 30,000 records. Is there a way that I can copy these records
>to a temporary table, and then append them back to get 60,000 records?
>(Don't worry, I don't have a primary key open).

Just simply select all the columns from this table and insert them back into the same table using INSERT INTO..SELECT. As in:

SQL> select count(*) from emp;

  COUNT(*)

---

        14

SQL> insert into emp select * from emp;

14 rows created.

SQL> commit;

Commit complete.

SQL> select count(*) from emp;

  COUNT(*)

---

        28

>
>Stan.
>

Thanks!

Joel

Joel R. Kallman Oracle Service Industries

Columbus, OH            
jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Mar 08 1999 - 13:12:52 CST