Package oracle.kv.exttab
Class ExternalTableUtils
- java.lang.Object
 - 
- oracle.kv.exttab.ExternalTableUtils
 
 
- 
public final class ExternalTableUtils extends Object
 
- 
- 
Field Summary
Fields Modifier and Type Field Description static StringWRITE_FILE_RESOURCE_NAME 
- 
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static StringgetLocationSQL()Get LOCATION clause information from the ALL_EXTERNAL_LOCATIONS dictionary view.static StringgetWriteFileSQL()static String[]splitTableName(String tableAndSchemaName, String defaultSchemaName)Return the components of a schema qualified table name.static voidvalidateTableName(String tableName)Validate the schema qualified table name. 
 - 
 
- 
- 
Field Detail
- 
WRITE_FILE_RESOURCE_NAME
public static final String WRITE_FILE_RESOURCE_NAME
- See Also:
 - Constant Field Values
 
 
 - 
 
- 
Method Detail
- 
validateTableName
public static void validateTableName(String tableName) throws ExternalTableException
Validate the schema qualified table name. The format is [schema.]tableName.- Throws:
 ExternalTableException
 
- 
splitTableName
public static String[] splitTableName(String tableAndSchemaName, String defaultSchemaName)
Return the components of a schema qualified table name.- Parameters:
 tableAndSchemaName- schema qualified table name to be split into schema and table name components.- Returns:
 - a String[2] containing the schema name ([0]) and table name ([1]), or null if the tableName does not match the expected pattern specified by TABLE_PATTERN.
 
 
- 
getLocationSQL
public static String getLocationSQL()
Get LOCATION clause information from the ALL_EXTERNAL_LOCATIONS dictionary view. OWNER is a bind variable. The directory_path is fetched for debugging. 
- 
getWriteFileSQL
public static String getWriteFileSQL() throws IOException
- Throws:
 IOException
 
 - 
 
 -