This chapter describes how to load spatial data into a database, including storing the data in a table with a column of type SDO_GEOMETRY. After you have loaded spatial data, you can create a spatial index for it and perform queries on it, as described in Indexing and Querying Spatial Data.
The process of loading data can be classified into two categories:
Bulk loading of data (see Bulk Loading )
This process is used to load large volumes of data into the database and uses the SQL*Loader utility to load the data.
Transactional insert operations (see Transactional Insert Operations Using SQL)
This process is typically used to insert relatively small amounts of data into the database using the INSERT statement in SQL.
Recommendations for loading and validating spatial data are described in Recommendations for Loading and Validating Spatial Data.