aha, thought as much, you can't copy a LONG using create table as (LONGs
BAD, CLOBS GOOD)

what version / platform are you on?

-----Original Message-----
From: Ric Jones [mailto:Ric.[Email address protected]
Sent: 30 September 2004 14:22
To: [Email address protected]
Subject: RE: Create Table


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text



Before acting on this e-mail or opening any attachments you are advised to
read The Caudwell Holdings group of companies' disclaimer at the end of this
e-mail.
--------------------------------------------------------



I think it might be :

ERROR at line 1:
ORA-00997: illegal use of LONG datatype

Which is what I got when I tried it...

Ric.

-----Original Message-----
From: Nick Cowe
[mailto:oracledba-ezmlmshield-x19722190.[Email address protected]
Sent: 30 September 2004 14:16
To: LazyDBA Discussion
Subject: RE: Create Table

what is the error message preventing the create table as?

-----Original Message-----
From: Marcelo Borges Martins (TI)
[mailto:oracledba-ezmlmshield-x59175669.[Email address protected]
Sent: 30 September 2004 13:38
To: LazyDBA Discussion
Subject: RES: Create Table


there is a blank after word "OLD".

ps: you are a poor JDE DBA or CNC! My feelings...

> ----- Mensagem original -----
> De: kamran
> [SMTP:oracledba-ezmlmshield-x88898911.[Email address protected]
> Enviada em: quinta-feira, 30 de setembro de 2004 09:28
> Para: LazyDBA Discussion
> Assunto: Create Table
>
>
> Hi All,
>
> I am executing the following command but getting error datatype too
long
>
> CREATE TABLE TR7334.F983051OLD AS SELECT * FROM TR7334.F983051
>
> I just want to have a copy the table F983051 with all data as well. I
> cant use export import through Enterprise Manager as there is no
> Management Server added. Please advise on syntax or some other way to
> copy table and all data.
>
> Regards
>
> Kam
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------------------------------------------------------


Confidentiality Notice
This e-mail is confidential and intended for the use of the named recipient
only. If you are not the intended recipient please notify us by telephone
immediately on +44(0)1782 600600 or return it to us by e-mail. Please then
delete it from your system and note that any use, dissemination, forwarding,
printing or copying is strictly prohibited.
Any views or opinions are solely those of the author and do not necessarily
represent those of The Caudwell Holdings group of companies.
Encryptions and VirusesPlease note that this e-mail and any attachments have
not been encrypted. They may therefore be liable to be compromised. Please
also note that it is your responsibility to scan this e-mail and any
attachments for viruses. We do not, to the extent permitted by law, accept
any liability (whether in contract, negligence or otherwise) for any virus
infection and/or external compromise of security and/or confidentiality in
relation to transmissions sent by e-mail.

Monitoring Activity and use of The Caudwell Holdings group of companies'
systems is monitored to secure its effective use and operation and for other
lawful business purposes. Communications using these systems will also be
monitored and may be recorded to secure effective use and operation and for
other lawful business purposes.







Oracle LazyDBA home page