| panbhatt |
Posted: Jan 23, 2007 11:57:05 PM |
Total Post: 2
Joined: Jan, 2007
|
hi to all smart people,
i m facing a problem bcoz of (ora -01536 error )for 5 days,in oracle & i could not be able to insert data into the database through an application. but after incrasing the space it works fine. in the meantime of 5 days i lost the data that can't be inserted bcoz of teh error .can it be possible fo rme to retireve the data back in any way
thanks and waiting for reply. |
|
|
 Jayanta |
| Posted: Jan 24, 2007 12:55:49 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
problem: The space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace.
solution: Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.
regards
jayanta
|
|
|
|
|
| goldmonkey |
| Posted: Jan 24, 2007 09:21:12 PM | |
|
Total Post: 7
Joined: Jan, 2007
|
It depend how you scripts(program) insert into the database, If you give some more detail infomation about this. Someone may can help.
|
|
|
|
|
| panbhatt |
| Posted: Jan 25, 2007 04:13:49 AM | |
|
Total Post: 2
Joined: Jan, 2007
|
the tablespace problem was resloved. but bcoz of this problem for 7 days my application could not be able to insert the data in the table. and the application hasn't show any error. is there is any possible means through which i can retireve the raw data back ( which my app tries to insert ).
Please help ASAP.
|
|
|
|
|
| goldmonkey |
| Posted: Jan 25, 2007 12:53:31 PM | |
|
Total Post: 7
Joined: Jan, 2007
|
This is total depened on how you application insert those data.
For example if a process insert into table C depend on the rows in table A and B. If the process fail for several days, it will total depend on table A and B still have the data to generate data for table C or not. If those data still there, you have the ability to insert it back to table C.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
