Help Required

Can anybody tell me how to copy data from a table when a
LONG or LONG RAW column exists.

Thanks.

I need to know how u will copy the data? from table to table or what is the case...! if it is table to table try using the copy command and select the columns from the table you want a copy..or you can create table as selecyt * from source.

Write me what exactly u want i will see if i do something for ya..

Regards,
NK

Hello nabeel

suppose i have a table tab1 which contains columns like empno number and details long data type. This table contains some data. Now i need to create based upon this table tab1.

But the problem is when a table contains a long column this syntax doen't work.

create table tab2 as
select * from tab1;

Hope now the question is clear.

Thnaks

Hi

The simpler solution for above would be Exporting
Data and Importing Data into required table.

I dont find any other solution for this...

Any answer from any friends..