Email Alerts
-
Author Mike Ault sizes up the new Oracle Database 11g
Oracle book author Mike Ault talks about the upcoming Oracle Database 11g's new SQL replay and memory management capabilities. Article | 03 May 2007
-
Podcast: Oracle Database 11g preview -- New automated features promise to make DBA life easier
Oracle Database 11g will offer new automated management features that should allow DBAs to concentrate on more strategic issues. We talked to an Oracle honcho to find out more. Article | 20 Mar 2007
-
Oracle expert looks ahead to Database 11g
Oracle Database expert Brian Peasland explains why he has little use for the planned XML upgrades in Database 11g and offers advice for DBAs hoping to get certification. Article | 17 Jan 2007
-
Oracle Database 11g to feature XML enhancements
The latest version of Oracle's flagship DBMS offers a host of XML-related upgrades. Article | 12 Dec 2006
-
Oracle tutorial library: SearchOracle.com's learning guides
One of the best resources SearchOracle.com offers is our collection of learning guides. They're a perfect education tool for the beginner who's just getting started with Oracle or the seasoned professional looking to attain expert status. We've gathe... Article | 29 Nov 2006
-
Podcast: Security expert sizes up Oracle patch policies
Oracle Security Handbook author Aaron Newman talks to SearchOracle.com about Oracle's patching problems and some of the typical security concerns that plague Oracle DBAs. Article | 09 Nov 2006
-
Podcast: Expert says PL/SQL change needed in Oracle 11g
SearchOracle.com chats with one of the world's leading PL/SQL gurus, Steve Feuerstein, about the PL/SQL changes he'd like to see when Oracle debuts Database 11g. Article | 09 Nov 2006
-
Podcast: Database guru previews Oracle OpenWorld
Oracle database guru Mark Townsend talks about the highlights of next week's Oracle OpenWorld show. Article | 17 Oct 2006
-
The Oracle Security Challenge
Let's find out what how much you really know about Oracle security. Article | 22 Aug 2006
-
Survey: DBAs not planning for downtime
Companies need to do more to reduce the amount of database downtime resulting from both planned and unplanned events, a new IOUG survey finds. Article | 20 Jun 2006
- See more News on Oracle error messages
-
Changing to a shared server
To change your Oracle 9i release 2 database from a dedicated server to a shared server, you must change the number of dispatchers to at least one. But if you run this statement you will receive an error message. The alter system statement is an appar... Tip
-
Five Oracle tips in five minutes
These five quick Oracle tips, including scripts and SQL shortcuts, can make your life as a DBA a bit easier. Tip
-
Update a referenced column in a MERGE statement
Here's how to update a referenced column in a MERGE statement. Tip
-
Identifying fragmented indexes that should be rebuilt
This tip will help address performance issues when Oracle stops using indexes on highly volatile tables. It identifies indexes that are fragmented and should be rebuilt. Tip
-
Dropping objects without ORA-00942 errors
This tip enables you to install or drop objects without getting an Oracle error, even if the object doesn't exist. Tip
-
Compile all invalid objects including those with syntax errors
With this script, you can see not just invalid objects, but also those with syntax errors. Tip
-
Avoid 'cannot extend rollback segment' error when deleting rows
Here is how delete as many rows as you like without having to worry about RBS size. Tip
-
Compile all invalid objects
Script to compile all invalid dependent objects at once. Tip
-
RBS monitor to catch ORA-1555 errors
Why you get ORA-1555 errors and how to avoid them. Tip
-
How to avoid 'mutating table' errors
A "mutating table" error can be avoided by writing a procedure/function that declares the pragma autonomous_transaction. Tip
- See more Tips on Oracle error messages
-
How to copy Oracle Database 9i to a new server
Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another. Answer
-
Why won't TNS listener connect with Oracle Database 11g 32-bit?
One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g. Answer
-
Avoiding and fixing mutating table errors
PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error. Answer
-
How to perform incomplete recovery to overcome Oracle database error
Learn how to perform incomplete recovery in Oracle to overcome an error after restoring with RESETLOGs in this tip from Oracle expert Brian Peasland. Answer
-
Why am I receiving Oracle memory allocation errors?
Are you receiving Oracle memory allocation errors? Learn why you may be having memory allocation problems in Oracle in this tip from Oracle expert Brian Peasland. Ask the Expert
-
Oracle error 6550 may mean incorrect Oracle export version
Oracle expert Brian Peasland explains why you might get an Oracle error 6550 when using the wrong Oracle export version in this tip. Ask the Expert
-
Are we getting the ORA-00382 error because we're at maximum block size?
Are you receiving the ORA-00382 error when determining Solaris block size? Learn what the maximum block size on Solaris is in this expert tip. Ask the Expert
-
Why does the archive log in Oracle give me the ORA-16032 error?
Oracle expert Brian Peasland explains why you might be getting the ORA-16032 error, including why starting multiple instances with the archive log in Oracle will throw the error. Ask the Expert
-
How do I solve the ORA-00257 error in Oracle?
Read about some possible solutions to the ORA-00257 error in Oracle with this expert tip. Ask the Expert
-
Error during RMAN backup
An Oracle user asks why they are receiving an error when conducting an RMAN backup. Ask the Expert
- See more Expert Advice on Oracle error messages
-
How to copy Oracle Database 9i to a new server
Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another. Answer
-
Why won't TNS listener connect with Oracle Database 11g 32-bit?
One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g. Answer
-
Avoiding and fixing mutating table errors
PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error. Answer
-
How to perform incomplete recovery to overcome Oracle database error
Learn how to perform incomplete recovery in Oracle to overcome an error after restoring with RESETLOGs in this tip from Oracle expert Brian Peasland. Answer
-
Why am I receiving Oracle memory allocation errors?
Are you receiving Oracle memory allocation errors? Learn why you may be having memory allocation problems in Oracle in this tip from Oracle expert Brian Peasland. Ask the Expert
-
Oracle error 6550 may mean incorrect Oracle export version
Oracle expert Brian Peasland explains why you might get an Oracle error 6550 when using the wrong Oracle export version in this tip. Ask the Expert
-
Are we getting the ORA-00382 error because we're at maximum block size?
Are you receiving the ORA-00382 error when determining Solaris block size? Learn what the maximum block size on Solaris is in this expert tip. Ask the Expert
-
Why does the archive log in Oracle give me the ORA-16032 error?
Oracle expert Brian Peasland explains why you might be getting the ORA-16032 error, including why starting multiple instances with the archive log in Oracle will throw the error. Ask the Expert
-
How do I solve the ORA-00257 error in Oracle?
Read about some possible solutions to the ORA-00257 error in Oracle with this expert tip. Ask the Expert
-
Error during RMAN backup
An Oracle user asks why they are receiving an error when conducting an RMAN backup. Ask the Expert
- See more All on Oracle error messages
About Oracle error messages
Database administrators (DBAs) can browse our hundreds of expert responses on resolving common Oracle errors, or check out our popular learning guide for a handy list of Oracle error messages and solutions.