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

Oracle LazyDBA home page