Re: Problem with LONG column

[Dale]

Title: Which rollback segment is currently active?

Hi Banarasi   >One of my development team is working on ORACLE 8 on NT (Because of client requirement they are working on that version). One Table was created with wrong column name. Now they wanted me to correct the column name. But real problem is one column of that table is LONG data type. So I was unable to use Insert into ... Select ....     statement. Any suggestions in this regard highly appreciated.   Investigate the SQL COPY command. It will copy LONG columns. I think you'll probably find it in the SQLPlus manual rather than the SQL Reference.   Regards Dale --------- Need to generate scripts to re-create the DDL in your database? Check out the freeware DBATool http://www.DataBee.com