Home » RDBMS Server » Server Administration » Inserting Record Problem
Inserting Record Problem [message #326022] Mon, 09 June 2008 23:27 Go to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

I have a table "call_log" in which automatically records are inserted when any call receive.
In my table there is 44559 records. But after it,it stop inserting records in it. when i delete some last record suppose 100 records then it will again allow 100 records inserted in it. After it, it again stop inserting record please tell me what is the problem.
The tablespace is 80% free And temporary tablespace is also free.

quick Response will be highly appriciated.

Inserting in table failed [message #326023 is a reply to message #326022] Mon, 09 June 2008 23:29 Go to previous messageGo to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

I have a table "call_log" in which automatically records are inserted when any call receive.
In my table there is 44559 records. But after it,it stop inserting records in it. when i delete some last record suppose 100 records then it will again allow 100 records inserted in it. After it, it again stop inserting record please tell me what is the problem.
The tablespace is 80% free And temporary tablespace is also free.

quick Response will be highly appriciated.
Re: Inserting Record Problem [message #326025 is a reply to message #326022] Mon, 09 June 2008 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting Guidelines at stated in URL above

You've posted a number or two & some reported observations.
I refuse to play "Guess my Problem" based upon no substantiated facts.
Re: Inserting Record Problem [message #326029 is a reply to message #326022] Mon, 09 June 2008 23:37 Go to previous messageGo to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

Sorry
I can not judge the exact forum for this threat. So i have posted this threat on two forums , Please reply for this problem. I have urgent need of it.
I will again study the guidelines.
I will be very thankful to you.
Re: Inserting Record Problem [message #326032 is a reply to message #326029] Mon, 09 June 2008 23:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have urgent need of it.
After 80 post, why do you choose to ignore Posting Guidelines?

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting Guidelines at stated in URL above

Please explain why it is urgent for ME to solve this problem for you?
Re: Inserting Record Problem [message #326033 is a reply to message #326022] Mon, 09 June 2008 23:51 Go to previous messageGo to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

I have admit my fault. Please reply me.
Re: Inserting Record Problem [message #326034 is a reply to message #326033] Mon, 09 June 2008 23:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you really, really have a problem, then you must provide us/others ways to reproduce the same as you are observing.

We do not know Operating System name/version?
We do not know Oracle version.
etc...

all of which are enumerated in Posting Guidelines!
Re: Inserting Record Problem [message #326035 is a reply to message #326022] Tue, 10 June 2008 00:03 Go to previous message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

I have Windows XP Operating System. And database version is Oracle9i Enterprise Edition Release 9.2.0.1.0.
thanks for reply.

[Updated on: Tue, 10 June 2008 00:06]

Report message to a moderator

Previous Topic: OracleJobSchedule[sid]" Service and OEM scheduled job ?
Next Topic: Error ORA-12528 (merged)
Goto Forum:
  


Current Time: Mon Sep 09 03:43:22 CDT 2024