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

Oracle LazyDBA home page