Home » SQL & PL/SQL » SQL & PL/SQL » Transaction log (oracle 10g)
Transaction log [message #391848] Fri, 13 March 2009 23:50 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
Server: Msg 9002, Level 17, State 6, Line 1

when i executed thee script iam getting like this

The log file for database 'ezEMRx_6_24' is full. Back up the transaction log for the database to free up some log space.

same thing happend in sql server also

[Updated on: Fri, 13 March 2009 23:58]

Report message to a moderator

Re: Transaction log [message #391850 is a reply to message #391848] Sat, 14 March 2009 00:02 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

>same thing happend in sql server also
So then problem might be elsewhere. Any idea where?

Re: Transaction log [message #391855 is a reply to message #391850] Sat, 14 March 2009 00:59 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member



HDD is almost full for that database server some of the seniors here telling may be due to that.how to come to know?

as per sqlserver i got idea iam unable to get ideat on oracle
in sql server i checked
like 
1)right click on data base
2)go to properties
3)later i went to files option
4)there 2 rows and 7 columns are there
5)in fifth column like auto growth is been set as 
  By 10 percent, restricted growth to 512 MB for log information
6) with that they are telling no problem in it.
Re: Transaction log [message #391857 is a reply to message #391848] Sat, 14 March 2009 01:47 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is an Oracle forum not a sql server one.
The question is irrelevant here.

Regards
Michel
Previous Topic: flush buffer cache within stored procedure
Next Topic: Looping Insert Trigger
Goto Forum:
  


Current Time: Sat Dec 10 12:53:38 CST 2016

Total time taken to generate the page: 0.09978 seconds