Home » Other » General » reports are not generated
reports are not generated [message #259007] Tue, 14 August 2007 02:13 Go to next message
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 #259012 is a reply to message #259007] Tue, 14 August 2007 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Error?

Regards
Michel
Re: reports are not generated [message #259019 is a reply to message #259007] Tue, 14 August 2007 02:59 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Web Development And Data Should Reflect In Oracle Database
Next Topic: Enterprise Wide Deployment
Goto Forum:
  


Current Time: Sun Dec 11 08:32:37 CST 2016

Total time taken to generate the page: 0.24506 seconds