Qore OracleSqlUtil Module Reference
1.4.4
|
the Oracle specialization for SqlUtil::AbstractDatabase More...
Inherits SqlUtil::AbstractDatabase.
Public Member Methods | |
constructor (AbstractDatasource nds, *hash opts) | |
creates the object from the arguments given | |
*OracleMaterializedView | getMaterializedView (string name) |
returns an OracleMaterializedView object for the package name given or NOTHING if the object does not exist or is not accessible | |
int | getMaximumPrecision () |
Returns the maximum precision for numeric or decimal columns. More... | |
*OraclePackage | getPackage (string name) |
returns an OraclePackage object for the package name given or NOTHING if the object does not exist or is not accessible | |
*OracleType | getType (string name) |
returns an OracleType object for the package name given or NOTHING if the object does not exist or is not accessible | |
list< string > | listMaterializedViews () |
returns a list of string materialized view names in the database | |
list< string > | listPackages () |
returns a list of string package names in the database | |
list< string > | listSynonyms () |
returns a list of string synonym names in the database | |
list< string > | listTypes () |
returns a list of string type names in the database | |
ListIterator | materializedViewIterator () |
returns an iterator listing the string materialized view names in the database | |
ListIterator | packageIterator () |
returns an iterator listing the string package names in the database | |
bool | rebuildIndexAnalyze (AbstractIndex index, int maxh, int maxleaf) |
analyze index with ALTER INDEX ANAYZE. Then it checks INDEX_STATS for advices to rebuild. More... | |
bool | rebuildIndexAnalyze (string name, int maxh, int maxleaf) |
analyze index with ALTER INDEX ANAYZE. Then it checks INDEX_STATS for advices to rebuild. More... | |
ListIterator | synonymIterator () |
returns an iterator listing the string synonym names in the database | |
ListIterator | typeIterator () |
returns an iterator listing the string type names in the database | |
Public Attributes | |
const | OracleAlignSchemaOptions = ... |
oracle-specific schema description / alignment options | |
const | OracleComputeStatisticsOptions = ... |
Options for computeStatistics() | |
const | OracleCreationOptions = ... |
oracle-specific generic creation options | |
const | OracleMaterializedViewDescriptionOptions = ... |
oracle-specific materialized view description options | |
const | OracleMaxPrecision = 38 |
MAximum precision for Oracle NUMBER columns. | |
const | OraclePackageDescriptionOptions = ... |
oracle-specific package description options | |
const | OracleRebuildIndexOptions = ... |
Options for rebuildIndex() | |
const | OracleReservedWords = ... |
hash of reserved words | |
const | OracleSchemaDescriptionOptions = ... |
oracle-specific schema description keys More... | |
Private Member Methods | |
computeStatisticsImpl (*hash options) | |
compute statistics implementation. See SqlUtil::AbstractDatabase::computeStatistics() | |
computeStatisticsSchemaImpl (*hash options) | |
compute statistics for schema - a helper method | |
computeStatisticsTablesImpl (*hash options) | |
compute statistics for table(s) - a helper method | |
hash< auto > | getAlignSchemaOptions () |
returns driver-specific options to the base abstract class | |
hash< auto > | getComputeStatisticsOptions () |
returns driver-specific options to the base abstract class | |
hash< auto > | getCreationOptions () |
returns driver-specific options to the base abstract class | |
softint | getCurrentSequenceValueImpl (string name) |
returns the last value issued for the given sequence in the current session | |
softint | getNextSequenceValueImpl (string name) |
returns the next value in the given sequence | |
int | getPhysicalSizeImpl () |
SqlUtil::AbstractDatabase.getPhysicalSize() | |
hash< auto > | getRebuildIndexOptions () |
returns driver-specific options to the base abstract class | |
hash< auto > | getSchemaDescriptionOptions () |
returns driver-specific options to the base abstract class | |
bool | rebuildIndexImpl (string name, *hash options) |
rebuild index implementation. See SqlUtil::AbstractDatabase::rebuildIndex() | |
reclaimSpaceImpl (*hash options) | |
reclaim space implementation. See SqlUtil::AbstractDatabase::reclaimSpace() | |
bool | supportsPackagesImpl () |
returns True if the database supports packages | |
bool | supportsSequencesImpl () |
returns True if the database supports sequences | |
bool | supportsTypesImpl () |
returns True if the database supports named types | |
the Oracle specialization for SqlUtil::AbstractDatabase
int OracleSqlUtil::OracleDatabase::getMaximumPrecision | ( | ) |
Returns the maximum precision for numeric or decimal columns.
bool OracleSqlUtil::OracleDatabase::rebuildIndexAnalyze | ( | AbstractIndex | index, |
int | maxh, | ||
int | maxleaf | ||
) |
analyze index with ALTER INDEX ANAYZE. Then it checks INDEX_STATS for advices to rebuild.
Outputs of this method are hints only. Real investigation of index is strongly recommended.
index | an AbstractIndex to analyze |
maxh | maximum oracle index height before rebuilding index |
maxleaf | maximum oracle percentage of deleted leaf nodes before rebuilding index |
ANALYZE-INDEX-ERROR | if there are no data in INDEX_STATS table |
analyze index with ALTER INDEX ANAYZE. Then it checks INDEX_STATS for advices to rebuild.
Outputs of this method are hints only. Real investigation of index is strongly recommended.
name | index name |
maxh | maximum oracle index height before rebuilding index |
maxleaf | maximum oracle percentage of deleted leaf nodes before rebuilding index |
ANALYZE-INDEX-ERROR | if there are no data in INDEX_STATS table |
const OracleSqlUtil::OracleDatabase::OracleSchemaDescriptionOptions = ... |
oracle-specific schema description keys
This constant extends SqlUtil::AbstractDatabase::SchemaDescriptionOptions as returned by OracleSqlUtil::OracleDatabase::getSchemaDescriptionOptions with the following Oracle-specific keys:
types:
for Oracle type definitionstype_map:
to automatically renaming Oracle types during schema alignmentpackages:
for Oracle package descriptionspackage_map:
for automatically renaming Oracle types during schema alignmentmaterialized_views:
for Oracle materialized view descriptionsmaterialized_view_map:
for automatically renaming Oracle materialized views during schema alignment