Sometimes you may face error “The transaction log for database is full due to ‘LOG_BACKUP’” this error due to your database has been set-up as full recovery model and transaction log becomes full due to LOG_BACKUP. and due to this, you will not be able to perform any transaction on this database. To resolve the issue, take a transaction log backup and set the database in simple recovery model. To do so you need to do the following #1 Change the database model to SIMPLE Recovery ALTER DATABASE Database_name SET RECOVERY SIMPLE GO #2 Truncate log file DBCC SHRINKFILE (Database_name, 1); GO 3# Reset model to FULL Recovery ALTER DATABASE Database_name SET RECOVERY FULL GO

Default date format in oracle and change the dafault format

pradeepkumarjse

What is the default format of date in Oracle? How can I change my default date format?

SShakir

The default format for the date in oracle is DD-MON-YY.
We can change it by using this SQL command
ALTER SESSION set nls_date_format='desired format';
The desired format is like Day-Mon-yyyy 24hh:mi:ss