[Tibero] Partition table

Partition table TEST -테스트 유저 생성 create user test identified by 'tibero' default tablespace test0; grant dba, connect, resource to test; CREATE TABLESPACE test01 DATAFILE '/dev/tibero_vg/rhd512_01' SIZE 100M AUTOEXTEND OFF; CREATE TABLESPACE test02 DATAFILE '/dev/tibero_vg/rhd512_02' SIZE 100M AUTOEXTEND OFF; CREATE TABLESPACE test03 DATAFILE '/dev/tibero_vg/rhd512_03' SIZE 100M AUTOEXTEND OFF; C..

  • format_list_bulleted Database/TEST Script
  • · 2023. 3. 1.
  • textsms

OBJECT 생성 TEST 구문

CONN SYS/TIBERO DROP USER USER1 CASCADE; DROP USER USER2 CASCADE; CREATE USER USER1 IDENTIFIED BY TIBERO ; CREATE USER USER2 IDENTIFIED BY TIBERO ; GRANT CONNECT, RESOURCE, CREATE VIEW TO USER1 ; GRANT CONNECT, RESOURCE, CREATE VIEW TO USER2 ; CONN USER1/TIBERO CREATE TABLE T_TEST1 ( C1 NUMBER , C2 VARCHAR(10) ); CREATE TABLE T_TEST2 ( C1 NUMBER , C2 VARCHAR(10) ); TRUNCATE TABLE T_TEST1; INSERT..

  • format_list_bulleted Database/TEST Script
  • · 2022. 11. 17.
  • textsms