Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create backup table using LONG column

rock_1986May 27 2016 — edited May 27 2016

Hi Gurus,

i have one table with one long column.Below structure this

A (s0 number,s1 long,s2 varchar2(20))

Above long column contains "select" Query. A table contains 400 records.

I want to create backup table for the TABLE A

create table A_BKP as select * from A;

when i am trying to create got the below error LIKE

ORA--00997: illegal use of LONG datatype;

so i request you, is there any other way  to create the backup table using LONG column.

Thanks & Regards

Rock

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2016
Added on May 27 2016
5 comments
1,114 views