Skip to Main Content

Oracle Database Discussions

Announcement

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!

Oracle truncate a log like Sybase

kaitokidscsSep 4 2013 — edited Sep 4 2013

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!!!!

Comments

sb92075

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!!!!

post URL to Oracle documentation where "transaction log" is discussed.

jgarry

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

kaitokidscs

The issue is that the logs are too space consuming and I just need to truncate after the transactions...

sb92075

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

EdStevens

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!!!!

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;'

jgarry

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.

Aman....

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....

kaitokidscs

Thank you! This helps a lot.

Aman....

Aman....

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2013
Added on Sep 4 2013
9 comments
287 views