For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello,
In Sybase I use "dump tran[saction] database_name with no_log" command to truncate a transaction log.
Does oracle have similar querry to this?
Thanks a lot!!!!
kaitokidscs wrote: Hello, In Sybase I use "dump tran[saction] database_name with no_log" command to truncate a transaction log. Does oracle have similar querry to this? Thanks a lot!!!!
kaitokidscs wrote:
post URL to Oracle documentation where "transaction log" is discussed.
This makes no sense at all in the Oracle context. Redo is extremely critical, if you lose it and need to recover, you fail big time.
Please read the concepts manual, Part V
The issue is that the logs are too space consuming and I just need to truncate after the transactions...
When you start with the wrong question, no matter how good an answer you get, it won't matter very much.
consider to actually learn about about Oracle by Reading The Fine Manual below
Contents
Oracle does not have a "query" (actually, that would be a command, not a query) like that because it is not needed. Oracle architecture is fundamentally different from any other rdbms product. The similarities with other products begin and end with 'SELECT * FROM EMP;'
You get rid of them by doing proper backups. You are doing backups, right? If you are not, you have valued your data at something less than $0.00.
kaitokidscs wrote: The issue is that the logs are too space consuming and I just need to truncate after the transactions...
And guess what, oracle has already sorted it out for you. You can make online redo logs to whatever size and Oracle would keep on flushing their contents with every log switch! Cool, eh? Jokes aside, don't try to compare Sybase with Oracle and Oracle with DB2 etc etc because they are all individual products and come with their own way of working. If you are using Oracle, use it in the way an Oracle database is supposed to be used!
Aman....
Thank you! This helps a lot.