Hey guys, i need your experience here;)

We use oracle 8, and today some customers reported that regarding a table (financial one... ouch) all the entries they did since the 23rd october dont appear, the lines are blank , but incremented

is there a limit to the number of datas ? entries?

should i do a purge of the tables ( it has never been done before.; and i took the job 3 weeks ago so i dont know all the history ;) )

all the help you can provide will be real helpful guys

in advance thx  

There is nothing in Oracle that limits the amount of data you can have other than running out of space in the tablespace.  I would expect to get an Oracle error in that event, but I suppose it's possible you could have hit a space problem and your application has created rows but not been able to put the data in them.   This might be because data hasn't been created in some intermediate temporary table.

I wouldn't recommend deleting data from any tables unless you're confident the data isn't required.  If you do delete from any tables, I would advise backing them up first (perhaps exporting them).

For Oracle-related work, contact me through Linked-In.

Hi,
How are the tables updated - directly thru Oracle's tools or from a 3rd party or user created application.If another app, does it insure a 'commit' takes place after the entry or when exiting/ What happens if the user fails to log out or there is a power loss to the users PC?

What 'lines' are you referring to when you say that they are there but empty and incremented?

 

To Paraphrase:"The Help you get is proportional to the Help you give.."

Oracle is filled using a 3rd party app (quest v2)

When i request the datas using TOAD, i do have all the rows, the users using Quest only have the first 1000 rows . all the following rows are blank



 

Are you sure the Quest tool isn't set up to show only the 1000 rows as a sample?

The internet - allowing those who don't know what they're talking about to have their say.

Hi,
Check the app for any restrictions on the amount of data returned - since T.O.A.D. finds that the data is there it does not seem to be Oracle issue.

 

To Paraphrase:"The Help you get is proportional to the Help you give.."