ajax.dbase
Class OracleTransfer
java.lang.Object
|
+--ajax.dbase.OracleTransfer
- All Implemented Interfaces:
- DatabaseTransfer
- public class OracleTransfer
- extends java.lang.Object
- implements DatabaseTransfer
Method Summary |
void |
dump(java.lang.String fileName,
java.lang.String query)
Writes the file to be executed by SQLPlus to dump
the result of the query into a file
The name of the table to dump is the file name |
void |
executeDump(java.lang.String fileName)
Invocation of SQLPlus during the evaluation of transformations
(dynamically) |
void |
executeLoad(java.lang.String fileName)
Invocation of sqlldr to load the contents of a file into a table
Dynamically |
void |
load(java.lang.String fileName,
CatalogObject catObj)
Loads the contents of a file into a table using
Writes the control file used by sqlldr to load a file
into a table
The name of the table is given by the file name |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
dirControlFiles
public static final java.lang.String dirControlFiles
- Directories
dirFiles
public static final java.lang.String dirFiles
callSQLPlus
public static final java.lang.String callSQLPlus
- Commands
callSQLldr
public static final java.lang.String callSQLldr
OracleTransfer
public OracleTransfer()
load
public void load(java.lang.String fileName,
CatalogObject catObj)
throws CatalogException,
java.io.IOException
- Loads the contents of a file into a table using
Writes the control file used by sqlldr to load a file
into a table
The name of the table is given by the file name
- Specified by:
load
in interface DatabaseTransfer
executeLoad
public void executeLoad(java.lang.String fileName)
throws java.io.IOException,
java.lang.InterruptedException
- Invocation of sqlldr to load the contents of a file into a table
Dynamically
- Specified by:
executeLoad
in interface DatabaseTransfer
dump
public void dump(java.lang.String fileName,
java.lang.String query)
throws java.io.IOException
- Writes the file to be executed by SQLPlus to dump
the result of the query into a file
The name of the table to dump is the file name
- Specified by:
dump
in interface DatabaseTransfer
executeDump
public void executeDump(java.lang.String fileName)
throws java.io.IOException,
java.lang.InterruptedException
- Invocation of SQLPlus during the evaluation of transformations
(dynamically)
- Specified by:
executeDump
in interface DatabaseTransfer