The objective of this tutorial is to expose you to some important features and tools of Oracle Designer/2000 and Developer/2000. You will learn how to use Designer/2000 and create E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams that are needed to design a database and implement a user defined system in client's organization. Later on, in this tutorial, you will also learn the basics of Developer/2000 that will help you create forms, reports, and screens, and finally generate a working application system.

Data Pump improves upon the functionality offered by the traditional exp/imp utilities. Export and Import are still supported for compatibility but the new features are only accessible from the expdp & impdp commands. The main architectural difference between Data Pump and the export/import utilities is that Data Pump is completely server-based. That is, a database shadow process writes dump files, log files and SQL files to directory objects defined on the database server. Export and Import client processes write files locally.

Data Pump is invoked on the command line using expdp/impdp commands or by issuing calls to the DBMS_DATAPUMP and DBMS_METADATA packages.

Navigate to the OEM pages
OEM Database Control -> Maintenance -> Utilities

As you may already have experienced, you cannot  recall statements after they have been submitted to SQL*Plus. The ed command allows you to edit the SQL*Plus buffer in the system's default editor. After saving your changes, submit the statement with a `/'. Be aware that only the last  statement submitted  to SQL*Plus may be edited

Embedded SQL is a method of combining the computing power of a high-level language like C/C++ and the database manipulation capabilities of SQL. It allows you to execute any SQL statement from an application program. Oracle's embedded SQL environment is called Pro*C.

A Pro*C program is compiled in two steps.  First, the Pro*C precompiler recognizes the SQL statements embedded in the program, and replaces them with appropriate calls to the functions in the SQL runtime library. The output is pure C/C++ code with all the pure C/C++ portions intact. Then, a regular C/C++ compiler is used to compile the code and produces the executable.  For details, see the section on Demo Programs.

With the examples of the previous part, the "Best Foot Forward" database really exists on paper. To make it more interactive, we will use some product on the market. For the moment, I suggest that you use the Oracle products.

It's very important to mention that I choose Oracle Express because I have used it for a long time and I know how it works. If you want to compare the various OLAP products, I suggest you to visit the sites here. Finally, all propositions for "OLAP in practice" pages with other products will be much appreciated.

To build an OLAP database in a very short time, Oracle recommends the Oracle Express Administrator tool. We will use it in this first stage to create the Best Foot Forward database