Database
A database is a structured collection of records or data.
Language
Any
Platform
Any
License
Any
In this installment, we'll discuss external tables, tablespace changes, Oracle managed files, multiple blocksizes and cache configuration, on-line table reorganization and index monitoring.
This series of articles is a little different than others you may read. It doesn't focus on one, single topic, but it does provide a wealth of interesting information on a lot of different areas. In...
Databases are often taxed by applying SQL statements to enormous tables. One such activity is when we add a new NOT NULL column with default value to a huge transaction table. Amar Padhi shares...
Giving your users the ability to access an Oracle database using either Access or Excel is easy to do. It takes all of three minutes to set up the link or connection. Learn how in Connecting with...
Somebody has to say it, so it may as well be me. It is not too late to pursue the Oracle8i Certified Professional Database Administrator certification. If this is something you want to do and you are...
This document will walk you through the steps of installing Oracle 8i Enterprise Edition release 3 (Oracle version 8.1.7) or release 2 (8.1.6) in a Linux environment. Everything you read in this...
Oracle Warehouse Builder 10gR2 "Paris", the forthcoming release of Oracle's ETL tool, comes with a host of new features to support the building and maintenance of relational and multdimensional cubes...
This article explains the features of a BI dashboard, discusses the benefits to users, and steps through the creation of a dashboard with Oracle Database 10g; Oracle Business Intelligence Discoverer...
With Oracle Database 10g, Oracle has introduced a number of improvements to summary management and query rewrite. This article details these improvements and explains how they can be used to improve...
Whilst many Oracle DBAs build and maintain their data warehouses using nothing more than UNIX, SQL, and PL/SQL scripts, many are now starting to use graphical tools such as Oracle Warehouse Builder...
There are several complicated things you may need to do with flexfields in your forms but one of them is simple and very common: create a foreign key on the accounting flexfield.
Prior to Oracle 8.1.7 the interMedia support for import and export of data was a little flunky. Even now the API forces you to use directory object to access the file system. The code supplied here...
Prevent batch processes interfering with your OLTP transactions by using this simple PL/SQL API to assign a priority to each type of session.
Lists the available mechanisms for gathering database statistics that are used by the cost based optimizer.
