Synonyms are used in place of schema objects in professional database applications because the application user is typically different from the object owner schema. The script below creates synonyms for all the relevant objects in your schema—if they dont exist automatically. This saves you from

(Siva Muthuraman) When we were in the process of implementing RMAN backups for our databases, we felt that there were not many articles or real stories on how someone survived a real disaster. This article walks through a real disaster we recently had in our company and how we survived it using

(Michael Liedtke) It’s still early, but some investors already are betting that Oracle Corp. will prevail in an antitrust trial contesting its $7.7 billion bid for rival business software maker PeopleSoft Inc.

Introducing the first installment of SearchOracle.com’s Lessons Learned series. Each week you will get a mini-lesson pertaining to a highly-specific database administration, application development, data warehousing and business intelligence, or E-Business Suite topic. The lessons are comprised

(James Koopmann) Don’t wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features that will make a few of your everyday tasks a bit more bearable.

(Jeffrey Hunter) One of the most efficient ways to become familiar with Oracle Real Application Clusters (RAC) technology is to have access to an actual Oracle RAC cluster. In learning this new technology, you will soon start to realize the benefits Oracle RAC has to offer like fault tolerance,

At the core of data warehouse applications and OLAP (online analytical processing) is a specialized schema that relaxes the rules of Third Normal Form RDBMS schemas in favor of faster analysis and processing of large amounts of data. It’s important to understand the difference between these kinds of

(Jonathan Gennick) Anyone who works with SQL knows that the results of a SELECT statement are returned in rows and columns. Most people also know that you can easily generate additional columns of data in a result by writing expressions that operate on data that actually is stored in a table. For ex

(Steven Feuerstein) Oracle PL/SQL offers a range of constructs that allow you to control the flow of processing, including: For conditional logic: the IF statement For loop processing: FOR, WHILE, and simple loops For branching logic: the GOTO statement These constructs are relatively strai

(Steve Button) Debugging an OracleAS clustered environment, with server configurations, application code requirements, replication settings, etc. can be a somewhat engaging process — particularly if you are in a hurry and need to get it working ASAP. Using a methodical approach, it’s very easy to