How to Load a Shapefile in to Oracle Spatial

USAGE: shp2sdo [-o]
-g
-i  -n  -p -d
-x (xmin,xmax) -y (ymin,ymax) -s
or
shp2sdo -r   -c  -n  -a -d
-x (xmin,xmax) -y (ymin,ymax)
shapefile           - name of input shape file
(Do not include suffix .shp .dbf or .shx)
tablename           - spatial table name
if not specified: same as input file name
Generic options:
-o                  - Convert to object/relational format (default)
-r                  - Convert to the relational format
-d                  - store data in the control file
if not specified: keep data in separate files
-x                  - bounds for the X dimension
-y                  - bounds for the Y dimension
-v                  - verbose output
-h or -?            - print this message
Options valid for the object model only:
-g geometry column  - Name of the column used for the SDO_GEOMETRY object
if not specified: GEOM
-i id_column        - Name of the column used for numbering the geometries
if not specified, no key column will be generated
if specified without name, use ID
-n start_id         - Start number for IDs
if not specified, start at 1
-p                  - Store points in the SDO_ORDINATES array
if not specified, store in SDO_POINT
-s                  - Load SRID field in geometry and metadata
if not specified, SRID field is NULL
-t                  - Load tolerance fields (x and y) in metadata
if not specified, tolerance fields are 0.00000005
-8                  - Write control file in 8i format
if not specified, file written in 9i format
-f                  - Write geometry data with 10 digits of precision
if not specified, 6 digits of precision is used
Options valid for the relational model only:
-c ordcount         - Number of ordinates in _SDOGOEM table
if not specified: 16 ordinates

sqlplus username/password@10.11.18.41:1521/mydb
@"C:\Agriculture\Data\AnimalBusinesses.SQL"

sqlldr username/password@10.11.18.41:1521/mydb C:\pathtofile\file.ctl

CREATE INDEX MyIndex_idx ON MyTable (geom)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;