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

Oracle LazyDBA home page