***********************
Your mail has been scanned by InterScan.
***********-***********


Please also check if this also creates existing constraints and indexes
of existing table. I think it may not

-----Original Message-----
From: ramanjulu
[mailto:oracledba-ezmlmshield-x65115946.[Email address protected]
Sent: Wednesday, August 08, 2007 8:54 PM
To: LazyDBA Discussion
Subject: RE: Create new Table from Existing One-Urget

***********************
Your mail has been scanned by InterScan.
***********-***********



Dinesh,
try this

create table NEW_TABLE_name
as
select * from OLD_TABLE

Thanks & Regards,
Ram

________________________________

From: dgaikwad [mailto:oracledba-ezmlmshield-x97044451.[Email address
protected]
Sent: Wed 08/08/2007 3:18 PM
To: LazyDBA Discussion
Subject: Create new Table from Existing One-Urget



Hi DBA's

I want to create new table from Existing
table with SELECT statement.



Thanks & Regards,
Dinesh G.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html







The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.

www.wipro.com


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






***********************************************************************************
This message is for the named addressees' use only. It may contain NSDL

confidential, proprietary or legally privileged information. If you receive

this message in error, please immediately delete it. You must not, directly

or indirectly, use, disclose, distribute, print, or copy any part of this message

if you are not the intended recipient.Unless otherwise stated, any commercial

information given in this message does not constitute an offer to deal on

any terms quoted. Any reference to the terms of executed transactions

should be treated as preliminary only and subject to our formal written

confirmation.
***********************************************************************************

Oracle LazyDBA home page