Version
6.1.1 or below
Explanation
Unable to create a non-prefixed index on a partitioned table using the primary key or unique key.
This error message is output when a user tries to create a primary key or a unique key constraint in the local non-prefixed in
UNIQUE INDEX로 생성할 수 있습니다.
3. 알티베이스를 6.3.1 이상 버전으로 업그레이드 하면 global index로 PK나 UNIQUE INDEX 생성이 가능합니다.
# 예제
iSQL> CREATE TABLE REALSET_CONTENTS
2 (
3 CT_ID VARCHAR (32) NOT NULL,
4
TABLE_SIZE in altibase.propertiesRecreate databaseUpload data to the backup backed up in 2Startup Altibase serverWhen it is possible to change to offlineSecuring service downtimeAltibase server shutdownChange TRANSACTION_TABLE_SIZE in altibase.propertiesStart
tables
$ ls -l *.log|wc -l # Check the number of log files created by running run_il_in.sh
$ cat *.log | grep 'Error Row Count' | awk -F: '{print $2' | wc -l # The number of these results should match the number of the two results above. If it is different, i
CREATE OR REPLACE PROCEDURE ForCursor_TestASBEGINDECLARE CURSOR dept_sum ISSELECT b.dname, COUNT(a.empno) cnt, SUM(a.sal) salaryFROM emp a, dept bWHERE a.deptno = b.deptnoGROUP BY b.dname;– Execute Cursor in the FOR statement.
BEGINFOR emp_list IN dept_
UNIQUEUNIQUE
CLUSTERED, NONCLUSTERED
N/A
FOREIGN KEY REFERENCES
FOREIGN KEY REFERENCES
partition_scheme_name
PARTITION BY RANGE | HASH | LIST
When creating a table, specify the partition table type
4. computed column definition
Not supported
5. table constra
TABLE VIEW
지원
지원하지 않음
SEQUENCE
지원
지원
STORED FUNCTION/PROCEDURE
지원
지원
SYNONYM
지원
지원
TABLE Temporary Table
지원
지원
Temporary Table은 Volatile Table Space 이용
USER
지원
지원
REPLICATION
지원
지원
CREATE T
UNIQUE are specified, only the Tablespace clause, Parallel clause, Logging clause, and Force clause can be specified in the Using Index clause. That is, the index name and CREATE INDEX clause are not provided.
Ref Constraint statement
-
Since the REF column i