Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to make a quick copy ?

Re: How to make a quick copy ?

From: dean <deanbrown3d_at_yahoo.com>
Date: 27 Feb 2007 10:40:19 -0800
Message-ID: <1172601619.874244.64310@q2g2000cwa.googlegroups.com>


On Feb 27, 12:27 pm, Jerome Vitalis
<vitalismanN0S..._at_gmail.com.invalid> wrote:
> Peter Keckeis wrote:
> > Hi all,
>
> > what do you suggest to copy about 2000000 rows from table_a to table_b,
> > where both have the same column definitions?
>
> > Oracle 10g
>
> > Is this a possible solution?
> > SQL> CREATE TABLE table_b AS (SELECT * FROM table_a);
>
> > or how can i, after exporting table_a with the EXP utility,
> > import the data into the new table_b?
>
> > or do you have a better way?
>
> You can use CTAS in NOLOGGING mode to speed things up. Be sure to read
> about all the implications of this clause before using it.- Hide quoted text -
>
> - Show quoted text -

truncate table A;

insert /* +append*/ into A select * from B;

Would that not work? Received on Tue Feb 27 2007 - 12:40:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US