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

Home -> Community -> Usenet -> c.d.o.server -> Re: "rename" and "create table x as select *" questions

Re: "rename" and "create table x as select *" questions

From: <kal121_at_yahoo.com>
Date: Tue, 01 Jun 1999 19:49:06 GMT
Message-ID: <7j1dfi$d9u$1@nnrp2.deja.com>


In article <37504d67_at_discussions>,
  "sganesh" <sganesh_at_apple.com> wrote:
>
> Hi ,
>
> 1) Rename will not take time however large the table is, it will just
update some dict tables.
>
> 2) This create statement WILL TRANSFER ALL DATA FROM SECOND TABLE
MEETING THE CONDITION TO FIRST TABLE. So it will take very long time..

This is wrong. "WHERE 1 = 2" will NOT transfer the data over. Therefore, your table will be created very quickly.

>
> Sanjay.
>
> Ying-fen Hu <yhu_at_generalmicro.com> wrote:
> >Dear Oracle Gurus,>
> >I have two questions:
> >
> >1. Will "rename" take a long time if the table is large? What are
> >involved in the rename process?
> >2. Will "create table x as select * from table y where 1=2;" take
a
> >long time if table y is very large (8 million rows)? I think it
will.
> >Although, this statement will create the structure only and no data
are
> >transferred to table y, the "where" clause will go through the usual
SQL
> >process. Therefore, if the table is large (millions of rows), the
> >statement will take longer than if the table is smaller (hundreds of
> >rows). Is it correct? I'd like to know what's happening behind the
> >statement.
> >
> >Thank you in advance for your reply. For reply, please also e-mail
to
> >huy_at_ncr.disa.mil.
> >
> >Ying-fen Hu
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 01 1999 - 14:49:06 CDT

Original text of this message

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