public class OracleExternalTableProperties extends AbstractChildBuildableObject
LONG
columns. However, you can populate LOB columns of an external table with
varray or LONG
data from an internal database table.Modifier and Type | Class and Description |
---|---|
static class |
OracleExternalTableProperties.AccessType
Allowed values for the access parameter type.
|
static class |
OracleExternalTableProperties.LocationSpecifier
The LOCATION clause lets you specify one or more external data sources.
|
static class |
OracleExternalTableProperties.ProjectColumn |
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ACCESS_DRIVER_TYPE_ORACLE_BIGDATA
Access driver type ORACLE_BIGDATA.
|
static java.lang.String |
ACCESS_DRIVER_TYPE_ORACLE_DATAPUMP
Access driver type ORACLE_DATAPUMP.
|
static java.lang.String |
ACCESS_DRIVER_TYPE_ORACLE_HDFS
Access driver type ORACLE_HDFS.
|
static java.lang.String |
ACCESS_DRIVER_TYPE_ORACLE_HIVE
Access driver type ORACLE_HIVE.
|
static java.lang.String |
ACCESS_DRIVER_TYPE_ORACLE_LOADER
Access driver type ORACLE_LOADER.
|
static java.lang.String |
KEY
KEY for use in getProperty/setProperty on a Table object to query the
external table properties.
|
static int |
REJECT_LIMIT_UNLIMITED
Value for the rejectLimit property that represents "UNLIMITED".
|
static java.lang.String |
TYPE |
Constructor and Description |
---|
OracleExternalTableProperties()
Creates an empty OracleExternalTableProperties object, which is used to
define the properties of an external table.
|
Modifier and Type | Method and Description |
---|---|
void |
addLocationSpecifier(DBObjectID directory,
java.lang.String specifier)
Adds a location specifier that uses the given Directory (by ID) and the
specified location.
|
void |
addLocationSpecifier(OracleExternalTableProperties.LocationSpecifier locationSpecifier)
Adds the given location specifier.
|
void |
addLocationSpecifier(java.lang.String specifier)
Adds a location specifier that uses the given Directory (by ID) and the
specified location.
|
java.lang.String |
getAccessDriverType()
Get the access driver type.
|
java.lang.String |
getAccessParameters()
Get the access driver's parameters.
|
SQLFragment |
getAccessParametersFragment()
Gets the driver's access parameters derived as a SQLFragment.
|
DBObjectID |
getDefaultDirectory()
Gets the default Directory by ID.
|
OracleExternalTableProperties.LocationSpecifier[] |
getLocationSpecifiers()
Gets the LocationSpecifiers which are used to specify the external
locations used to store the table's data.
|
OracleExternalTableProperties.ProjectColumn |
getProjectColumn()
Get the value of the 'alter table project column clause'.
|
java.lang.Integer |
getRejectLimit()
Gets the reject limit for the external table.
|
java.lang.String |
getType()
Returns the type of this object.
|
boolean |
isAccessUsingClob()
Gets whether the access parameters are defined using a clob subquery.
|
void |
removeAllLocationSpecifiers()
Clears the list of LocationSpecifiers.
|
void |
removeLocationSpecifier(OracleExternalTableProperties.LocationSpecifier locationSpecifier)
Removes the given location specifier.
|
void |
setAccessDriverType(java.lang.String accessDriverType)
Set the access driver type.
|
void |
setAccessParameters(java.lang.String accessParameters)
Set the access driver's parameters.
|
void |
setAccessParametersFragment(SQLFragment frag)
Sets the driver's access parameters derived as a SQLFragment.
|
void |
setAccessUsingClob(boolean accessUsingClob)
Sets whether the access parameters are defined using a clob subquery.
|
void |
setDefaultDirectory(DBObjectID defaultDirectory)
Sets the default Directory by ID.
|
void |
setLocationSpecifiers(OracleExternalTableProperties.LocationSpecifier[] locationSpecifiers)
Sets the LocationSpecifiers which are used to specify the external
locations used to store the table's data.
|
void |
setProjectColumn(OracleExternalTableProperties.ProjectColumn projectColumn)
Set the value of the 'alter table project column clause'.
|
void |
setRejectLimit(java.lang.Integer rejectLimit)
Sets the reject limit for the external table.
|
setParent
checkInit, checkInit, copyToImpl, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization, processPropertyChange, setID
addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setName, setProperties, setProperty, toString
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
getParent
addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName, setProperties, setProperty
public static final java.lang.String KEY
public static final java.lang.String TYPE
public static final java.lang.String ACCESS_DRIVER_TYPE_ORACLE_LOADER
public static final java.lang.String ACCESS_DRIVER_TYPE_ORACLE_DATAPUMP
public static final java.lang.String ACCESS_DRIVER_TYPE_ORACLE_HIVE
BigDataAccessParameters
,
Constant Field Valuespublic static final java.lang.String ACCESS_DRIVER_TYPE_ORACLE_HDFS
BigDataAccessParameters
,
Constant Field Valuespublic static final java.lang.String ACCESS_DRIVER_TYPE_ORACLE_BIGDATA
BigDataAccessParameters
,
Constant Field Valuespublic static final int REJECT_LIMIT_UNLIMITED
public OracleExternalTableProperties()
public java.lang.String getType()
DBObject
public void setDefaultDirectory(DBObjectID defaultDirectory)
public DBObjectID getDefaultDirectory()
public void setLocationSpecifiers(OracleExternalTableProperties.LocationSpecifier[] locationSpecifiers)
public OracleExternalTableProperties.LocationSpecifier[] getLocationSpecifiers()
public void addLocationSpecifier(OracleExternalTableProperties.LocationSpecifier locationSpecifier)
public void addLocationSpecifier(DBObjectID directory, java.lang.String specifier)
public void addLocationSpecifier(java.lang.String specifier)
public void removeLocationSpecifier(OracleExternalTableProperties.LocationSpecifier locationSpecifier)
public void removeAllLocationSpecifiers()
public void setAccessDriverType(java.lang.String accessDriverType)
ACCESS_DRIVER_TYPE_*
for the known Oracle access drivers.public java.lang.String getAccessDriverType()
ACCESS_DRIVER_TYPE_*
for the known Oracle access drivers.public void setAccessParameters(java.lang.String accessParameters)
public java.lang.String getAccessParameters()
setAccessParameters(java.lang.String)
public void setAccessParametersFragment(SQLFragment frag)
frag
- the access parameters fragmentpublic SQLFragment getAccessParametersFragment()
public void setAccessUsingClob(boolean accessUsingClob)
accessUsingClob
- whether the access parameters are defined using
a clob subquerypublic boolean isAccessUsingClob()
public void setRejectLimit(java.lang.Integer rejectLimit)
REJECT_LIMIT_UNLIMITED
.the
- reject limitpublic java.lang.Integer getRejectLimit()
REJECT_LIMIT_UNLIMITED
.public void setProjectColumn(OracleExternalTableProperties.ProjectColumn projectColumn)
public OracleExternalTableProperties.ProjectColumn getProjectColumn()