reports are not generated [message #259007] |
Tue, 14 August 2007 02:13 |
pvr_msg
Messages: 7 Registered: August 2006 Location: hyderabad
|
Junior Member |
|
|
Hi to all members
This is ramana
My problem with long datatype is
we have one table with long column.In that table dialy heavy rows are inserted so we take backup of that table every day into another backup table.But long column datatype rows are not inserted.
ora-0997-illegal use of long datatype
so we create another table with same structure instead of long datatype we use clob datatype.
now rows are inserted to backup table fine.
but here using that backup table we generate reports.
that reports are not working.(crystal reports)
so what to do
base table with same reports working fine
|
|
|
|
Re: reports are not generated [message #259019 is a reply to message #259007] |
Tue, 14 August 2007 02:59 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Use an 'insert' statement to backup all the rows without the 'long' column and then use an 'update' statement to populate the 'long' column.
David
|
|
|