Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Oracle truncate a log like Sybase
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!!!!
Answers
-
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.
-
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
-
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;'
-
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.
-
Aman....
