public class OracleExternalTableProperties extends AbstractChildDBObject
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_DATAPUMP |
static java.lang.String |
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 java.lang.String |
REJECT_LIMIT_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.Object |
getAccessParameters()
Get the access driver's parameters.
|
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.String |
getRejectLimit()
Gets the reject limit for the external table.
|
java.lang.String |
getType()
Returns the type of this object.
|
boolean |
isAccessUsingClob() |
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.Object accessParameters)
Set the access driver's parameters.
|
void |
setAccessUsingClob(boolean accessUsingClob) |
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.String rejectLimit)
Sets the reject limit for the external table.
|
setParent
addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, copyToImpl, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getParent, getProperties, getProperty, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, 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, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName
getProperty, getProperty, 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 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)
public java.lang.String getAccessDriverType()
public void setAccessParameters(java.lang.Object accessParameters)
public java.lang.Object getAccessParameters()
public void setAccessUsingClob(boolean accessUsingClob)
public boolean isAccessUsingClob()
public void setRejectLimit(java.lang.String rejectLimit)
public java.lang.String getRejectLimit()
public void setProjectColumn(OracleExternalTableProperties.ProjectColumn projectColumn)
public OracleExternalTableProperties.ProjectColumn getProjectColumn()