Oracle 8i Tutorial
Interview Questions
Practice Test
Pragnyameter Exam
All Tutorials
Job SearchWhat is Oracle8i Tutorial?
Oracle8i tutorial offers foundation and in-depth concepts of Oracle8i. Oracle8i is advanced version of relational database management system. It is popular software application in enterprise applications.
Our Oracle tutorial covers various topics of Oracle database like insert record, update record, delete record, select record, create table, drop table etc. Our tutorial help you better understand the Oracle database.
Audience
Our Oracle tutorial is designed to help beginners and professionals. Our Oracle8i tutorial is aimed for beginners and professionals.
Prerequisites
To learn this Oracle 8i tutorial, you must have the basic knowledge of computer fundamentals.
Oracle 8i Tutorial: List of Topics
- Export
- What Is The Export Utility?
- Export Modes
- Using Export
- Export Parameters
- Example Export Sessions
- Applying The Interactive Method
- Messages That Export Issues In Certain Situations
- Direct Path Export
- Character Set Conversion
- Incremental, Cumulative, And Complete Exports
- Network Considerations
- Character Set And Nls Considerations
- Considerations In Exporting Database Objects
- Transportable Tablespaces In Oracle Database
- Using Different Versions Of Export
- Creating Oracle Release 8.0 Export Files From An Oracle8i Database
- Creating Oracle Release 7 Export Files From An Oracle8i Database
- Import
- What Is The Import Utility?
- Import Modes
- Using Import
- Privileges Required To Use Import
- Importing Into Existing Tables
- Import Parameters
- Using Table-level And Partition-level Export And Import
- Example Import Sessions
- How To Use The Interactive Method
- Importing Incremental, Cumulative, And Complete Export Files
- Controlling Index Creation And Maintenance
- Reducing Database Fragmentation
- Log Parameter To Import Files
- Error Handling In Oracle 8i
- How To Export And Import Across A Network
- Import And Snapshots
- Import And Instance Affinity
- Fine-grained Access Support
- Storage Parameters
- Dropping A Tablespace
- Reorganizing Tablespaces
- Character Set Considerations
- Considerations When Importing Database Objects
- Transportable Tablespaces Feature
- Importing Statistics
- Using Export Files From A Previous Oracle Release
- Sql*loader Concepts
- Sql*loader Basics
- Sql*loader Control File
- Input Data And Datafiles
- Data Conversion And Datatype Specification
- Discarded And Rejected Records
- Log File And Logging Information
- Conventional Path Load Versus Direct Path Load
- Loading Objects, Collections, And Lobs
- Partitioned Object Support
- Application Development: Direct Path Load Api
- Sql*loader Case Studies
- The Case Studies
- Case Study Files
- Tables Used In The Case Studies
- References And Notes
- Running The Case Study Sql Scripts
- Case 1: Loading Variable-length Data
- Case 2: Loading Fixed-format Fields
- Case 3: Loading A Delimited, Free-format File
- Case 4: Loading Combined Physical Records
- Case 5: Loading Data Into Multiple Tables
- Case 6: Loading Using The Direct Path Load Method
- Case 7: Extracting Data From A Formatted Report
- Case 8: Loading Partitioned Tables
- Case 9: Loading Lobfiles (clobs)
- Case 10: Loading Ref Fields And Varrays
- Sql*loader Control File Reference
- Sql*loader Command-line Reference
- Sql*loader: Log File Reference
- Sql*loader: Conventional And Direct Path Loads
- Dbverify: Offline Database Verification Utility
