Copyright (c) 2003 Oracle. All rights reserved.

PL/SQL SAMPLE PROGRAMS FOR ORACLE 10g DATA MINING EXPORT AND IMPORT


This directory contains sample programs for Oracle Data Mining model
export and import using the PL/SQL procedures EXPORT_MODEL() and
IMPORT_MODEL().  These procedures are part of the Oracle DBMS_DATA_MINING
PL/SQL package.

Files
-----
README.txt    - this file

exp_all.sql   - export all models from the user schema
exp_alg.sql   - export all models of a specific algorithm
exp_cls.sql   - export all models created with a specific function
exp_est.sql   - estimate the size of an export job
exp_names.sql - export models by their names

imp_all.sql   - import all models from a dump file
imp_infil.sql - import specific models using "name IN" filter
imp_mod1.sql  - import one named model from a dump file
imp_names.sql - import models by their names from a dump file set
imp_remap.sql - import models from a dump exported from another schema
imp_sqlf.sql  - create a DDL file from a dump file

Prerequisites
-------------

1. A directory object must exist and must point to a valid directory. 
   For details of creating directory objects, see Oracle SQL Reference. 

2. The user must have READ and WRITE privileges on the directory object.

For model export:

   The data mining user must have at least one data mining model built using
   DBMS_DATA_MINING. 

For model import:

   The directory object must point to a directory containing a dump file set
   that was exported by EXPORT_MODEL() or expdp.

   A user other than SYS must have the IMP_FULL_DATABASE privilege in order to
   import with the parameter schema_remap.

   If a data mining model exits and you want to overwrite it, you must drop the
   model. Use DBMS_DATA_MINING.DROP_MODEL procedure.

Usage
-----
Make sure all prerequisites are met.  
Modify input parameters as needed.
Run the samples directly in SQL*Plus.

To take full advantage of EXPORT_MODEL and IMPORT_MODEL procedures, see
Supplied PL/SQL Packages and Types Reference, Oracle Data Mining Administrator's
Guide, and Oracle Data Mining Application Developer's Guide.



