The Global Paleomagnetic Database

Design, Installation and Use with ORACLE

Document Syntax Xl I. DATABASE DESIGN 1. Relational Databases 317 2. Choice of Database Management System 318 3. Design of the Global Paleomagnetic Database 319 3. 1. ORACLE Design 319 3. 2. Compact Database - ABASE 321 4. Aspects of Data Entry 326 II. ORACLE HARDWARE AND SOFTWARE 1. Sytem Hardware and Software Recommendation for ORACLE 328 1. 1. For a Fully IBM Compatible Personal Computer (PC) 328 1. 2. For an Apple Macintosh PC 329 1. 3. Recommendations 330 2. ORACLE RDBMS Software Used By the GPMDB 331 2. 1. A Brief Description of the ORACLE RDBMS 331 2. 2. SQL *Plus under MS-DOS 333 2. 3. SQL *Forms under MS-DOS 336 2. 4. SQL *Menu under MS-DOS 338 2. 5. The . CRT File 339 III. DATABASE INSTALLATION AND MAINTENANCE 1. The Role of the Database Administrator 340 2. Preparing Your PC for the Installation of ORACLE RDBMS 340 2. 1. ORACLE RDBMS for MS-DOS and Extended Memory 340 2. 2. Setting up MS-DOS for ORACLE 342 3. Installing the ORACLE RDBMS 347 3. 1. ORACLE Directory Structure 347 3. 2. Installing the ORACLE RDBMS for MS-DOS 348 3. 3. Step by Step ORACLE RDBMS Installation Instructions 348 4. System Preparation and Loading the Global Paleomagnetic Da- base 353 4. 1. System Preparation 353 4. 2. Installing the Global Paleomagnetic Database 356 4. 3. Loading the Custombuilt Files 358 v SUI\. IJ\IARY vi 5. Database Administrative Tasks 363 5. 1.