Class OraTable

source code

Oracle table

Instance Methods

[hide private]

__init__(self, tableOwner="", tableName="")
Table creation

source code

getIndexedColumns(self, db)
Gets all table's indexed columns

source code

getPrimaryKeys(self, db)
Gets table primary key column name

source code

getLastAnalyzed(self, db)
Gets date of last statistics computation

source code

getNumRows(self, db)
Gets number of rows from table's statistics

source code

getAvgRowLength(self, db)
Gets average length of a single row from table's statistics

source code

getUsedBlocks(self, db)
Gets number of used blocks from table's statistics

source code

getNeededBlocks(self, db)
Gets number of really used blocks from rowids

source code

isPartitioned(self, db)
Gets True if the table is partitioned

source code

Inherited from OraTabular: getComment, getNumberOfColumns, getRowCount, getTableColumns

Inherited from OraObject: __eq__, __hash__, __str__, getCopy, getCreated, getDDL, getFullName, getLastDDL, getName, getOwner, getStatus, getType, guessInfos, guessStatus, setName, setOwner, setStatus, setType

Inherited from OraSegment: getTablespace

Method Details

[hide private]

init(self, tableOwner="", tableName="")
(Constructor)

source code

Table creation

Overrides: OraObject.__init__

getIndexedColumns(self, db)

source code

Gets all table's indexed columns

Returns:: array with column_name, index_name and index_position

getPrimaryKeys(self, db)

source code

Gets table primary key column name

Returns:: list of columns used in primary key. Empty list if not PK found

isPartitioned(self, db)

source code

Gets True if the table is partitioned

Returns:: true if table is partitioned, false otherwise

Class OraTable

__init__(self, tableOwner="", tableName="") (Constructor)

getIndexedColumns(self, db)

getPrimaryKeys(self, db)

isPartitioned(self, db)

init(self, tableOwner="", tableName="")
(Constructor)