Meta Tables

Meta tables are system-defined tables that contain all information about database objects.

This section describes the types of meta tables and their structure, and explains how to read and update the information in meta tables.

Overview

Structure and Function

Meta tables are defined by the system for the purpose of managing database objects. They use the same data types and store records in the same way as user-defined tables. When Altibase starts up, it loads information about database objects. When DDL statements are executed, meta tables are used to read, store, and update this information. The owner of meta tables is the system user (user name: SYSTEM_), so normal users have limited access to meta tables.

Retrieving Information from Meta Tables

When a database object is created, deleted or modified using a DDL statement, the system creates, deletes, or updates records in one or more meta tables.

After a DDL statement is executed, the resultant changes to database objects can be confirmed by checking meta tables. This is accomplished using a SELECT statement, just as with a regular database table.

Modifying Data in Meta Tables

It is possible to use DML statements to explicitly make changes to the data in meta tables. However, the system-defined system user (SYSTEM_) can only make such changes to meta tables. Additionally, when the information in meta tables is changed, the system may become impossible to start, information about database objects may be lost, or the system may be critically damaged. Therefore, users must avoid making changes to meta tables whenever possible. When it is inevitable that a user must change meta table information, it is imperative that the database first be backed up, and it must be understood that the user is completely responsible for any damage resulting from making direct changes to meta table information.

Modifying Meta Table Schema

The meta table schema may be modified when a new kind of DDL statement is introduced, or when the functionality of an existing statement is changed. Depending on the characteristics of the changes to meta table schema, one of two cases may arise: either the database might need to be migrated, or the meta table schema will simply be automatically modified when Altibase is restarted. This should be kept in mind when upgrading Altibase to a newer version.

List of Meta Tables

This table shows the list of meta tables. Their names start with SYS_.

Meta Table Name	Description
SYS_AUDIT_	This table stores information about the operation status of the audit.
SYS_AUDIT_OPTS_	This view stores auditing conditions. SYS_AUDIT_ALL_OPTS_ is the base table of this view.
SYS_COLUMNS_	This table contains information about columns.
SYS_COMMENTS_	This table contains information about explanatory comments.
SYS_COMPRESSION_TABLES_	This table contains information about compressed columns.
SYS_CONSTRAINTS_	This table contains information about constraints.
SYS_CONSTRAINT_COLUMNS_	This table contains information about columns having constraints.
SYS_CONSTRAINT_RELATED_	This table contains information about the stored functions referenced by the constraints.
SYS_DATABASE_	This table contains information about the name and version of the database.
SYS_DATABASE_LINKS_	This table contains information about the database links.
SYS_DIRECTORIES_	This table contains information about directories used by stored procedures for managing files.
SYS_DN_USERS_	This table is reserved for future use.
SYS_DUMMY_	This table is for internal use only.
SYS_ENCRYPTED_COLUMNS_	This table contains additional security information for individual columns.
SYS_GRANT_OBJECT_	This table contains information about object privileges.
SYS_GRANT_SYSTEM_	This table contains information about system privileges.
SYS_INDEX_COLUMNS_	This table contains information about index key columns.
SYS_INDEX_PARTITIONS_	This table contains information about index partitions.
SYS_INDEX_RELATED_	This table contains information about the stored functions on which the function-based indexes are based.
SYS_INDICES_	This table contains information about indexes.
SYS_JOBS_	This table contains information about jobs.
SYS_LIBRARIES_	This table contains information about external library objects.
SYS_LOBS_	This table contains information about LOB columns.
SYS_MATERIALIZED_VIEWS_	This table contains information about materialized view.
SYS_PACKAGES_	This table contains information about packages.
SYS_PACKAGE_PARAS_	This table contains information about subprogram(stored procedures and stored functions) parameters contained in packages.
SYS_PACKAGE_PARSE_	This table contains information about statement texts of user-defined packages.
SYS_PACKAGE_RELATED_	This table contains information about tables, sequences, stored procedures, stored functions, or views accessed by stored procedures and stored functions inside packages.
SYS_PART_INDICES_	This table contains information about partitioned indexes.
SYS_PART_KEY_COLUMNS_	This table contains information about partitioning keys.
SYS_PART_LOBS_	This table contains information about LOB columns for respective partitions.
SYS_PART_TABLES_	This table contains information about partitioned tables.
SYS_PASSWORD_HISTORY_	This table contains information about alterations made to user passwords that have been assigned a password policy.
SYS_PASSWORD_LIMITS_	This meta table contains specified password management policies at user creation and account status quo.
SYS_PRIVILEGES_	This table contains information about privileges.
SYS_PROCEDURES_	This table contains information about stored procedures and functions.
SYS_PROC_PARAS_	This table contains information about the parameters for stored procedures and functions.
SYS_PROC_PARSE_	This table contains the actual text of stored procedures and stored functions.
SYS_PROC_RELATED_	This table contains information about tables accessed by stored procedures and functions.
SYS_RECYCLEBIN_	The table contains information about tables in the recycle bin.
SYS_REPLICATIONS_	This table contains general information about replication.
SYS_REPL_HOSTS_	This table contains information about replication hosts.
SYS_REPL_ITEMS_	This table contains information about tables to be replicated
SYS_REPL_OFFLINE_DIR_	This table contains information about the log directory related to the replication offline option.
SYS_REPL_OLD_CHECKS_	This table contains information about replication target columns that is being replicated by replication sender thread and has CHECK constraints.
SYS_REPL_OLD_CHECK_COLUMNS_	This meta table contains information about CHECK constraints on replication target column that replication sender thread is currently processing.
SYS_REPL_OLD_COLUMNS_	This table contains information about columns replicated by the replication sender thread.
SYS_REPL_OLD_INDEX_COLUMNS_	This table contains information about index columns replicated by the replication sender thread.
SYS_REPL_OLD_INDICES_	This table contains information about indexes replicated by the replication sender thread.
SYS_REPL_OLD_ITEMS_	This table contains information about the tables replicated by the replication sender thread.
SYS_REPL_TABLE_OID_IN_USE_	This table contains information about TABLE OID of tables included in DDL log but not yet replicated.
SYS_REPL_RECOVERY_INFOS_	This table contains information about logs used by replication for recovery of a remote server.
SYS_SECURITY_	This table contains information about the state of the security module.
SYS_SYNONYMS_	This table contains information about synonyms.
SYS_TABLES_	This table contains information about all kinds of tables.
SYS_TABLE_PARTITIONS_	This table contains information about table partitions.
SYS_TABLE_SIZE_	This table contains information about the actual size of disk and memory tables in the system.
SYS_TBS_USERS_	This table contains information about users' access to user-defined tablespaces.
SYS_TRIGGERS_	This table contains information about triggers.
SYS_TRIGGER_DML_TABLES_	This table contains information about tables accessed by triggers.
SYS_TRIGGER_STRINGS_	This table contains the actual text of trigger commands.
SYS_TRIGGER_UPDATE_COLUMNS_	This table contains information about columns that cause triggers to fire whenever their contents are changed.
SYS_USERS_	This table contains information about users.
DBA_USERS_	The DBA_USERS is a meta table which stores the user information. Only SYS can make an inquiry.
SYS_USER_ROLES_	This table stores information about the roles granted to the user.
SYS_VIEWS_	This table contains information about views.
SYS_VIEW_PARSE_	This table contains the actual text of statements used to create views.
SYS_VIEW_RELATED_	This table contains information about objects accessed by views.
SYS_XA_HEURISTIC_TRANS_	This table contains information about global transactions.
SYS_GEOMETRIES_	This table contains information about tables that have GEOMETRY columns.
SYS_GEOMETRY_COLUMNS_	This table contains information about GEOMETRY columns; The synonym of this meta table is GEOMETRY_COLUMNS_.
USER_SRS_	This table contains information about SRS(Spatial Reference System); The synonym of this meta table is SPATIAL_REF_SYS

SYS_AUDIT_

This meta table stores information about the operation status of the audit.

Column name	Type	Description
IS_STARTED	INTEGER	Whether or not auditing is being executed
START_TIME	DATE	The time at which auditing started
STOP_TIME	DATE	The time at which auditing stopped
RELOAD_TIME	DATE	The time at which the auditing conditions were applied to the server

Column Information

IS_STARTED

Indicates whether or not auditing is currently being performed.

0: Auditing is currently not being performed.

1: Auditing is currently being performed.

START_TIME

Indicates the time at which auditing started.

STOP_TIME

Indicates the time at which auditing stopped.

RELOAD_TIME

Indicates the time at which altered auditing conditions were applied to the Altibase server. The value of this column is updated for the occasions below:

• When the DBA has started auditing, using the ALTER SYSTEM START AUDIT statement.
• When the DBA has applied altered auditing conditions to auditing, using the ALTER SYSTEM RELOAD AUDIT statement.

SYS_AUDIT_OPTS_

This meta view stores auditing conditions. The base table of this view is the SYS_AUDIT_ALL_OPTS_ meta table.

Column name	Type	Description
USER_NAME	VARCHAR(128)	The user name
OBJECT_NAME	VARCHAR(128)	The object name
OBJECT_TYPE	VARCHAR(40)	The object type
SELECT_OP	CHAR(3)	The units in which logs are written for each operation statement
INSERT_OP	CHAR(3)
UPDATE_OP	CHAR(3)
DELETE_OP	CHAR(3)
MOVE_OP	CHAR(3)
MERGE_OP	CHAR(3)
ENQUEUE_OP	CHAR(3)
DEQUEUE_OP	CHAR(3)
LOCK_TABLE_OP	CHAR(3)
EXECUTE_OP	CHAR(3)
COMMIT_OP	CHAR(3)
ROLLBACK_OP	CHAR(3)
SAVEPOINT_OP	CHAR(3)
CONNECT_OP	CHAR(3)
DISCONNECT_OP	CHAR(3)
ALTER_SESSION_OP	CHAR(3)
ALTER_SYSTEM_OP	CHAR(3)
DDL_OP	CHAR(3)

Column Information

USER_NAME

This is the user name of the owner of the auditing target object.

OBJECT_NAME

This is the name of the auditing target object.

OBJECT_TYPE

This is the type of the target object, which is one of the following:

• TABLE
• VIEW
• QUEUE
• SEQUENCE
• PROCEDURE
• FUNCTION

XXX_OP

This is the units for logs of operation statements. Before '/' is the unit for logs of successful executions, and after is the unit for logs of failed executions.

The units for logs are as below:

• -: Logs are not written.
• S: Logs are written in the unit of sessions.
• A: Logs are written in the unit of accesses.
• T: Logs are written regardless the unit of session or accesses.

The following examples show values of the SYS_AUDIT_OPTS_ view after auditing conditions are enabled.

iSQL> AUDIT insert, select, update, delete on friends BY SESSION WHENEVER SUCCESSFUL;
Audit success.

iSQL> AUDIT insert, select, update, delete on friends BY ACCESS WHENEVER NOT SUCCESSFUL;
Audit success.

USER_NAME : SYS 
OBJECT_NAME : FRIENDS 
OBJECT_TYPE : TABLE 
SELECT_OP : S/A 
INSERT_OP : S/A 
UPDATE_OP : S/A 
DELETE_OP : S/A 
MOVE_OP : -/- 
MERGE_OP : -/- 
ENQUEUE_OP : -/- 
DEQUEUE_OP : -/- 
LOCK_TABLE_OP : -/- 
EXECUTE_OP : -/- 
COMMIT_OP : -/- 
ROLLBACK_OP : -/- 
SAVEPOINT_OP : -/- 
CONNECT_OP : -/- 
DISCONNECT_OP : -/- 
ALTER_SESSION_OP : -/- 
ALTER_SYSTEM_OP : -/- 
DDL_OP : -/-

iSQL> AUDIT DDL BY sys WHENEVER NOT SUCCESSFUL;
Audit success.


USER_NAME : SYS 
OBJECT_NAME : ALL 
OBJECT_TYPE : 
SELECT_OP : -/- 
INSERT_OP : -/- 
UPDATE_OP : -/- 
DELETE_OP : -/- 
MOVE_OP : -/- 
MERGE_OP : -/- 
ENQUEUE_OP : -/- 
DEQUEUE_OP : -/- 
LOCK_TABLE_OP : -/- 
EXECUTE_OP : -/- 
COMMIT_OP : -/- 
ROLLBACK_OP : -/- 
SAVEPOINT_OP : -/- 
CONNECT_OP : -/- 
DISCONNECT_OP : -/- 
ALTER_SESSION_OP : -/- 
ALTER_SYSTEM_OP : -/- 
DDL_OP : -/T

SYS_COLUMNS_

Information about columns defined in all tables, virtual columns in all views, and virtual columns in all sequences is stored in this meta table.

Column name	Type	Description
COLUMN_ID	INTEGER	The column identifier
DATA_TYPE	INTEGER	The data type
LANG_ID	INTEGER	The language identifier
OFFSET	BIGINT	The offset of the column within the record
SIZE	BIGINT	The physical length of the column within the record
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
PRECISION	INTEGER	The specified precision of the column
SCALE	INTEGER	The specified scale of the column
COLUMN_ORDER	INTEGER	The position of the column in the table
COLUMN_NAME	VARCHAR(128)	The name of the column
IS_NULLABLE	CHAR(1)	Whether NULL is permitted. T: can be NULL F: cannot be NULL
DEFAULT_VAL	VARCHAR(4000)	The default value or expression
STORE_TYPE	CHAR(1)	The column storage type V: variable type F: fixed type L: LOB column
IN_ROW_SIZE	INTEGER	The length of data that can be saved in a fixed area when data are saved in a variable-length column in a memory table
REPL_CONDITION	INTEGER	Deprecated
IS_HIDDEN	CHAR(1)	Whether the column is hidden or not T: hidden column F: public column
IS_KEY_PRESERVED	CHAR(1)	Whether or not the column is modifiable T: Modifiable F: Unmodifiable

Column Information

COLUMN_ID

This is the column identifier, which is assigned automatically by the system sequence.

DATA_TYPE

This is the data type identifier. The identifiers for each data type are as follows:

Data Type	Value
CHAR	1
VARCHAR	12
NCHAR	-8
NVARCHAR	-9
NUMERIC	2
DECIMAL	2
FLOAT	6
NUMBER	6
DOUBLE	8
REAL	7
BIGINT	-5
INTEGER	4
SMALLINT	5
DATE	9
BLOB	30
CLOB	40
BYTE	20001
NIBBLE	20002
BIT	-7
VARBIT	-100
GEOMETRY	10003

For more information about data types, please refer to Chapter 1. Data Types.

LANG_ID

A column that contains the language properties for character data types (CHAR, VARCHAR).

OFFSET

This indicates the physical starting point of a column within a record. The offset and size of a column are used to calculate the physical storage size of a record.

SIZE

This is the physical storage size of the column in a record, calculated by the system based on the column type, user-defined precision, etc.

USER_ID

This corresponds to a USER_ID value in the SYS_USERS_ meta table, and identifies the owner of the table to which the column belongs.

TABLE_ID

This corresponds to a TABLE_ID value in the SYS_TABLES_ meta table, and identifies the table to which the column belongs.

PRECISION

This is the precision of the data type, and is either defined by the user or corresponds to the default value for the system. In the case of a character data type, it corresponds to the length of the character data type set by the user.

SCALE

This is the scale of the data type, and is either defined by the user or corresponds to the default value for the system. This value is not used with some data types.

COLUMN_ORDER

This is the order in which columns appear in a table.

The order in which the columns are stated in a CREATE TABLE statement determines the order in which they are created, and thus their position in the table. If a column is added using an ALTER TABLE statement, the newly created column will be the last column in the table.

COLUMN_NAME

This is the name specified when a user creates a table or adds a column to the table.

IS_NULLABLE

Indicates whether NULL is allowed in the column.

When creating a column, the user can explicitly specify whether to allow NULL for the column. If not specified, NULL is allowed by default.

DEFAULT_VAL

The default value the user specified in the column is displayed.

If the column is a hidden column added automatically due to the creation of a function-based index, the formula used to create the function-based index is stored.

STORE_TYPE

When physically storing a column, it can either be written as part of a record, or it can be saved on another page, in which case only the location of the data is stored in the record.

If the physical storage size of a column is too big, or if the size of the column varies frequently for individual records, the column can be stored on another page by using the VARIABLE option when defining the column. This option is generally used for VARCHAR types where the character strings in a column are long.

This column indicates whether the VARIABLE option is used.

IN_ROW_SIZE

This is the default IN_ROW_SIZE when data are stored in variable-length columns in memory tables. When data are inserted into a variable-length column, if the length of the data is equal to or smaller than the value specified by IN_ROW_SIZE, the data are stored in the fixed space, whereas if the data are longer than this value, they are stored in a variable space. For disk tables, this value is always 0.

For more information about variable-length columns and the IN ROW clause, please refer to Chapter 1. Data Types.

IS_HIDDEN

This indicates whether the column has hidden properties or not. On the creation of function-based indexes, columns with hidden properties are automatically added to the table. One of the following two values is displayed in this column:

• T: Hidden column
• F: Public column

IS_KEY_PRESERVED

This indicates whether the column of the join view is modifiable with DML statements(INSERT, UPDATE, DELETE). For columns of regular tables, this value is specified as 'T'; for views, this value is specified as 'T' for modifiable columns, and 'F' for unmodifiable columns.

• T: Modifiable columns
• F: Unmodifiable columns

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_GEOMETRIES_

SYS_COMMENTS_

This meta table is for storing comments such as descriptions of user-defined tables, views and associated columns.

Column name	Type	Description
USER_NAME	VARCHAR(128)	The name of the user
TABLE_NAME	VARCHAR(128)	The name of the table
COLUMN_NAME	VARCHAR(128)	The name of the column
COMMENTS	VARCHAR(4000)	The actual comment

Column Information

USER_NAME

This is the name of the table owner. Its value corresponds to one of the USER_NAME values in the SYS_USERS_ meta table.

TABLE_NAME

This is the name of the table (or view). Its value is the same as one of the TABLE_NAME values appearing in SYS_TABLES_.

COLUMN_NAME

This is the name of a column in the table (or view). Its value is equal to a COLUMN_NAME value in the SYS_COLUMNS_ meta table.

However, if the comment pertains to an entire table (or view), the value for COLUMN_NAME will be NULL.

COMMENTS

This is the actual comment written by the user.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_COLUMNS_

SYS_COMPRESSION_TABLES_

This meta table stores information about compressed columns.

Column name	Type	Description
TABLE_ID	INTEGER	The identifier of the table with the compressed column
COLUMN_ID	INTEGER	The identifier of the compressed column
DIC_TABLE_ID	INTEGER	The identifier of the dictionary table in which data of the compressed column is actually stored
MAXROWS	BIGINT	The maximum number of rows that can be inserted in the table where data of the compressed column is stored (0: unlimited)

Column Information

TABLE_ID

This is the identifier of the table with the compressed column. This value corresponds to one TABLE_ID value of the SYS_TABLES_ meta table.

COLUMN_ID

This is the identifier of the compressed column. This value corresponds to one COLUMN_ID value of the SYS_COLUMNS_ meta table.

DIC_TABLE_ID

This is the identifier of the dictionary table in which data of the compressed column is actually stored.

MAXROWS

This is the maximum number of rows that can be inserted to the dictionary table where data of the compressed column is actually stored.

SYS_CONSTRAINTS_

This meta table contains information about table constraints.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
CONSTRAINT_ID	INTEGER	The constraint identifier
CONSTRAINT_NAME	VARCHAR(128)	The name of the constraint
CONSTRAINT_TYPE	INTEGER	The type of the constraint
INDEX_ID	INTEGER	The identifier of the index used by the constraint
COLUMN_CNT	INTEGER	The number of columns that are associated with the constraint
REFERENCED_TABLE_ID	INTEGER	The identifier of a table referenced in a FOREIGN KEY constraint
REFERENCED_INDEX_ID	INTEGER	The identifier of an index referenced in a FOREIGN KEY constraint
DELETE_RULE	INTEGER	Whether to perform cascade delete for a FOREIGN KEY constraint 0: Do not perform cascade delete 1: perform cascade delete 2: SET NULL, columns with dependent foreign key values are modified to NULL.
CHECK_CONDITION	VARCHAR(4000)	The character string condition of the CHECK constraint
VALIDATED	CHAR(1)	Whether all data conform to the constraint

Column Information

USER_ID

This is the user identifier, and corresponds to a USER_ID in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier for the table associated with the constraint, and will correspond to a TABLE_ID value in the SYS_TABLES_ meta table.

CONSTRAINT_ID

This is a constraint identifier. It is automatically assigned by the system sequence.

CONSTRAINT_NAME

This is the name of the constraint.

CONSTRAINT_TYPE

This indicates the type of the constraint. The possible types are as follows:

• 0: FOREIGN KEY
• 1: NOT NULL
• 2: UNIQUE
• 3: PRIMARY KEY
• 5: TIMESTAMP
• 6: LOCAL UNIQUE
• 7: CHECK

For additional information about each type of constraint, please refer to the description of column constraints in the explanation of the CREATE TABLE statement in the SQL Reference.

INDEX_ID

If an index must be created in order to define constraints such as UNIQUE or PRIMARY KEY constraints, the system creates an index internally. This is the identifier of that index, and will correspond to an INDEX_ID in the SYS_INDICES_ meta table.

COLUMN_CNT

This is the number of columns associated with the constraint. For example, for a constraint such as UNIQUE (i1, i2, i3), this value would be 3.

REFERENCED_TABLE_ID

This is the identifier of a table referenced in a FOREIGN KEY constraint (not the table for which the constraint is defined). This identifier will correspond to a TABLE_ID value in the SYS_TABLES_ meta table.

REFERENCED_INDEX_ID

This indicates a UNIQUE or PRIMARY KEY constraint that must exist in a table referenced by a FOREIGN KEY constraint. The identifier of this constraint will be the same as a CONSTRAINT_ID value in the SYS_CONSTRAINTS_ meta table.

CHECK_CONDITION

This displays the Integrity Rule defined by the user at CHECK constraint specification.

VALIDATED

This indicates whether all data conform to the constraint.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_INDICES_

SYS_CONSTRAINT_COLUMNS_

This meta table contains information about columns related to all constraints defined in user tables.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
CONSTRAINT_ID	INTEGER	The constraint identifier
CONSTRAINT_COL_ORDER	INTEGER	The position of the column in the constraint
COLUMN_ID	INTEGER	The column Identifier

Column Information

USER_ID

This is the user identifier, and corresponds to a USER_ID in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table in which the constraint is defined, and corresponds to a TABLE_ID value in the SYS_TABLES_ meta table.

CONSTRAINT_ID

This is the identifier of the constraint, and corresponds to a CONSTRAINT_ID value in the SYS_CONSTRAINTS_ meta table.

CONSTRAINT_COL_ORDER

This is the position of the column within the constraint. For example, when the constraint UNIQUE (i1,i2,i3) is created, three records are inserted into the SYS_CONSTRAINT_COLUMNS_ meta table. The position of column i1 is 1, column i2 is 2, and column i3 is 3.

COLUMN_ID

This is the identifier of the column for which the constraint is defined, and corresponds to a COLUMN_ID value in the SYS_COLUMNS_ meta table.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_CONSTRAINTS_
SYS_COLUMNS_

SYS_CONSTRAINT_RELATED_

This meta table contains information about the stored functions referenced by the constraints.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
CONSTRAINT_ID	INTEGER	The constraint identifier
RELATED_USER_ID	INTEGER	The identifier of the owner of the stored function referenced by the constraint
RELATED_PROC_NAME	VARCHAR(128)	The name of the stored function referenced by the constraint

Column Information

USER_ID

This is the identifier of the owner of the constraint, and is identical to one USER_ID value in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table which defines the constraint, and is identical to one TABLE_ID value in the SYS_TABLES_ meta table.

CONSTRAINT_ID

This is the identifier of the constraint, and is identical to one CONSTRAINT_ID value in the SYS_CONSTRAINTS_ meta table.

RELATED_USER_ID

This is the identifier of the owner of the stored function referenced by the constraint, and is identical to one USER_ID value in the SYS_USERS_ meta table.

RELATED_PROC_NAME

This is the name of the stored function referenced by the constraint, and is identical to one PROC_NAME value in the SYS_PROCEDURES_ meta table.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_CONSTRAINTS_
SYS_PROCEDURES_

SYS_DATABASE_

This is the table that contains the database name and meta table version information.

Column name	Type	Description
DB_NAME	VARCHAR(40)	The database name
OWNER_DN	VARCHAR(2048)	Reserved for future use
META_MAJOR_VER	INTEGER	The database meta table version (Main)
META_MINOR_VER	INTEGER	The database meta table version (Sub)
META_PATCH_VER	INTEGER	The database meta table version (Patch)

Column Information

DB_NAME

The database name specified when creating the database is saved.

META_MAJOR_VER

This value increases when a meta table is modified, added or removed. If the database version and the corresponding binary version of Altibase do not match, the database must be migrated.

META_MINOR_VER

This value increases when the contents of one or more meta tables is modified. If the version of the database does not correspond to the current version of Altibase, the system internally compares this value and automatically upgrades the meta tables to the newer version.

META_PATCH_VER

This indicates the meta table patch version.

SYS_DATABASE_LINKS_

This meta table is for storing Database Link information.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
LINK_ID	INTEGER	The Database Link identifier
LINK_OID	BIGINT	The Database Link object identifier
LINK_NAME	VARCHAR(40)	The Database Link name
USER_MODE	INTEGER	The access method to the remote server
REMOTE_USER_ID	VARCHAR(128)	The user account for a remote database
REMOTE_USER_PWD	BYTE(40)	The user password for a remote database
LINK_TYPE	INTEGER	Indicates whether it is a Heterogeneous Link or a Homogeneous Link.
TARGET_NAME	VARCHAR(40)	The name of the remote server which the database link object is to access
CREATED	DATE	The date and time at which the database link object is created
LAST_DDL_TIME	DATE	The time at which the database link object was most recently changed using a DDL statement

Column Information

USER_ID

This is the identifier of the user who owns the Database Link object.

LINK_ID

This is the Database Link identifier.

LINK_OID

This is the Database Link object identifier.

LINK_NAME

This is the name of the Database Link object, which is specified by the user when the Database Link object is created.

USER_MODE

This indicates the mode in which a remote server is accessed.

• 0: DEDICATE USER MODE
• 1: CURRENT USER MODE (reserved for future use)

REMOTE_USER_ID

This indicates a user account on a remote server, to be used when accessing a remote database server.

REMOTE_USER_PWD

This is the password for the user account on the remote server, to be used when accessing a remote database server. The password is encrypted using an encryption algorithm before it is stored.

LINK_TYPE

This indicates whether a heterogeneous link or a homogeneous link.

TARGET_NAME

This indicates the name of the remote server that the database link object will access.

CREATED

This indicates the date when the database link object was created.

LAST_DDL_TIME

This indicates the last time a DDL change occurred to a database link object.

SYS_DIRECTORIES_

This table contains information about directories that are used when files are managed using stored procedures

Column name	Type	Description
DIRECTORY_ID	BIGINT	The directory identifier
USER_ID	INTEGER	The user identifier
DIRECTORY_NAME	VARCHAR(128)	The directory name
DIRECTORY_PATH	VARCHAR(4000)	The absolute path of the directory on the system
CREATED	DATE	The time at which the directory was created
LAST_DDL_TIME	DATE	The most recent time at which a DDL task was used to change the directory object

Column Information

DIRECTORY_ID

This is a directory identifier. It is a unique value within the system.

USER_ID

This is the user identifier of the owner of the directory.

DIRECTORY_NAME

This is the name of the directory. It is a unique value within the system.

DIRECTORY_PATH

This is the absolute path where the directory is located. This value is explicitly set by the user when executing a CREATE DIRECTORY statement.

LAST_DDL_TIME

This is the most recent time at which a DDL task was used to change the directory object.

SYS_ENCRYPTED_COLUMNS_

This is the meta table for managing additional security information based on the security settings for individual columns.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the table to which the column belongs
TABLE_ID	INTEGER	The identifier of the table to which the column belongs
COLUMN_ID	INTEGER	The identifier of the encrypted column
ENCRYPT_PRECISION	INTEGER	The precision of the column encryption
POLICY_NAME	VARCHAR(16)	The name of the encryption policy
POLICY_CODE	VARCHAR(128)	The verification code of the encryption policy

SYS_GRANT_OBJECT_

This contains information about object privileges granted to a user.

Column name	Type	Description
GRANTOR_ID	INTEGER	The identifier of the user who granted the privileges
GRANTEE_ID	INTEGER	The identifier of the user to whom the privileges were granted
PRIV_ID	INTEGER	The privilege identifier
USER_ID	INTEGER	The identifier of the owner of the object
OBJ_ID	BIGINT	The identifier of the object
OBJ_TYPE	VARCHAR(1)	The type of object
WITH_GRANT_OPTION	INTEGER	Indicates whether the WITH_GRANT_OPTION is used when object access privileges are granted 0: Not used 1: Used

Column Information

GRANTOR_ID

This is the identifier of the user who granted the privilege, and corresponds to a USER_ID in the SYS_USERS_ meta table.

GRANTEE_ID

This is the identifier of the user to whom the privilege has been granted, and corresponds to a USER_ID in the SYS_USERS_ meta table. If an object privilege is granted to PUBLIC, however, the USER_ID value "0"(which does not exist in the SYS_USERS_ meta table) is displayed in this column.

PRIV_ID

This is the identifier of the privilege. It corresponds to a PRIV_ID in the SYS_PRIVILEGES_ meta table.

USER_ID

This is the user ID of the owner of the object for which the privilege has been granted. This value will correspond to a USER_ID in the SYS_USERS_ meta table.

OBJ_ID

This is the ID of the object for which the privilege has been granted. It corresponds with one, and only one, target object ID saved in the appropriate meta table.

If the target object is a table, view or sequence, it is mapped to a TABLE_ID in the SYS_TABLES_ meta table, whereas if it is a stored procedure or stored function, it is mapped to a PROC_OID in the SYS_PROCEDURES_ meta table.

OBJ_TYPE

This is the type of the object related to the privilege.

• A: Stored package
• D: Directory
• T: Table or View
• S: Sequence
• P: Stored procedure or function
• Y: Library

WITH_GRANT_OPTION

The WITH_GRANT_OPTION indicates whether the user to whom the privilege was granted is permitted to grant the privilege to other users.

Reference Tables

SYS_USERS_
SYS_PRIVILEGES_
SYS_TABLES_
SYS_PROCEDURES_

SYS_GRANT_SYSTEM_

This contains information about system privileges granted to users

Column name	Type	Description
GRANTOR_ID	INTEGER	The identifier of the user who granted the privilege
GRANTEE_ID	INTEGER	The identifier of the user to whom the privilege was granted
PRIV_ID	INTEGER	The identifier of the privilege

Column Information

GRANTOR_ID

This is the identifier of the user who granted the privilege, and corresponds to a USER_ID in the SYS_USERS_ meta table.

GRANTEE_ID

This is the identifier of the user to whom the privilege was granted, and corresponds to a USER_ID in the SYS_USERS_ meta table.

PRIV_ID

This is the identifier of the privilege, and corresponds to a PRIV_ID found in the SYS_PRIVILEGES_ meta table.

Reference Tables

SYS_USERS_
SYS_PRIVILEGES_

SYS_INDEX_COLUMNS_

This is the meta table that contains information about all columns associated with indexes defined for all tables.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the user
INDEX_ID	INTEGER	The identifier of the index
COLUMN_ID	INTEGER	The column identifier
INDEX_COL_ORDER	INTEGER	The position of the column in the index
SORT_ORDER	CHAR(1)	The sort order
TABLE_ID	INTEGER	The table identifier

Column Information

USER_ID

This is the identifier of the owner of the index, and corresponds to a USER_ID in the SYS_USERS_ meta table.

INDEX_ID

This is the identifier of the index, and corresponds to an INDEX_ID in the SYS_INDICES_ meta table.

COLUMN_ID

This is the identifier of the column for which the index was created, and corresponds to a COLUMN_ID in the SYS_COLUMNS_ meta table.

INDEX_COL_ORDER

In the case of a composite index, because a single index spans multiple columns, this value indicates the position of the column in the index

SORT_ORDER

This indicates whether the index is arranged in ascending or descending order.

• A: Ascending order
• D: Descending order

TABLE_ID

This is the identifier of the table in which the index was created, and corresponds to a TABLE_ID value in the SYS_TABLES_ meta table.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_COLUMNS_
SYS_INDICES_

SYS_INDEX_PARTITIONS_

This is the meta table for managing index partitions.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The tablespace identifier
INDEX_ID	INTEGER	The index identifier
TABLE_PARTITION_ID	INTEGER	The table partition identifier
INDEX_PARTITION_ID	INTEGER	The index partition identifier
INDEX_PARTITION_NAME	VARCHAR(128)	The index partition name
PARTITION_MIN_VALUE	VARCHAR(4000)	Reserved for future use
PARTITION_MAX_VALUE	VARCHAR(4000)	Reserved for future use
TBS_ID	INTEGER	The tablespace identifier
CREATED	DATE	The date and time at which the index partition is created
LAST_DDL_TIME	DATE	The time at which the index partition was most recently changed using a DDL statement

Column Information

USER_ID

This is the user identifier of the owner of the index. It corresponds to a USER_ID in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table in which the index is created. It is the same as a TABLE_ID value in the SYS_TABLES_ meta table.

INDEX_ID

This is the index identifier, and corresponds to an INDEX_ID in the SYS_INDICES_ meta table.

TABLE_PARTITION_ID

This is the table partition identifier.

INDEX_PARTITION_ID

This is the index partition identifier.

INDEX_PARTITION_NAME

This is the name of the index partition. It is specified by the user.

TBS_ID

This is the identifier of the tablespace in which the index is stored.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_INDICES_
SYS_TABLE_PARTITIONS_

SYS_INDEX_RELATED_

This meta table contains information about the stored functions on which the function-based indexes are based.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
INDEX_ID	INTEGER	The index identifier
RELATED_USER_ID	INTEGER	The identifier of the owner of the stored function referenced by the index
RELATED_PROC_NAME	VARCHAR(128)	) The name of the stored function referenced by the index

Column Information

USER_ID

This is the identifier of the owner of the index, and is identical to one USER_ID value in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table which defined the index, and is identical to one TABLE_ID value in the SYS_TABLES_ meta table.

INDEX_ID

This is the identifier of the index, and is identical to one INDEX_ID value in the SYS_INDICES_ meta table.

RELATED_USER_ID

This is the identifier of the owner of the stored function referenced by the index, and is identical to one USER_ID value in the SYS_USERS_ meta table.

RELATED_PROC_NAME

This is the name of the stored function referenced by the index, and is identical to one PROC_NAME value in the SYS_PROCEDURES_ meta table.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_INDICES_
SYS_PROCEDURES_

SYS_INDICES_

This is the meta table that contains information about all indexes defined for all tables.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
INDEX_ID	INTEGER	The index identifier
INDEX_NAME	VARCHAR(128)	The index name
INDEX_TYPE	INTEGER	The index type
IS_UNIQUE	CHAR(1)	Indicates whether the use of duplicate key values is allowed
COLUMN_CNT	INTEGER	The number of columns in the index
IS_RANGE	CHAR(1)	Indicates whether range scanning is possible using the index
IS_PERS	CHAR(1)	Indicates whether or not to permanently store the index
IS_DIRECTKEY	CHAR(1)	Indicates whether the index is a direct key index
TBS_ID	INTEGER	The tablespace identifier
IS_PARTITIONED	CHAR(1)	Indicates whether the index is partitioned
INDEX_TABLE_ID	INTEGER	Indicates the identifier for tables created by non-partitioned index of the partitioned table
CREATED	DATE	Indicates when the index was created
LAST_DDL_TIME	DATE	The time at which the index was most recently changed using a DDL statement

Column Information

USER_ID

This is the identifier of the owner of the index, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table in which the index was created, and corresponds to a TABLE_ID of the SYS_TABLES_ meta table.

INDEX_ID

This is an index identifier. It is automatically assigned by the system sequence.

INDEX_NAME

This is the name of the index.

INDEX_TYPE

This indicates the index type. A value of 1 indicates a B-TREE index, while a value of 2 indicates an R-TREE index.

IS_UNIQUE

This is indicates whether range scanning is possible using the index.

• T: Range scanning is possible.
• F: Range scanning is not possible.

COLUMN_CNT

This is the number of columns with which the index is associated.

IS_RANGE

This is indicates whether range scanning is possible using the index.

• T: Range scanning is possible.
• F: Range scanning is not possible.

IS_DIRECTKEY

This indicates whether the index is a direct key index.

• T: Direct key index
• F: Normal index

TBS_ID

This is the identifier of the tablespace in which the index was created.

IS_PARTITIONED

This indicates whether the index is partitioned. If it is 'T', the index is partitioned. If it is 'F', the index is not partitioned.

Reference Tables

SYS_USERS_
SYS_TABLES_

SYS_JOBS_

This meta table stores information about job objects.

Column name	Type	Description
JOB_ID	INTEGER	The job identifier
JOB_NAME	VARCHAR(128)	The job name
EXEC_QUERY	VARCHAR(1000)	The procedure registered for the job
START_TIME	DATE	The first time the job starts
END_TIME	DATE	The time the job ends
INTERVAL	INTEGER	The interval after which the job is to run
INTERVAL_TYPE	CHAR(2)	The unit of the interval after which the job is to run(YY, MM, DD, HH, MI)
STATE	INTEGER	The status of the job currently executing. 0: Is not running 1: Is running
LAST_EXEC_TIME	DATE	The last time the job was run
EXEC_COUNT	INTEGER	Execution frequency of the job
ERROR_CODE	CHAR(7)	An error code(NULL indicates success.)
IS_ENABLE	CHAR(1)	The status of job execution in the job scheduler. T: Possible to execute F: Impossible to execute
COMMENT	VARCHAR(4000)	An additional description for the job

Column Information

EXEC_QUERY

This indicates the procedure which is registered for the JOB and is executed.

INTERVAL_TYPE

This indicates the unit of time when an interval is set for the JOB. If a value exists in the INTERVAL column, this is the unit of the value.

• YY: Year
• MM: Mouth
• DD: Day
• HH: Hour
• MI: Minute

STATE

This indicates if a JOB is currently being executed or not.

• 0: Being executed
• 1: Not being executed

EXEC_COUNT

This indicates how many times a registered procedure has been executed since a JOB was created.

ERROR_CODE

This indicates the error code displayed if a procedure failed when the last JOB was executed. If succeeds, it is NULL.

IS_ENABLE

This indicates the possibility of job execution in the job scheduler.

• T: Executable
• F: Not executable

COMMENT

This statement is used to describe a JOB. If the description is not delineated, NULL values are queried.

SYS_LIBRARIES_

This is the meta table that contains information about external library objects.

Column name	Type	Description
LIBRARY_ID	BIGINT	The library identifier
USER_ID	INTEGER	The user identifier
LIBRARY_NAME	VARCHAR(128)	The library name
FILE_SPEC	VARCHAR(4000)	The file path of the dynamic library
DYNAMIC	VARCHAR(1)	Reserved for future use
STATUS	VARCHAR(7)	Reserved for future use
CREATED	DATE	The time at which the library object was created
LAST_DDL_TIME	DATE	The time at which the library object was changed using a DDL statement for the last time.

Column Information

LIBRARY_ID

This is the library identifier and has a unique value within the system.

USER_ID

This is the user identifier of the library owner.

LIBRARY_NAME

This is the name of the library object and it has a unique value within the system.

FILE_SPEC

This is the file path of the dynamic library which the library object points to and it is a relative path for the default file path of the library($ALTIBASE_HOME/lib).

SYS_LOBS_

This is the meta table containing information about LOB columns defined in tables.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
COLUMN_ID	INTEGER	The column identifier
TBS_ID	INTEGER	The tablespace identifier
LOGGING	CHAR(1)	This field is reserved for future use.
BUFFER	CHAR(1)	This field is reserved for future use.
IS_DEFAULT_TBS	CHAR(1)	Indicates whether a tablespace is designated for LOB column storage T: Specify F: Not to specify

Column Information

USER_ID

This is the identifier of the owner of the table to which the LOB column belongs, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table to which the LOB column belongs, and corresponds to a TABLE_ID value in the SYS_TABLES_ meta table.

COLUMN_ID

This is the LOB column identifier.

TBS_ID

This is the identifier of the tablespace to which the LOB column belongs.

IS_DEFAULT_TBS

This indicates whether a tablespace for storing a LOB column was specified by the user when the LOB column was created.

• T: Specify
• F Not to specify

For more detailed information, please refer to CREATE TABLE > LOB_STORAGE_CLAUSE statement in the SQL reference.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_COLUMNS_

SYS_MATERIALIZED_VIEWS_

This is a meta table that contains information about materialized views.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
MVIEW_ID	INTEGER	The materialized view identifier
MVIEW_NAME	VARCHAR(128)	The materialized view name
TABLE_ID	INTEGER	The table identifier
VIEW_ID	INTEGER	The view identifier
REFRESH_TYPE	CHAR(1)	The refresh type
REFRESH_TIME	CHAR(1)	The refresh time
CREATED	DATE	The time at which the table was created
LAST_DDL_TIME	DATE	The time when DDL was most recently used to make changes to a stored procedure
LAST_REFRESH_TIME	DATE	The last time the materialized view was refreshed

Column Information

USER_ID

This is the user identifier for the owner of the materialized view, it is identical to a USER_ID value of the SYS_USERS_ meta table.

MVIEW_ID

This is the materialized view identifier, automatically assigned by the database.

MVIEW_NAME

This is the name of the materialized view specified by the user.

TABLE_ID

This is the identifier for the table automatically created for the maintenance of the data of the materialized view. A table with the identical name of the materialized view can be checked by querying SYS_TABLES_ meta table with this identifier.

VIEW_ID

This is the identifier for the view automatically created for the maintenance of the data of the materialized view. This view can be looked up with this identifier at SYS_VIEWS_ meta table.

REFRESH_TYPE

This is the value that indicates the refresh time of the materialized view.

• C: COMPLETE
• F: FAST
• R: FORCE

REFRESH_TIME

This is the value that indicates the refresh time of the materialized view.

• D: ON DEMAND
• C: ON COMMIT

CREATED

This is the date and time that the materialized view is created.

LAST_DDL_TIME

This is the date and time that the last alterations to the materialized view were made.

LAST_REFRESH_TIME

This is the date and time that the materialized view was refreshed lastly.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_VIEWS_
SYS_VIEW_PARSE_

SYS_PACKAGES_

This meta table shows information about packages.

Column name	Type	Description
USER_ID	INTEGER	The user identifier of the package owner
PACKAGE_OID	BIGINT	The package identifier
PACKAGE_NAME	VARCHAR(128)	The package name
PACKAGE_TYPE	INTEGER	The package type. Indicates whether it is the package specification or the package body. 6: Package specification 7: Package body
AUTHID	INTEGER	The authority to execute the package 0: The definer 1: The current user
STATUS	INTEGER	The package status. If INVALID, the package is non-executable. 0: VALID 1: INVALID
CREATED	DATE	The time at which the package was created
LAST_DDL_TIME	DATE	The last time at which a DDL task was used to change the package

Column Information

USER_ID

This is the user identifier of the package owner; this value corresponds to one of the USER_ID values in the SYS_USERS_ meta table.

PACKAGE_OID

This is the package identifier; this value is automatically assigned by the system.

PACKAGE_NAME

This is the package name.

PACKAGE_TYPE

This is the value which indicates whether it is the package specification or the package body.

• 6: Package specification
• 7: Package body

AUTHID

This is the value which indicates authority to execute the package.

• 0: The definer
• 1: The current user

STATUS

This is the value which indicates whether or not the package is executable. 0(VALID) indicates that the package is executable.

• 0: VALID
• 1: INVALID

CREATED

This is the value which indicates the time at which the package was created.

LAST_DDL_TIME

This is the value which indicates the last time at which a DDL task was used to change the package.

Reference Tables

SYS_USERS_

SYS_PACKAGE_PARAS_

This meta table contains information about subprogram(stored procedures and stored functions) parameters contained in packages.

Column name	Type	Description
USER_ID	INTEGER	The user identifier of the package owner
OBJECT_NAME	VARCHAR(128)	The subprogram name
PACKAGE_NAME	VARCHAR(128)	The package name
PACKAGE_OID	BIGINT	The package identifier
SUB_ID	INTEGER	The subprogram identifier
SUB_TYPE	INTEGER	The subprogram type 0: Procedure 1: Function
PARA_NAME	VARCHAR(128)	The name of the subprogram parameter
PARA_ORDER	INTEGER	The position of the parameter. The first parameter is assigned 1.
INOUT_TYPE	INTEGER	Whether the parameter is an Input, Output, or Input/Output parameter
DATA_TYPE	INTEGER	The parameter data type
LANG_ID	INTEGER	The language identifier of the parameter type
SIZE	INTEGER	The size of the parameter type
PRECISION	INTEGER	The precision of the parameter type
SCALE	INTEGER	The scale of the parameter type
DEFAULT_VAL	VARCHAR(4000)	The default value of the parameter

Column Information

USER_ID

This is the user identifier of the stored procedure or stored function owner; this value corresponds to one of the USER_ID values in the SYS_USERS_ meta table.

OBJECT_NAME

This is the subprogram name.

PACKAGE_NAME

This is the package name.

PACKAGE_OID

This is the package identifier and is identical to one of the values of PACKAGE_OID, which is the package specification in the SYS_PACKAGES_ meta table. This is the package identifier; this value corresponds to one of the PACKAGE_OID values in the package specification of the SYS_ PACKAGES _ meta table.

SUB_ID

This is the subprogram identifier. Inside a package, subprogram identifiers start from 1 and are assigned numbers in the order in which they are written.

SUB_TYPE

This is the value which indicates whether the subprogram is a stored procedure or a stored function

• 0: Procedure
• 1: Function

PARA_NAME

This is the name of the subprogram parameter.

PARA_ORDER

This is the value which indicates the nth order in which the given parameter was defined among other parameters.

INOUT_TYPE

This is the value which indicates whether the parameter of the stored procedure or stored function is an INPUT, OUTPUT or INPUT/OUTPUT parameter.

• 0: IN
• 1: OUT
• 2: IN OUT

DATA_TYPE

This is the identifier of the parameter data type. Please refer to the description of the DATA_TYPE column in the SYS_COLUMNS_ meta table for the value of the data type identifier.

For more detailed information about data types, please refer to Chapter 1. Data Types.

LANG_ID

This is the column which displays information about the language properties of the character data types (CHAR, VARCHAR).

SIZE

This is the physical size of the data type.

PRECISION

This is the precision of the parameter data type, and is either specified by the user or assigned a default value by the system. For character data types, this value is the user-specified length of the character data type.

SCALE

This is the scale of the parameter data type, and is either specified by the user or assigned a default value by the system. Depending on the data type, the use of this value can be unnecessary.

For more detailed information about the scale and precision of data types, please refer to Chapter 1. Data Types.

DEFAULT_VAL

This is the default parameter value specified by the user at the definition of a parameter.

Reference Tables

SYS_USERS_
SYS_PACKAGES_

SYS_PACKAGE_PARSE_

This meta table contains the statement text of user-defined packages.

Column name	Type	Description
USER_ID	INTEGER	The user identifier of the package owner
PACKAGE_OID	BIGINT	The package identifier
PACKAGE_TYPE	INTEGER	The package type. Indicates whether it is the package specification or the package body. 6: Package specification 7: Package body
SEQ_NO	INTEGER	The position of the record among multiple records of split and saved statements
PARSE	VARCHAR(100)	The statement which was split and saved

Column Information

USER_ID

This is the user identifier of the package owner; this value corresponds to one of the USER_ID values in the SYS_USERS_ meta table.

PACKAGE_OID

This is the package identifier; this value corresponds to one of the PACKAGE_OID values in the SYS_ PACKAGES_ meta table.

PACKAGE_TYPE

This is the value which indicates whether it is the package specification or the package body.

• 6: Package specification
• 7: Package body

SEQ_NO

This is the value which indicates the nth order of each record among multiple records of split and saved package statements in SYS_PACKAGE_PARSE_.

PARSE

This is the string piece of the package statement. A CREATE PACKAGE statement can be made by searching for records with one PACKAGE_OID value and adding the PARSE values in the SEQ_NO order.

Reference Tables

SYS_USERS_
SYS_PACKAGES_

SYS_PACKAGE_RELATED_

This meta table contains information about tables, sequences, stored procedures, stored functions or views that are accessed by stored procedures and stored functions inside the package.

Column name	Type	Description
USER_ID	INTEGER	The user identifier of the package owner
PACKAGE_OID	BIGINT	The package identifier
RELATED_USER_ID	INTEGER	The owner identifier of the object referenced inside the package
RELATED_OBJECT_NAME	VARCHAR(128)	The object name referenced inside the package
RELATED_OBJECT_TYPE	INTEGER	The object type referenced inside the package

Column Information

USER_ID

This is the user identifier of the package owner; this value corresponds to one of the USER_ID values in the SYS_USERS_ meta table.

PACKAGE_OID

This is the package identifier; this value corresponds to the one of the PACKAGE_OID values in the SYS_ PACKAGES_ meta table.

RELATED_USER_ID

This is the user identifier of the owner of the object accessed by the stored procedure; this value corresponds to one of the USER_ID values in the SYS_USERS_ meta table.

RELATED_OBJECT_TYPE

This is the value which indicates the type of the object accessed by the stored procedure.

• 0: Stored procedure
• 1: Stored function
• 2: Table, sequence, view
• 3: Type set
• 4: Database link

Reference Tables

SYS_USERS_
SYS_PACKAGES_  
SYS_TABLES_

SYS_PART_INDICES_

This is the meta table for managing partitioned indexes. It contains information about partitioned indexes for which IS_PARTITIONED in SYS_INDICES_ is set to 'T'.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
INDEX_ID	INTEGER	The index identifier
PARTITION_TYPE	INTEGER	The partition type
IS_LOCAL_UNIQUE	CHAR(1)	Indicates whether an index is a local unique index

Column Information

USER_ID

This is the user identifier of the owner of the index, and corresponds to a USER_ID in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table for which the index was created, and corresponds to a TABLE_ID value in the SYS_TABLES_ meta table.

INDEX_ID

This is the index identifier. It corresponds to an INDEX_ID value in the SYS_INDICES_ meta table.

PARTITION_TYPE

This indicates whether the partition type is LOCAL or GLOBAL. However, because the GLOBAL partition type is not supported at present, it is always 0.

• 0: LOCAL
• 1: GLOBAL

IS_LOCAL_UNIQUE

This indicates whether an index is a local unique index, and can be 'T' or 'F'.

• T: A local unique index
• F: Not a local unique index

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_INDICES_

SYS_PART_KEY_COLUMNS_

This meta table shows information about the partitioning key columns for the partitioned objects

Column name	Type	Description
USER_ID	INTEGER	The user identifier
PARTITION_OBJ_ID	INTEGER	The partitioned object identifier
COLUMN_ID	INTEGER	The column identifier
OBJECT_TYPE	INTEGER	The object type
PART_COL_ORDER	INTEGER	The position of the column in the partitioning key (starting with 0)

Column Information

USER_ID

This is the identifier of the owner of the partitioned table or index. It corresponds to a USER_ID value in the SYS_USERS_ meta table.

PARTITION_OBJ_ID

This is the identifier of a partitioned object, and corresponds to a TABLE_ID value in the SYS_PART_TABLES_ meta table or INDEX_ID value in the SYS_PART_INDICES_ meta table.

COLUMN_ID

This is the identifier of the column in the partitioning key, and corresponds to a COLUMN_ID value in the SYS_COLUMNS_ meta table.

OBJECT_TYPE

This identifies the type of the object.

• 0: TABLE
• 1: INDEX

PART_COL_ORDER

This is the position of the column in the partitioning key (starting with 0).

Reference Tables

SYS_PART_INDICES_
SYS_TABLE_PARTITIONS_
SYS_COLUMNS_

SYS_PART_LOBS_

This is a meta table for managing LOB columns for respective partitions.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
PARTITION_ID	INTEGER	The partition identifier
COLUMN_ID	INTEGER	The column identifier
TBS_ID	INTEGER	The tablespace identifier
LOGGING	CHAR(1)	This field is reserved for future use.
BUFFER	CHAR(1)	This field is reserved for future use.

Column Information

USER_ID

This is the identifier of the owner of the table to which the LOB column belongs, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table to which the LOB column belongs, and corresponds to a TABLE_ID value in the SYS_TABLES_ meta table.

PARTITION_ID

This is the identifier of the partition in which the LOB column is stored.

COLUMN_ID

This is the LOB column identifier.

TBS_ID

This is the identifier of the tablespace to which the LOB column belongs.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_PART_TABLES_
SYS_COLUMNS_

SYS_PART_TABLES_

This is the meta table for the management of partitioned tables. The table information in SYS_PART_TABLES_ is information about partitioned tables for which IS_PARTITIONED in SYS_TABLES_ is set to 'T'.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
PARTITION_METHOD	INTEGER	The partitioning method
PARTITION_KEY_COUNT	INTEGER	The number of partition key columns
ROW_MOVEMENT	CHAR(1)	Indicates whether updated records can be moved between partitions

Column Information

USER_ID

This is the identifier of the owner of the index, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

TABLE_ID

This is the identifier of the table in which the index was created, and corresponds to a TABLE_ID value in the SYS_TABLES_ meta table.

PARTITION_METHOD

This indicates the partitioning method.

• 0: RANGE
• 1: HASH
• 2: LIST
• 3: RANGE PARTITIONING USING HASH

ROW_MOVEMENT

This indicates whether it is permissible for records that have been updated to be moved to other partitions when the value of a partition key column is updated.

• T: Movement of updated records between partition is permitted
• F: Movement of updated records between partition is forbidden

Reference Tables

SYS_USERS_
SYS_TABLES_

SYS_PASSWORD_HISTORY_

This meta table stores alterations made to user passwords that have been assigned a password policy.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
PASSWORD	VARCHAR(256)	The user password
PASSWORD_DATE	DATE	The date one which alterations are made to the user password

SYS_PASSWORD_LIMITS_

This meta table stores specified password management policies at user creation and account status quo.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
USER_NAME	VARCHAR(128)	The user name
ACCOUNT_STATUS	VARCHAR(30)	Indicates account status quo: EXPIRED EXPIRED(GRACE) LOCKED(TIMED) LOCKED EXPIRED & LOCKED(TIMED) EXPIRED(GRACE) & LOCKED(TIMED) EXPIRED & LOCKED EXPIRED(GRACE) & LOCKED
REMAIN_GRACE_DAY	VARCHAR(10)	The grace period remaining after password expiry date
FAILED_LOGIN_ATTEMPTS	VARCHAR(10)	The maximum number of times login failure is permitted
PASSWORD_LOCK_TIME	VARCHAR(10)	The amount of time needed to elapse for a locked account to become unlocked
PASSWORD_LIFE_TIME	VARCHAR(10)	The password validity period
PASSWORD_GRACE_TIME	VARCHAR(10)	The grace period following password expiry date
PASSWORD_REUSE_TIME	VARCHAR(10)	The amount of time needed to elapse for identical passwords to be available for reuse
PASSWORD_REUSE_MAX	VARCHAR(10)	The number of times identical passwords are available for reuse
PASSWORD_VERIFY_FUNCTION	VARCHAR(128)	The CALLBACK function for verifying passwords

SYS_PRIVILEGES_

This meta table contains information about the kinds of privileges supported by Altibase. For more detailed information, please refer to the descriptions of database privileges and of the GRANT statement in the Reference

Column name	Type	Description
PRIV_ID	INTEGER	The privilege identifier
PRIV_TYPE	INTEGER	The privilege type
PRIV_NAME	VARCHAR(128)	The privilege name

Column Information

PRIV_ID

This is the privilege identifier. It is defined internally by the system.

PRIV_TYPE

This indicates the type of privilege.

• 1: Indicates an object privilege
• 2: Indicates a system privilege

PRIV_NAME

This is the name of the privilege.

SYS_PROCEDURES_

This table is for storing information about stored procedures and stored functions, such as the stored procedure name, return type, number of parameters, whether it can be executed, etc.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the stored procedure
PROC_OID	BIGINT	The identifier of the stored procedure
PROC_NAME	VARCHAR(128)	The name of the stored procedure
OBJECT_TYPE	INTEGER	Indicates whether the object is a stored procedure, stored function, or type set
STATUS	INTEGER	Indicates the status of the object. The object cannot be executed if it is INVALID. 0: VALID 1: INVALID
AUTHID	INTEGER	The authority to execute the package - 0: The definer - 1: The current user
PARA_NUM	INTEGER	The number of parameters for the stored procedure
RETURN_DATA_TYPE	INTEGER	The return data type for the stored function
RETURN_LANG_ID	INTEGER	The return type language identifier
RETURN_SIZE	INTEGER	The size of the stored function return data type
RETURN_PRECISION	INTEGER	The precision of the stored function return data type
RETURN_SCALE	INTEGER	The size of the stored function return data type
PARSE_NO	INTEGER	The number of records containing statement fragments stored in SYS_PROC_PARSE_ for the procedure
PARSE_LEN	INTEGER	The total length of the procedure statement stored in SYS_PROC_PARSE_
CREATED	DATE	The date on which the object was created
LAST_DDL_TIME	DATE	The time when DDL was most recently used to make changes to a stored procedure

Column Information

USER_ID

This is the identifier of the owner of the stored procedure or stored function, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

PROC_OID

This is the identifier of the stored procedure or stored function, and is automatically assigned by the system.

PROC_NAME

This is the name of the stored procedure or stored function.

OBJECT_TYPE

This value allows stored procedures to be distinguished from stored functions. Stored functions differ from stored procedures in that they return a value.

• 0: Stored procedure
• 1: Stored function
• 3: Type set

STATUS

This value indicates whether a stored procedure or function may be executed. A value of 0 (VALID) indicates that it can be executed.

If a DDL statement is executed on an object that is accessed by a stored procedure or stored function, the stored procedure or stored function will become invalid. For example, if a new column is added to a table that is accessed by a stored procedure, the stored procedure will need to be re-compiled before it can be deemed VALID and executed. The status values are as follows:

• 0: VALID
• 1: INVALID

AUTHID

This is the value which indicates the authority to execute the procedure or function.

• 0: DEFINER
• 1: CURRENT_USER

PARA_NUM

This indicates the number of parameters defined for a stored procedure or stored function.

RETURN_DATA_TYPE

This is the data type identifier for the return value of a stored function. Information about data type identifiers can be found in the DATA_TYPE column of the SYS_COLUMNS_ meta table.

For more information about data types, please refer to Chapter 1. Data Types.

RETURN_LANG_ID

This column contains information about the language properties of the character data types (CHAR, VARCHAR).

RETURN_SIZE

This is the physical size of the return data type.

RETURN_PRECISION

This is the precision of the return data type, which is either defined by the user or set based on the system default. For character types, it is the length of the user-defined character type.

RETURN_SCALE

This is the scale of the return data type, which is either defined by the user or set as the system default. Depending on the type, this value may not be used.

For more information about data type precision and scale, please refer to Chapter 1. Data Types.

PARSE_NO

Stored procedure and stored function statements are divided into multiple records containing text fragments and stored in the SYS_PROC_PARSE_ meta table. This value indicates the number of records used to store a stored procedure or function.

PARSE_LEN

Stored procedure and stored function statements are divided into multiple records containing text fragments and stored in the SYS_PROC_PARSE_ meta table. This value indicates the overall length of the statement.

LAST_DDL_TIME

This is the most recent time at which a DDL statement was used to make changes to a stored procedure.

Reference Tables

SYS_USERS_

SYS_PROC_PARAS_

This meta table contains information about the parameters of stored procedures and stored functions.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the stored procedure
PROC_OID	BIGINT	The identifier of the stored procedure
PARA_NAME	VARCHAR(128)	The parameter name
PARA_ORDER	INTEGER	The parameter order. The first parameter is assigned the number 1.
INOUT_TYPE	INTEGER	Whether the parameter is an Input, Output, or Input/Output parameter
DATA_TYPE	INTEGER	The data type of the parameter
LANG_ID	INTEGER	The language identifier for the parameter type
SIZE	INTEGER	The size of the parameter type
PRECISION	INTEGER	The precision of the parameter type
SCALE	INTEGER	The scale of the parameter type
DEFAULT_VAL	VARCHAR(4000)	The default value for the parameter

Column Information

USER_ID

This is the identifier of the user who is the owner of the stored procedure or the stored function, and corresponds to a USER_ID in the SYS_USERS_ meta table.

PROC_OID

This is the identifier of the stored procedure or stored function, and corresponds to a PROC_ID in the SYS_PROCEDURES_ meta table

PARA_NAME

This is the parameter name.

PARA_ORDER

When there are multiple parameters, this value indicates the position of the parameter in the defined parameter order.

INOUT_TYPE

This value indicates whether the parameter for the stored procedure or stored function is an input, output, or input/output parameter.

• 0: IN
• 1: OUT
• 2: IN OUT

DATA_TYPE

This is the data type identifier for the parameter. The DATA_TYPE column in the SYS_COLUMNS_ meta table contains information about data type identifiers.

For more information about data types, please refer to Chapter 1. Data Types.

LANG_ID

This column displays the language properties for character type parameters (CHAR and VARCHAR).

SIZE

This is the physical size of the data type.

PRECISION

This is the precision of the parameter, which is either determined by the user or set based on the system default. The precision (length) of character data types is defined by the user.

SCALE

This is the scale of the parameter, which is either determined by the user or set to the system default. Depending on the data type, this value may not be used.

For more information about the scale and precision of data types, please refer to Chapter 1. Data Types.

DEFAULT_VAL

When a parameter is defined, this is the user-defined default parameter value.

Reference Tables

SYS_USERS_
SYS_PROCEDURES_

SYS_PROC_PARSE_

This meta table contains the text constituting user-defined stored procedures and stored functions.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the stored procedure or stored function
PROC_OID	BIGINT	The object identifier of the stored procedure
SEQ_NO	INTEGER	The position of the record among multiple records for a statement that was split and then saved
PARSE	VARCHAR(100)	A fragment of the text of the stored procedure or stored function

Column Information

USER_ID

This is the identifier of the owner of the stored procedure or stored function, and corresponds to a USER_ID in the SYS_USERS_ meta table.

PROC_OID

This is the identifier of the stored procedure or the stored function, and corresponds to a PROC_ID in the SYS_PROCEDURES_ meta table.

SEQ_NO

When the information for a statement for one stored procedure is saved across multiple records in SYS_PROC_PARSE_, this is the sequential position of an individual record.

PARSE

This is a line of text belonging to the stored procedure or stored function. An entire statement of a stored procedure can be re-created by retrieving all records that correspond to a single PROC_OID value and combining the PARSE values in order according to the SEQ_NO values.

Reference Tables

SYS_USERS_
SYS_PROCEDURES_

SYS_PROC_RELATED_

This table contains information about tables, sequences, stored procedures, stored functions, and views accessed by a stored procedure or stored function

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the stored procedure
PROC_OID	BIGINT	The identifier of the stored procedure
RELATED_USER_ID	INTEGER	The identifier of the owner of an object referenced within a stored procedure
RELATED_OBJECT_NAME	VARCHAR(128)	The name of an object referenced within a stored procedure
RELATED_OBJECT_TYPE	INTEGER	The type of an object referenced within a stored procedure

In the case where stored procedure PROC1 performs an INSERT on table t1, the identifiers for the owner of the stored procedure PROC1 and for the stored procedure itself would be stored in USER_ID and PROC_OID respectively, the identifiers for the owner of table t1 and for the table itself would be stored in RELATED_USER_ID and RELATED_OBJECT_NAME respectively, and the number 2 (signifying a table) would be stored in RELATED_OBJECT_TYPE.

Column Information

USER_ID

This is the identifier of the owner of the stored procedure or the stored function, and corresponds to a USER_ID in the SYS_USERS_ meta table.

PROC_OID

This is the identifier of the stored procedure or the stored function, and corresponds to a PROC_ID in the SYS_PROCEDURES_ meta table.

RELATED_USER_ID

This is the identifier of the owner of the object accessed by the stored procedure, and corresponds to a USER_ID in the SYS_USERS_ meta table.

RELATED_OBJECT_NAME

This is the name of the object accessed by the stored procedure.

RELATED_OBJECT_TYPE

This is the type of the object accessed by the stored procedure. The possible values are as follows:

• 0: Stored procedure
• 1: Stored function
• 2: Table, Sequence, View
• 3: Type set
• 4: Database link

Reference Tables

SYS_USERS_
SYS_PROCEDURES_
SYS_TABLES_

SYS_RECYCLEBIN_

This table contains information about tables in the recycle bin. If the value for the RECYCLEBIN_ENABLE property is set to 1, this table contains information about tables moved to the recycle bin using the DROP statement.

Column name	Type	Description
USER_NAME	VARCHAR(128)	The table owner
TABLE_NAME	VARCHAR(128)	The table name generated by the system so that the table can be managed in the recycle bin when it is dropped. A table with the same name can be dropped multiple times; different names are generated so that tables can be managed in the recycle bin.
ORIGINAL_TABLE_NAME	VARCHAR(128)	The table name before it was dropped.
TBS_NAME	VARCHAR(128)	The tablespace name in which the table is saved.
MEMORY_SIZE	BIGINT	The total memory space occupied by the memory table that was dropped.
DISK_SIZE	BIGINT	The total disk space occupied by the disk table that was dropped.
DROPPED	DATE	The date at which the table was dropped.

Column Information

TABLE_NAME

This is the table name generated by the system when it is moved to the recycle bin. If tables with the same name (ORIGINAL_TABLE_NAME) are dropped multiple times, new names are generated for the tables in the recycle bin.

SYS_REPLICATIONS_

This meta table contains information related to replication.

Column name	Type	Description
LAST_USED_HOST_NO	INTEGER	The most recently used remote server
HOST_COUNT	INTEGER	The number of remote servers
IS_STARTED	INTEGER	Whether replication is active
XSN	BIGINT	The Restart SN (Sequence Number), i.e. the SN from which the Sender will resume transmission of XLogs1
ITEM_COUNT	INTEGER	The number of replication target tables
CONFLICT_RESOLUTION	INTEGER	The replication conflict resolution method
REPL_MODE	INTEGER	The default replication mode
ROLE	INTEGER	The role of the sender thread
OPTIONS	INTEGER	A flag for additional replication features
INVALID_RECOVERY	INTEGER	Whether replication recovery is possible
REMOTE_FAULT_DETECT_TIME	DATE	The time at which a fault was detected on a remote server
GIVE_UP_TIME	DATE	The time at which replication was most recently abandoned
REPLICATION_NAME	VARCHAR(40)	The name of the replication object
GIVE_UP_XSN	BIGINT	The XSN at which replication was most recently abandoned
PARALLEL_APPLIER_COUNT	INTEGER	The number of appliers
REMOTE_XSN	BIGINT	The most recently processed SN on the remote server.
APPLIER_INIT_BUFFER_SIZE	BIGINT	Initial size of applier buffer

Column Information

REPLICATION_NAME

This is the name of the replication object, and is set by the user when the replication object is created.

LAST_USED_HOST_NO

This is the number of the most recently used remote server, and corresponds to a HOST_NO in the SYS_REPL_HOSTS_ meta table.

HOST_COUNT

This is the number of remote servers involved in replication, and is equal to the number of IP addresses stored in SYS_REPL_HOSTS_.

IS_STARTED

Indicates whether replication is active.

• 0: suspended
• 1: replication active

XSN

This indicates the SN from which the Sender thread must begin sending logs when replication is started.

ITEM_COUNT

This is the number of replication target tables. This number corresponds to the number of records in the SYS_REPL_ITEMS_ meta table for this replication object, with one record corresponding to each of these tables.

CONFLICT_RESOLUTION

This describes the replication conflict resolution method.

• 0: Default
• 1: Act as the Master server
• 2: Act as the Slave server

Please refer to the Replication Manual for more detailed information about replication conflict resolution methods.

REPL_MODE

This is the default replication mode, which is set when the replication object is created.

• 0: LAZY MODE (Default)
• 2: EAGER MODE

The default replication mode is used if the ALTER SESSION SET REPLICATION statement is not used to set the replication mode for a session.

For more detailed information about the default replication mode, please refer to the Replication Manual, and for detailed information about the ALTER SESSION SET REPLICATION statement, please refer to the SQL Reference.

ROLE

This indicates the role of the Sender thread.

• 0: Replication
• 1: Log Analyzer
• 2: Propagable Logging (Replication propagable logs)
• 3: Propagation (Send propagable logs)

For more detailed information, please refer to the Log Analyzer User's Manual.

OPTIONS

This flag indicates whether to use the recovery and offline options, which are extra replication features. The replication option types are as in the following. Each option is controlled by binary number and expressed as a decimal number. If more than two options are used, the sum of the binary numbers of each option is returned as decimal numbers.

• 0(00000000): Do not use the recovery or offline option
• 1(00000001): Use the recovery option
• 2(00000010): Use the offline option
• 4(00000100): Use the gapless option
• 8(00001000): Use the parallel applier option
• 16(00010000): Use the replication transaction grouping option
• 32(00100000): For internal use
• 64(01000000): Use the meta logging option

INVALID_RECOVERY

This value indicates whether recovery using replication is possible.

• 0: replication-based recovery is possible.
• 1: replication-based recovery is not possible.

REMOTE_FAULT_DETECT_TIME

This is the time at which a fault was detected on a remote server while replication was running.

GIVE_UP_TIME

This is the time at which replication was most recently abandoned, i.e. the time at which the replication Sender most recently gave up on replication.

GIVE_UP_XSN

This is the XSN at which replication was most recently abandoned.

PARALLEL_APPLIER_COUNT

This is the number of parallel applier.

REMOTE_XSN

This is the most recently processed SN on the remote server. When the Sender is restarted, the log with the SN smaller than the corresponding REMOTE_XSN is not sent but skipped.

APPLIER_INIT_BUFFER_SIZE

This property specifies the initial buffer size of the parallel applier when replication is performed with the receiver applier option enabled. The number of queues in the parallel applier is set to the value divided by XLog Size.

( applier queue size = applier_init_buffer_size / xlog size )

If the number of parallel applier queues is less than the value of the property REPLICATION_RECEIVER_APPLIER_QUEUE_SIZE, then the number of parallel applier queues is set to the value specified in the property REPLICATION_RECEIVER_APPLIER_QUEUE_SIZE.

Example

<Example> The following is an example of returning values when using the replication gapless option and parallel applier option together on a created replication rep1.

iSQL> alter replication rep1 set gapless enable;
Alter success.
iSQL> alter replication rep1 set parallel 4;
Alter success.
iSQL> select options from system_.sys_replications_;
OPTIONS     
--------------
12           
1 row selected.

SYS_REPL_HOSTS_

This meta table contains information related to remote servers defined in replication objects.

Column name	Type	Description
HOST_NO	INTEGER	The host identifier
REPLICATION_NAME	VARCHAR(40)	The replication name
HOST_IP	VARCHAR(64)	The IP address of the remote server
PORT_NO	INTEGER	The replication port number on the remote server
CONN_TYPE	VARCHAR(20)	The remote server connection method
IB_LATENCY	VARCHAR(10)	The RDMA_LATENCY option value for rsocket.

Column Information

HOST_NO

This is the serial number of the remote server, which is automatically assigned by the system sequence.

REPLICATION_NAME

This is the name of the replication object set by the user, and corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table.

HOST_IP

This is the IP address of the remote server.

PORT_NO

This is the replication port number on the remote server.

CONN_TYPE

This shows the remote server connection method.

• TCP : Used for TCP communication.
• UNIX_DOMAIN : Used for Unix Domain communication.
• IB : Used for InfiniBand communication.

IB_LATENCY

This is the value of the RDMA_LATENCY option of rsocket when using InfiniBand, This value is N/A when CONN_TYPE is not IB.

Reference Tables

SYS_REPLICATIONS_

SYS_REPL_ITEMS_

This meta table contains information about replication target tables.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The replication name
TABLE_OID	BIGINT	The table object identifier
LOCAL_USER_NAME	VARCHAR(128)	The name of a user owning a target table on the local server
LOCAL_TABLE_NAME	VARCHAR(128)	The name of a target table on the local server
LOCAL_PARTITION_NAME	VARCHAR(128)	The name of a partition on the local server
REMOTE_USER_NAME	VARCHAR(128)	The name of a user owning a target table on the remote server
REMOTE_TABLE_NAME	VARCHAR(128)	The name of a target table on the remote server
REMOTE_PARTITION_NAME	VARCHAR(128)	The name of a partition on the remote server
IS_PARTITION	CHAR(1)	Whether or not a table is partitioned
INVALID_MAX_SN	BIGINT	The highest log SN to skip
CONDITION	VARCHAR(1000)	Deprecated
REPLICATION_UNIT	CHAR(1)	The replication unit
IS_CONDITION_SYNCED	INTEGER	Whether or not a replication is conditional synced

One replication object can pertain to more than one table, and SYS_REPL_ITEMS_ has a record for each of these tables. For example, if a replication pertains to 10 tables, this meta table will contain 10 records pertaining to this replication.

Column Information

REPLICATION_NAME

This is the name of the replication object, which is defined by the user, and corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table

TABLE_OID

This is the identifier of the replication target table or partition, and corresponds to a TABLE_OID value in the SYS_TABLES_ meta table or a PARTITION_OID value in the SYS_TABLES_PARTITIONS meta table.

LOCAL_USER_NAME

This is the user name of the owner of the replication target table in the local system, and corresponds to a USER_NAME in the SYS_USERS_ meta table.

LOCAL_TABLE_NAME

This is the name of the replication target table in the local system, and corresponds to a TABLE_NAME in the SYS_TABLES_ meta table.

LOCAL_PARTITION_NAME

This is the name of the replication target partition on the local server.

REMOTE_USER_NAME

This is the user name of the owner of the replication target table in the remote system, and corresponds to a USER_NAME in the SYS_USERS_ meta table.

REMOTE_TABLE_NAME

This is the name of the replication target table in the remote system, and corresponds to a TABLE_NAME in the SYS_TABLES_ meta table.

REMOTE_PARTITION_NAME

This is the name of the replication target partition on the remote server.

IS_PARTITION

This is an identifier indicating whether a table is partitioned. If it is 'Y', the table is partitioned. If it is 'N', the table is not partitioned.

INVALID_MAX_SN

If DDL statements or Sync operations are executed on replication target tables, the most recently recorded SN is saved here. Table logs up to this SN are skipped when the table is replicated.

REPLICATION_UNIT

This is the unit of the replication target item. One of the following two values is indicated in this column.

• T: The replication target item is a table.
• P: The replication target item is a partition.

IS_CONDITION_SYNCED

Whether or not a replication is conditional synced

Reference Tables

SYS_REPLICATIONS_
SYS_USERS_
SYS_TABLES_

SYS_REPL_OFFLINE_DIR_

This meta table stores log directory information related to the offline replication option.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The replication name
LFG_ID	INTEGER	The identifier of the log file group
PATH	VARCHAR(512)	The offline log path

Column Information

REPLICATION_NAME

This is the user-defined replication name. It corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table.

LFG_ID

This is the identifier for the LFG which default value is '0'.

PATH

This is the absolute path in the system where the log file is saved.

SYS_REPL_OLD_CHECKS_

This meta table is for storing information about replication target columns that is being replicated by replication sender thread and has CHECK constraints.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The name of the replication object
TABLE_OID	BIGINT	The table object identifier
CONSTRAINT_ID	INTEGER	The identifier of CHECK constraint
CHECK_NAME	VARCHAR(40)	The name of the CHECK constraint
CONDITION	VARCHAR(4000)	The character string condition of the CHECK constraint

Column Information

REPLICATION_NAME

This is the name of the replication object set by the user, and can be found in the SYS_REPLICATIONS_ meta table.

TABLE_OID

This is the identifier for a replication target table currently being used by the replication sender thread. Its value may not be found in SYS_TABLES_ meta table if this table does not exist when the replication sender thread is processing replication log.

CONSTRAINT_ID

This is the identifier of the CHECK constraint that is being processed by replication sender thread, and corresponds to a CONSTRAINT_ID value in the SYS_CONSTRAINTS_ meta table.

Its value cannot be found in SYS_CONSTRAINTS_ if this CHECK constraint was removed while the replication sender thread was processing the replication log.

CHECK_NAME

This is the name of the CHECK constraint that replication sender thread is currently using. It corresponds to a CONSTRAINT_NAME value in the SYS_CONSTRAINTS_ meta table.

Its value cannot be found in SYS_CONSTRAINTS_ if this CHECK constraint was removed while the replication sender thread was processing the replication log.

CONDITION

This is the character string condition of the CHECK constraint that replication sender thread is currently using. It corresponds to a CHECK_CONDITION value in the SYS_CONSTRAINTS_ meta table.

Its value cannot be found in SYS_CONSTRAINTS_ if this CHECK constraint was removed while the replication sender thread was processing the replication log.

Reference Tables

SYS_REPLICATIONS_ 
SYS_TABLES_
SYS_CONSTRAINTS_

SYS_REPL_OLD_CHECK_COLUMNS_

This meta table is for storing information about CHECK constraints on replication target column that replication sender thread is currently processing.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The name of the replication object
TABLE_OID	BIGINT	The object identifier of the table
CONSTRAINT_ID	INTEGER	The identifier of CHECK constraint
COLUMN_ID	INTEGER	The identifier of column that has CHECK constraint

Column Information

REPLICATION_NAME

This is the name of the replication object set by the user, and can be found in the SYS_REPLICATIONS_ meta table.

TABLE_OID

This is the identifier for a replication target table currently being used by the replication sender thread. Its value may not be found in SYS_TABLES_ meta table if this table does not exist when the replication sender thread is processing replication log.

CONSTRAINT_ID

This is the identifier of the CHECK constraint that is being processed by replication sender thread, and corresponds to a CONSTRAINT_ID value in the SYS_CONSTRAINTS_ meta table.

Its value cannot be found in SYS_CONSTRAINTS_ if this CHECK constraint was removed while the replication sender thread was processing the replication log.

COLUMN_ID

This is the identifier of the column that is currently being processed by replication sender thread and has CHECK constraint. It corresponds to a COLUMN_ID value in the SYS_COLUMNS_ meta table. Its value cannot be found in SYS_COLUMNS_ if this CHECK constraint was removed while the replication sender thread was processing the replication log.

Reference Tables

SYS_REPLICATIONS_ 
SYS_TABLES_
SYS_CONSTRAINTS_
SYS_COLUMNS_

SYS_REPL_OLD_COLUMNS_

This meta table is for storing information about columns that are currently replicated by the replication Sender thread.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The name of the replication object
TABLE_OID	BIGINT	The object identifier of the table
COLUMN_NAME	VARCHAR(128)	The column name
MT_DATATYPE_ID	INTEGER	The data type identifier
MT_LANGUAGE_ID	INTEGER	The language identifier
MT_FLAG	INTEGER	An internal flag
MT_PRECISION	INTEGER	The number of digits
MT_SCALE	INTEGER	The number of digits to the right of the decimal point
MT_ENCRYPT_PRECISION	INTEGER	The number of digits in an encrypted column
MT_POLICY_NAME	VARCHAR(16)	The name of the policy used for an encrypted column
SM_ID	INTEGER	The column identifier
SM_FLAG	INTEGER	An internal flag
SM_OFFSET	INTEGER	The internal offset
SM_VARORDER	INTEGER	Indicates the order of stored columns by variables method in a table. Exceptionally, VARORDER is not given to the geometry data type. (Default : 0)
SM_SIZE	INTEGER	The internal size
SM_DIC_TABLE_OID	BIGINT	For a compressed column, the OID of the dictionary table
SM_COL_SPACE	INTEGER	The tablespace identifier
QP_FLAG	INTEGER	The internal flag
DEFAULT_VAL	VARCHAR(4000)	The default value of the column

Column Information

REPLICATION_NAME

This is the replication name, which is specified by the user. It corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table.

TABLE_OID

This is the identifier for a replication target table currently being used by the replication Sender thread. Its value may not correspond to any TABLE_OID value in SYS_TABLES_.

COLUMN_NAME

This is the name of a column currently being replicated by the replication Sender thread.

MT_DATATYPE_ID

This is the data type identifier, and is an internal value.

MT_LANGUAGE_ID

This is the language identifier, and is an internal value.

MT_FLAG

This is an internal flag used by Altibase server.

MT_PRECISION

For a numeric type column, this is the number of digits in the column.

MT_SCALE

For a numeric type column, this is the number of digits to the right of the decimal point in the column.

MT_ENCRYPT_PRECISION

For an encrypted numeric type column, this is the number of digits in the column.

MT_POLICY_NAME

For an encrypted column, this is the name of the policy used for the column.

SM_ID

This is the column identifier. Column identifiers start with 0.

SM_FLAG

This is a flag internally used by Altibase.

SM_OFFSET

This is an offset value internally used by Altibase.

SM_VARORDER

This indicates the order of a column among the columns stored with the variable method within a table. Exceptionally, VARORDER is not given to the geometry data type (Default value:0).

SM_SIZE

This is a size value internally used by Altibase server.

SM_DIC_TABLE_OID

For a compressed column, this is the OID of the dictionary table in which data of the compressed column is actually saved.

SM_COL_SPACE

This is the identifier of the tablespace in which the column data is saved.

QP_FLAG

This is the flag used internally by the Altibase server.

DEFAULT_VAL

The default value of the column is saved as a string and is used internally by the Altibase server.

Reference Tables

SYS_REPL_OLD_ITEMS_
SYS_REPL_OLD_INDICES_
SYS_REPL_OLD_INDEX_COLUMNS_

SYS_REPL_OLD_INDEX_COLUMNS_

This meta table is for storing information about columns currently being replicated by the replication Sender thread.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The replication name
TABLE_OID	BIGINT	The table object identifier
INDEX_ID	INTEGER	The index identifier
KEY_COLUMN_ID	INTEGER	The column identifier
KEY_COLUMN_FLAG	INTEGER	An internal flag
COMPOSITE_ORDER	INTEGER	The position of the column on which the index is based

Column Information

REPLICATION_NAME

This value corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table, and is the user-defined replication name.

TABLE_OID

This is the identifier of a table currently being replicated by the replication Sender thread. Its value may not correspond to any TABLE_OID value in SYS_TABLES_.

INDEX_ID

This is the identifier of an index currently being replicated by the replication Sender thread.

KEY_COLUMN_ID

This is the identifier of the column on which the index is based.

KEY_COLUMN_FLAG

This is an internal flag for the column on which the index is based.

COMPOSITE_ORDER

This is the position of the column on which the index is based.

Reference Tables

SYS_REPL_OLD_ITEMS_
SYS_REPL_OLD_COLUMNS_
SYS_REPL_OLD_INDICES_

SYS_REPL_OLD_INDICES_

This meta table contains information about indexes currently being replicated by the replication Sender thread.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The replication name
TABLE_OID	BIGINT	The object identifier of the table
INDEX_ID	INTEGER	The index identifier
INDEX_NAME	VARCHAR(128)	The index name
TYPE_ID	INTEGER	The index type identifier
IS_UNIQUE	CHAR(1)	Indicates whether or not the index is globally unique
IS_LOCAL_UNIQUE	CHAR(1)	Indicates whether or not the index is locally unique
IS_RANGE	CHAR(1)	Indicates whether or not range scanning is possible using the index

Column Information

REPLICATION_NAME

This is the user-defined replication name. Its value corresponds to a REPLICATION_NAME value in the SYS_REPLICATIONS_ meta table.

TABLE_OID

This is the identifier of a table currently being replicated by the replication Sender thread. Its value may be different from that of TABLE_OID in the SYS_TABLES_ meta table.

INDEX_ID

This is the identifier of an index currently being replicated by the replication Sender thread.

INDEX_NAME

This is the name of an index currently being replicated by the replication Sender thread.

TYPE_ID

This is an index type identifier, and is an internal value.

IS_UNIQUE

This indicates whether or not the index is globally unique. 'Y' signifies that the index is globally unique, and 'N' signifies that it is not globally unique.

IS_LOCAL_UNIQUE

This indicates whether or not the index is locally unique. 'Y' signifies that it is locally unique, and 'N' means that it is not locally unique.

IS_RANGE

This indicates whether or not the index is locally unique. 'Y' signifies that it is locally unique, and 'N' means that it is not locally unique.

Reference Tables

SYS_REPL_OLD_ITEMS_
SYS_REPL_OLD_COLUMNS_
SYS_REPL_OLD_INDEX_COLUMNS_

SYS_REPL_OLD_ITEMS_

This meta table contains information about tables currently being replicated by the replication Sender thread.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The partition name
TABLE_OID	BIGINT	The table object identifier
USER_NAME	VARCHAR(128)	The user name
TABLE_NAME	VARCHAR(128)	The table name
PARTITION_NAME	VARCHAR(128)	The name of the replication
PRIMARY_KEY_INDEX_ID	INTEGER	The index identifier of the primary key

Column Information

REPLICATION_NAME

This value corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table, and is the user-defined replication name.

TABLE_OID

This is the identifier of a table currently being replicated by the replication Sender thread. Its value may be different from the value of TABLE_OID in the SYS_TABLES_ meta table.

USER_NAME

This is the user name of the owner of the table being replicated on the local server. Its value corresponds to a USER_NAME in the SYS_USERS_ meta table.

TABLE_NAME

This is the name of the table being replicated on the local server. Its value corresponds to a TABLE_NAME value in the SYS_TABLES_ meta table.

PARTITION_NAME

This is the name of the partition containing the table being replicated on the local server.

PRIMARY_KEY_INDEX_ID

This is the identifier of a primary key index.

Reference Tables

SYS_REPL_OLD_COLUMNS_
SYS_REPL_OLD_INDICES_
SYS_REPL_OLD_INDEX_COLUMNS_

SYS_REPL_TABLE_OID_IN_USE_

This meta table is for managing information about TABLE OID of tables included in DDL log but not yet replicated.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The name of the replication object
OLD_TABLE_OID	BIGINTBIGINT	The old object identifier of the table before DDL
TABLE_OID	BIGINTBIGINT	The current object identifier of the table

Column Information

REPLICATION_NAME

This is the replication name, which is specified by the user. It corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table.

OLD_TABLE_OID

This is the old object identifier of the table that is included in DDL log not yet replicated.

TABLE_OID

This is the current object identifier of the table that is included in DDL log not yet replicated. It corresponds to a TABLE_OID in the SYS_REPL_ITEMS_ meta table.

SYS_REPL_RECOVERY_INFOS_

This is the meta table in which log information is written for use in recovery of the remote server.

Column name	Type	Description
REPLICATION_NAME	VARCHAR(40)	The name of the replication
MASTER_BEGIN_SN	BIGINT	The starting log number of a master transaction
MASTER_COMMIT_SN	BIGINT	The final log number of the master transaction
REPLICATED_BEGIN_SN	BIGINT	The starting log number of a replication transaction
REPLICATED_COMMIT_SN	BIGINT	The final log number of the replication transaction

Column Information

REPLICATION_NAME

This is the replication object name defined by the user, and corresponds to a REPLICATION_NAME in the SYS_REPLICATIONS_ meta table.

MASTER_BEGIN_SN

The starting log number of a master transaction occurring on a remote server.

MASTER_COMMIT_SN

The final log number of a master transaction occurring on a remote server.

REPLICATED_BEGIN_SN

The starting log number of a replication transaction occurring on the local server.

REPLICATED_COMMIT_SN

The final log number of a replication transaction occurring on the local server.

Reference Tables

SYS_REPLICATIONS_

SYS_SECURITY_

This table contains information about the state of the security module.

Column name	Type	Description
MODULE_NAME	VARCHAR(24)	The name of the security module
MODULE_VERSION	VARCHAR(40)	The version of the security module
ECC_POLICY_NAME	VARCHAR(16)	The name of the ECC policy
ECC_POLICY_CODE	VARCHAR(64)	The verification code of the ECC policy

This table shows whether a security module authored by a third party is being used.

In the case where a security module authored by a third party is in use, the SYS_SECURITY_ meta table contains information about the properties of the security module, whereas if no such security module is in use, the SYS_SECURITY_ meta table will contain no records.

SYS_SYNONYMS_

This is the table for storing information about synonyms, which provide alias functions for database objects.

Column name	Type	Description
SYNONYM_OWNER_ID	INTEGER	The user identifier
SYNONYM_NAME	VARCHAR(128)	The synonym name
OBJECT_OWNER_NAME	VARCHAR(128)	The name of the object owner
OBJECT_NAME	VARCHAR(128)	The name of the synonym target object
CREATED	DATE	The time at which the synonym was created
LAST_DDL_TIME	DATE	The most recent time at which a DDL statement was used to make changes to a synonym

Column Information

SYNONYM_OWNER_ID

This is the identifier of the owner of the synonym, and corresponds to a USER_ID in the SYS_USERS_ meta table.

SYNONYM_NAME

This is the synonym name, which is defined by the user.

OBJECT_OWNER_NAME

This is the name of the owner of the schema containing the object that is the target of the user-defined synonym.

OBJECT_NAME

This is the name of the object targeted by the user-defined synonym.

CREATED

This is the time at which the synonym was created.

LAST_DDL_TIME

This is the most recent time at which a DDL statement was used to create or make changes to the synonym.

Reference Table

SYS_USERS_

SYS_TABLES_

This table contains information about meta tables, user-defined tables, sequences and views.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
TABLE_OID	BIGINT	The table object identifier
COLUMN_COUNT	INTEGER	The number of columns in the table
TABLE_NAME	VARCHAR(128)	The name of the table
TABLE_TYPE	CHAR(1)	The object type
REPLICATION_COUNT	INTEGER	The number of replications related to the table
REPLICATION_RECOVERY_COUNT	INTEGER	The number of replications that use the recovery option and are related to the table
MAXROW	BIGINT	The maximum number of records that can be entered (0: no limit)
TBS_ID	INTEGER	The tablespace identifier
TBS_NAME	VARCHAR(128)	The name of the tablespace in which the table is stored
PCTFREE	INTEGER	See below
PCTUSED	INTEGER	See below
INIT_TRANS	INTEGER	The initial number of transactions that can be simultaneously used for update in a page
MAX_TRANS	INTEGER	The maximum number of transactions that can be simultaneously used for update in a page
INITEXTENTS	BIGINT	The initial number of extents when a table is created
NEXTEXTENTS	BIGINT	The number of extents that are added when a table is expanded
MINEXTENTS	BIGINT	The minimum number of extents in a table
MAXEXTENTS	BIGINT	The maximum number of extents in a table
IS_PARTITIONED	CHAR(1)	Indicates whether a table is partitioned
TEMPORARY	CHAR(1)	Whether or not the table is a temporary table. D: Is a transaction-specific temporary table P: Is a session-specific temporary table N: Is not a temporary table
HIDDEN	CHAR(1)	Indicates whether the table has hidden properties
ACCESS	CHAR(1)	The data access mode for the table
PARALLEL_DEGREE	INTEGER	The number of threads which execute parallel queries
CREATED	DATE	The time at which the table was created
LAST_DDL_TIME	DATE	The time at which the table was most recently changed using a DDL statement

Column Information

USER_ID

This is the identifier of the owner of the table, and corresponds to a USER_ID in the SYS_USERS_ meta table

TABLE_ID

This is the table identifier, which is automatically assigned by the system sequence.

TABLE_OID

This is the table object identifier, which is automatically and internally assigned by the system. Unlike TABLE_ID, which is used when the user reads meta tables, this value is used only for internal operations.

COLUMN_COUNT

This is the number of columns defined in the table.

TABLE_NAME

This is the table name, which is defined by the user.

TABLE_TYPE

Information not only about tables, but also about sequences, views, etc. is saved in the SYS_TABLES_ meta table. This type identifier is used to distinguish them, and consists of the following types:

• T: A table
• S: A sequence
• V: A view
• W: A sequence for queue use only
• Q: A queue
• M: A table automatically created for the maintenance of the data of the materialized view
• A: A view automatically created for the maintenance of the data of the materialized view
• G: An internal table for global index of
• D: A dictionary table internally used for actually storing compressed column data

REPLICATION_COUNT

This is the number of replication objects associated with the table.

REPLICATION_RECOVERY_COUNT

This is the number of replication objects that use the recovery option and are associated with the table.

MAXROW

This is the maximum number of records that can be inserted into the table.

TBS_ID

This is the identifier of the tablespace in which the table is saved.

PCTFREE

This is the minimum percentage of free space that must exist in order for it to be possible to update a page. Usually, an amount of space equal to the percentage specified in PCTFREE is kept free so that existing rows saved in a page can be updated. For example, if PCTFREE is set to 20, 20% of the space in the page is set aside for update operations, so data can be inserted only into 80% of the space in the page.

The user can set PCTFREE between 0 and 99 when executing the CREATE TABLE statement.

PCTUSED

This is a threshold below which the amount of used space in a page must decrease in order for the page to return to the state in which records can be inserted from the state in which only update operations are possible. If the amount of free space falls below the percentage specified in PCTFREE, it will become impossible to insert new records into the page, and it will only be possible to update and delete rows. If subsequent update or delete operations reduce the percentage of used space below the threshold specified by PCTUSED, it will become possible to insert new rows into the page again.

The user can set PCTUSED between 0 and 99 when the CREATE TABLE statement is executed.

* For more detailed explanations of PCTFREE and PCTUSED, please refer to the description of the CREATE TABLE statement in the SQL Reference.

INIT_TRANS

This is the initial number of update transactions that can be simultaneously executed, and is set when a page is created. The actual number of transactions can increase to the number specified in MAX_TRANS, as long as sufficient page space is available.

MAX_TRANS

This is the maximum number of update transactions that can be simultaneously executed for a single page.

INITEXTENTS

This denotes the number of extents that are available to be allocated when a table is created.

NEXTEXTENTS

This denotes the number of additional extents that are available to be allocated when the size of a table is increased.

MINEXTENTS

This denotes the minimum number of available extents for a table.

MAXEXTENTS

This denotes the maximum number of available extents for a table.

IS_PARTITIONED

This is an identifier that indicates whether a table is partitioned. If it is 'Y', the table is partitioned. If it is 'F', the table is not partitioned.

TEMPORARY

This indicates whether or not the table is a temporary table.

• D: A transaction-specific temporary table
• P: A session-specific temporary table
• N: Not a temporary table

HIDDEN

This indicates whether the table is hidden or not.

• Y: The table is hidden from the user
• N: the table is open to the user (normal table)

PARALLEL_DEGREE

This indicates the number of threads which execute parallel queries when scanning the partitioned table.

ACCESS

This is the data access mode for the table. The default mode is W which allows Read/Write.

• R: Read-Only mode
• W: Read/Write mode (default mode)
• A: Read/Add mode. This mode disallows the alteration/deletion of data.

Reference Table

SYS_USERS_

SYS_TABLE_PARTITIONS_

This is a meta table for the management of table partitions.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
TABLE_ID	INTEGER	The table identifier
PARTITION_OID	BIGINT	The partition object identifier
PARTITION_ID	INTEGER	The partition identifier
PARTITION_NAME	VARCHAR(128)	The partition name
PARTITION_MIN_VALUE	VARCHAR(4000)	The minimum reference value for a partition (NULL in the case of a hash partition)
PARTITION_MAX_VALUE	VARCHAR(4000)	The maximum reference value for a partition (NULL in the case of a hash partition)
PARTITION_ORDER	INTEGER	The position of the partition (required for hash partitions)
TBS_ID	INTEGER	The identifier of a tablespace
PARTITION_ACCESS	CHAR(1)	The data access mode for the partition
REPLICATION_COUNT	INTEGER	The number of replication objects related to this partition
REPLICATION_RECOVERY_COUNT	INTEGER	The number of replication objects which have enabled the recovery option for this partition
CREATED	DATE	The date and time at which the partition is created
LAST_DDL_TIME	DATE	The time at which the partition was most recently changed using a DDL statement

Column Information

USER_ID

This is the identifier of the table owner, and corresponds to a USER_ID in the SYS_USERS_ meta table.

TABLE_ID

This is the table identifier. It is assigned automatically by the system sequence.

PARTITION_OID

This is the partition object identifier. It is assigned automatically by the system. Unlike PARTITION_ID, which is used when viewing meta tables, it is used only internally by the system.

PARTITION_ID

This is the partition identifier.

PARTITION_NAME

This is the user-defined partition name.

PARTITION_MIN_VALUE

This is a string that gives the minimum reference value for a partition. It is NULL for hash partitions.

PARTITION_MAX_VALUE

This is a string that gives the maximum reference value for a partition. It is NULL for hash partitions.

PARTITION_ORDER

This is the position of the partition among the partitions. It is required for hash partitions.

TBS_ID

This is the identifier of the tablespace in which the table is stored.

PARTITION_ACCESS

This is the data access mode for the partition. The default mode is W which allows Read/Write.

• R: Read-Only mode
• W: Read/Write mode (default mode)
• A: Read/Append mode. This mode disallows the alteration/deletion of data.

REPLICATION_COUNT

This is the number of replication objects related to this partition.

REPLICATION_RECOVERY_COUNT

This is the number of replication objects which have enabled the recovery option for this partition.

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_PART_TABLES_

SYS_TABLE_SIZE_

This table stores information about the actual size of disk and memory tables in the system.

Column name	Type	Description
USER_NAME	VARCHAR(128)	The table owner
TABLE_NAME	VARCHAR(128)	The table name
TBS_NAME	VARCHAR(128)	The name of the tablespace in which the table is saved
MEMORY_SIZE	BIGINT	The memory table size
DISK_SIZE	BIGINT	The disk table size

SYS_TBS_USERS_

This meta table contains information about the relationship between users and user-defined tablespaces.

Column name	Type	Description
TBS_ID	INTEGER	The tablespace identifier
USER_ID	INTEGER	The user identifier
IS_ACCESS	INTEGER	Whether the user is allowed to access the tablespace

Column Information

TBS_ID

This is the tablespace identifier.

USER_ID

This is the identifier of a particular user. It corresponds to a USER_ID in the SYS_USERS_ meta table.

IS_ACCESS

This indicates whether the user is permitted to access the tablespace.

• 0: access not permitted
• 1: access permitted.

Reference Table

SYS_USERS_

SYS_TRIGGERS_

This meta table contains default information about triggers.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
USER_NAME	VARCHAR(128)	The user name
TRIGGER_OID	BIGINT	The trigger identifier
TRIGGER_NAME	VARCHAR(128)	The trigger name
TABLE_ID	INTEGER	The table identifier
IS_ENABLE	INTEGER	Indicates whether the trigger is enabled
EVENT_TIME	INTEGER	Indicates when the trigger fires
EVENT_TYPE	INTEGER	The trigger event type
UPDATE_COLUMN_CNT	INTEGER	The number of columns that can cause a trigger to fire if updated
GRANULARITY	INTEGER	The units in which the trigger is executed
REF_ROW_CNT	INTEGER	The number of ALIASes for a REFERENCING statement
SUBSTRING_CNT	INTEGER	The number of records in which the trigger statement is saved
STRING_LENGTH	INTEGER	The total length of the trigger statement character string
CREATED	DATE	The time at which the trigger was created
LAST_DDL_TIME	DATE	The most recent time at which a DDL statement was used to make changes to the trigger

Column Information

USER_ID

This is the identifier of the user who owns the trigger, and corresponds to a USER_ID in the SYS_USERS_ meta table.

USER_NAME

This is the user name, and corresponds to a USER_NAME in the SYS_USERS_ meta table.

TRIGGER_OID

This is the trigger identifier. It is automatically assigned by the system.

TRIGGER_NAME

This is the user-defined trigger name.

TABLE_ID

This is the identifier of the table on which the trigger is defined, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table.

IS_ENABLE

This value indicates whether or not the trigger is enabled. It can be modified using the ALTER TRIGGER statement.

• 0: DISABLED
• 1: ENABLED

EVENT_TIME

This displays the time point that the trigger fires.

• 1: BEFORE
• 2: AFTER
• 3: INSTEAD OF

EVENT_TYPE

This is the type of the event that causes the trigger to fire.

• 1: INSERT
• 2: DELETE
• 4: UPDATE

UPDATE_COLUMN_CNT

This is the number of columns that cause a trigger to fire when updated. This value is equal to the number of records related to the trigger in the SYS_TRIGGER_UPDATE_COLUMNS_ meta table.

GRANULARITY

This value indicates how often the trigger fires:

• 1: FOR EACH ROW
• 2: FOR EACH STATEMENT

REF_ROW_CNT

This is the number of ALIASes defined in a REFERENCING statement.

SUBSTRING_CNT

One trigger statement is divided into several records and stored in the SYS_TRIGGER_STRINGS_ meta table. This value indicates the number of records used to store the statement.

STRING_LENGTH

This is the total length of the trigger statement character string.

Reference Tables

SYS_USERS_
SYS_TABLES_

SYS_TRIGGER_DML_TABLES_

This meta table contains information about tables referenced by triggers.

Column name	Type	Description
TABLE_ID	INTEGER	The table identifier
TRIGGER_OID	BIGINT	The trigger identifier
DML_TABLE_ID	INTEGER	The table identifier within the trigger
STMT_TYPE	INTEGER	The type of executable statement

Column Information

TABLE_ID

This is the identifier of the table on which the trigger is defined, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table.

TRIGGER_OID

This is the trigger identifier, and corresponds to a TRIGGER_OID in the SYS_TRIGGERS_ meta table.

DML_TABLE_ID

This is the identifier of the table that is accessed using the DML statements within the trigger, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table

STMT_TYPE

This is the type of statement executed on a table.

• 8: DELETE
• 19: INSERT
• 33: UPDATE

Reference Tables

SYS_TABLES_
SYS_TRIGGERS_

SYS_TRIGGER_STRINGS_

This is the meta table in which the trigger statements are saved.

Column name	Type	Description
TABLE_ID	INTEGER	The table identifier
TRIGGER_OID	BIGINT	The trigger identifier
SEQNO	INTEGER	The position of this text fragment in the trigger statement
SUBSTRING	VARCHAR(100)	A fragment of trigger statement text

Column Information

TABLE_ID

This is the table identifier, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table.

TRIGGER_OID

This is the trigger identifier, and corresponds to a TRIGGER_OID in the SYS_TRIGGERS_ meta table.

SEQNO

When information about a single trigger statement is saved as several records in SYS_TRIGGER_STRINGS, this is the position of this record among the records.

SUBSTRING

This is a fragment of the trigger statement text. When records are searched for using a single TRIGGER_OID and their SUBSTRING values are concatenated in the order described in SEQNO, the complete trigger command can be reconstructed.

Reference Tables

SYS_TABLES_
SYS_TRIGGERS_

SYS_TRIGGER_UPDATE_COLUMNS_

This meta table contains information about columns that cause triggers to fire when updated.

Column name	Type	Description
TABLE_ID	INTEGER	The table identifier
TRIGGER_OID	BIGINT	The trigger identifier
COLUMN_ID	INTEGER	The column identifier

Column Information

TABLE_ID

This is the table identifier, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table.

TRIGGER_OID

This is the trigger identifier, and corresponds to a TRIGGER_OID in the SYS_TRIGGERS_ meta table.

COLUMN_ID

This is the column ID, and corresponds to a COLUMN_ID in the SYS_COLUMNS_ meta table.

Reference Tables

SYS_TABLES_
SYS_TRIGGERS_

SYS_USERS_

This meta table contains information about database users.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
USER_NAME	VARCHAR(128)	The user name
PASSWORD	VARCHAR(256)	The user password
DEFAULT_TBS_ID	INTEGER	The default tablespace identifier
TEMP_TBS_ID	INTEGER	The temporary tablespace identifier
ACCOUNT_LOCK	CHAR(1)	Whether the account is locked/unlocked N: UNLOCKED L: LOCKED
ACCOUNT_LOCK_DATE	DATE	The date on which the account was locked
PASSWORD_LIMIT_FLAG	CHAR(1)	Indicates the use of password management policies T: used F: not used
FAILED_LOGIN_ATTEMPTS	INTEGER	The maximum number of times login failure is permitted
FAILED_LOGIN_COUNT	INTEGER	The number of times login fails
PASSWORD_LOCK_TIME	INTEGER	The amount of time needed to elapse for a locked account to become unlocked
PASSWORD_EXPIRY_DATE	DATE	The password expiry date
PASSWORD_LIFE_TIME	INTEGER	The password validity period
PASSWORD_GRACE_TIME	INTEGER	The password grace period following expiration
PASSWORD_REUSE_DATE	DATE	The date on which identical passwords are available for reuse
PASSWORD_REUSE_TIME	INTEGER	Not used
PASSWORD_REUSE_MAX	INTEGER	The number of times identical passwords are available for reuse
PASSWORD_REUSE_COUNT	INTEGER	Not used
PASSWORD_VERIFY_FUNCTION	VARCHAR(128)	The CALLBACK function for verifying passwords
USER_TYPE	CHAR(1)	Indicates the user type U: User R: Role
DISABLE_TCP	CHAR(1)	Availability of TCP connection T: TCP connection is disabled; SSL or IPC is enabled. F: TCP connection is enabled.
CREATED	DATE	The time at which the database user was created
LAST_DDL_TIME	DATE	The most recent time at which a DDL statement was used to make changes to the user

Column Information

USER_ID

This is the user identifier. It is automatically assigned by the system sequence.

USER_NAME

This is the user-defined user name.

PASSWORD

This is the encrypted user password.

DEFAULT_TBS_ID

This is the identifier of the default tablespace, which is used when the user creates an object without explicitly specifying a tablespace.

TEMP_TBS_ID

This is the identifier for the user temporary tablespace.

DISABLE_TCP

Displays the availability of TCP connection.

Reference Table

DBA_USERS_

DBA_USERS_

This is a meta table which records the information of database user and it can only be viewed by the SYS user. Note that the information of tables and columns is identical with the SYS_USERS_.

Column name	Type	Description
USER_ID	INTEGER	The user identifier
USER_NAME	VARCHAR(128)	The user name
PASSWORD	VARCHAR(256)	The user password
DEFAULT_TBS_ID	INTEGER	The default tablespace identifier
TEMP_TBS_ID	INTEGER	The temporary tablespace identifier
ACCOUNT_LOCK	CHAR(1)	Indicates whether account is locked N: UNLOCKED L: LOCKED
ACCOUNT_LOCK_DATE	DATE	The data the account was locked
PASSWORD_LIMIT_FLAG	CHAR(1)	Indicates whether password management policy is used. T: Enable password management policy F: Disable password management policy
FAILED_LOGIN_ATTEMPTS	INTEGER	The maximum number of failed login attempts
FAILED_LOGIN_COUNT	INTEGER	The login failed count
PASSWORD_LOCK_TIME	INTEGER	The amount of time that must elapse after an account is locked once and then released again
PASSWORD_EXPIRY_DATE	DATE	The password expiration date
PASSWORD_LIFE_TIME	INTEGER	The password expiration time
PASSWORD_GRACE_TIME	INTEGER	The grace time after password expiration
PASSWORD_REUSE_DATE	DATE	The date when the same password will be reused
PASSWORD_REUSE_TIME	INTEGER	Not used
PASSWORD_REUSE_MAX	INTEGER	The number of reuse of the same password
PASSWORD_REUSE_COUNT	INTEGER	Not used
PASSWORD_VERIFY_FUNCTION	VARCHAR(128)	The Callback function to verify password
USER_TYPE	CHAR(1)	The user type display U: User R: Role
DISABLE_TCP	CHAR(1)	Indicates whether or not TCP connection is in use. T: Failed TCP connection, communication only with SSL or IPC F: Allow TCP connection
CREATED	DATE	The time when the database user was created
LAST_DDL_TIME	DATE	The time when the last DDL change occurred for a user

Column Information

USER_ID

This is the user identifier, automatically assigned by a sequence in the system.

USER_NAME

This is the name of the user specified by the user.

PASSWORD

This is encrypted with the user's password.

DEFAULT_TBS_ID

This is the default tablespace identifier, used when the user does not explicitly specify a tablespace when creating an object.

TEMP_TBS_ID

This is the user's temporary tablespace identifier.

DISABLE_TCP

This indicates to allow or restrict the user's TCP connection.

SYS_USER_ROLES_

This meta table stores information about the roles granted to the user.

Column name	Type	Description
GRANTOR_ID	INTEGER	The identifier of the user to whom the role is granted
GRANTEE_ID	INTEGER	The identifier of the user who granted the role
ROLE_ID	INTEGER	The role identifier

Column Information

GRANTOR_ID

This is the identifier of the user who granted the role, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

GRANTEE_ID

This is the identifier of the user to whom the role is granted, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

ROLE_ID

This is the role identifier, and corresponds to a USER_ID value in the SYS_USERS_ meta table.

Reference Table

SYS_USERS_
SYS_TABLES_

SYS_VIEWS_

Basic information about views is stored in the SYS_TABLES_ meta table. This meta table contains additional information about views.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the view
VIEW_ID	INTEGER	The view identifier
STATUS	INTEGER	The view status
READ_ONLY	CHAR(1)	Displays whether the view is a read-only view

Column Information

USER_ID

This is the identifier of the view owner, and corresponds to a USER_ID in the SYS_USERS_ meta table.

VIEW_ID

This is the view identifier, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table.

STATUS

This value indicates the status of the view:

• 0: VALID
• 1: INVALID

Reference Tables

SYS_USERS_
SYS_TABLES_

SYS_VIEW_PARSE_

This meta table contains the text of view creation statements.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the view
VIEW_ID	INTEGER	The identifier of the view
SEQ_NO	INTEGER	When a view creation statement text is split and the text is saved as multiple text fragments in SYS_VIEW_PARSE_, this is the position of the record among the records.
PARSE	VARCHAR(100)	A text fragment of the view creation statement

Column Information

USER_ID

This is the identifier of the view owner, and corresponds to a USER_ID in the SYS_USERS_ meta table.

VIEW_ID

This is the view identifier, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table.

SEQ_NO

When a single statement corresponding to one view is saved as multiple records in SYS_VIEW_PARSE_, this is the position of the record among the records.

PARSE

When records are searched for using a single VIEW_ID and their PARSE values are concatenated in the order described in SEQ_NO, the complete view statement can be reconstructed.

Reference Tables

SYS_USERS_
SYS_TABLES_

SYS_VIEW_RELATED_

This meta table contains information about objects accessed by user-defined views.

Column name	Type	Description
USER_ID	INTEGER	The identifier of the owner of the view
VIEW_ID	INTEGER	The view identifier
RELATED_USER_ID	INTEGER	The identifier of the owner of the object that the view accesses
RELATED_OBJECT_NAME	VARCHAR(128)	The name of the object accessed by the view
RELATED_OBJECT_TYPE	INTEGER	The type of the object accessed by the view

Column Information

USER_ID

This is the identifier of the view owner, and corresponds to a USER_ID in the SYS_USERS_ meta table.

VIEW_ID

This is the identifier of the view, and corresponds to a TABLE_ID in the SYS_TABLES_ meta table.

RELATED_USER_ID

This is the identifier of the owner of the object accessed by the view, and corresponds to a USER_ID in the SYS_USERS_ meta table.

RELATED_OBJECT_NAME

This is the name of the object accessed by the view.

RELATED_OBJECT_TYPE

This identifies the type of object accessed by the view. Views can access stored functions, tables, sequences, other views, Database Link objects, and synonyms. The identifiers are as follows:

• 1: Stored function
• 2: Table, Sequence, View
• 4: Database link
• 5: Synonym

Reference Tables

SYS_USERS_
SYS_TABLES_
SYS_PROCEDURES_

SYS_XA_HEURISTIC_TRANS_

This is a meta table that contains identifiers and information about the status of the database's global transactions.

Column name	Type	Description
FORMAT_ID	BIGINT	The identifier of the format of the global transaction
GLOBAL_TX_ID	VARCHAR(128)	The identifier of the global transaction
BRANCH_QUALIFIER	VARCHAR(128)	The branch qualifier of the global transaction
STATUS	INTEGER	The status of the global transaction
OCCUR_TIME	DATE	The time XA transaction occurred.

Column Information

FORMAT_ID

This is the identifier of the format of the global transaction.

GLOBAL_TX_ID

This is the identifier of the global transaction.

BRANCH_QUALIFIER

This is the branch qualifier of the global transaction.

STATUS

This is the status of the global transaction.

SYS_GEOMETRIES_

This is a meta table that contains information about tables that have GEOMETRY columns.

Column name	Type	Description
USER_ID	INTERGER	The identifier of the user
TABLE_ID	INTERGER	The table identifier
COLUMN_ID	INTERGER	The column identifier
COORD_DIMENSION	INTERGER	The dimension of the GEOMETRY object
SRID	INTERGER	The spatial reference identifier in the database

SYS_GEOMETRY_COLUMNS_

This meta table is used to manage and specify SRID in the GEOMETRY column. The synonym of this meta table is GEOMETRY_COLUMNS_.

Column name	Type	Description
F_TABLE_SCHEMA	VARCHAR(128)	The name of the owner of the table
F_TABLE_NAME	VARCHAR(128)	The name of the table
F_GEOMETRY_COLUMN	VARCHAR(128)	The name of the column
COORD_DIMENSION	INTERGER	The dimension of the GEOMETRY object
SRID	INTERGER	The spatial reference identifier in the database

USER_SRS_

This meta table is used to manage information about SRID and the SRS according to it. The synonym of this meta table is SPATIAL_REF_SYS.

To add SRS meta data to SPATIAL_REF_SYS table and to delete from it, ADD_SPATIAL_REF_SYS and DELETE_SPATIAL_REF_SYS procedures in SYS_SPATIAL package should be used. It is recommended to set SRID and AUTH_SRID's value the same when adding the meta data. For more information, please refer to Spatial Manual.

Column name	Type	Description
SRID	INTEGER	The spatial reference identifier in the database
AUTH_NAME	VARCHAR(256)	The standard name
AUTH_SRID	INTEGER	The standard Spatial Reference Identifier
SRTEXT	VARCHAR(2048)	The description of the Spatial Reference System in OGC-WKT form
PROJ4TEXT	VARCHAR(2048)	The information for used in PROJ4

---

1. SN(Seqence Number): The identification number of the log record ↩