Very true
>Thanks & Regards,
>Ajit Saggu
>Foundation Services
>BLACKROCK
>33 King William Street
>London,
>EC4R 9AS.
>' +44 (0)20 7743 4544
>
-----Original Message-----
From: William J Koster
[mailto:oracledba-ezmlmshield-x6630251.[Email address protected]
Sent: 31 December 2007 12:44
To: LazyDBA Discussion
Subject: Re: create table as select cuestion
No, it's because you've got parens around the '*', and '(*)' is not a
valid expression.
Just use create table IE_DE4_DEMMA_BCK as select * from
ATD_IE_DE4.DEMMA;
Bill
Computer Sciences Corporation
Registered Office: 2100 East Grand Avenue, El Segundo California 90245,
USA Registered in USA No: C-489-59
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind CSC
to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of
e-mail for such purpose.
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------------------------------
"Luis Cardenas "
<oracledba-ezmlms
hield-x25862108.x
To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
12/31/2007 07:39
AM
Subject
create table as select cuestion
Hi there I am attempting to:
SQL> create table IE_DE4_DEMMA_BCK as select (*) from ATD_IE_DE4.DEMMA;
create table IE_DE4_DEMMA_BCK as select (*) from ATD_IE_DE4.DEMMA
*
ERROR at line 1:
ORA-00936: missing expression
Is this because there are no records in the DEMMA table?
SQL> select count (*) from ATD_NL_DE4.DEMMA;
COUNT(*)
----------
0
Thanks
Luis
-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited, registered
office: Unit 6, Thatcham Business Village, Colthrop Lane, Thatcham,
Berkshire RG19 4LW (Registered in England No. 4768840). This email and
any files transmitted with it are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you
have received this email in error please notify the sender. This email
message has been swept for the presence of computer viruses.
www.ciphertrust.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
---------------------------------------------------------------------
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
THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, copying or use of this message and any attachment is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and permanently delete it from your computer and destroy any printout thereof.
Oracle LazyDBA home page