반응형 ORACLE PARTITION2 Oracle Partition TABLE 기본 구성 #Oracle Partition Table 기본구성 #테이블 스페이스 생성 CREATE TABLESPACE TEST DATAFILE '+ASM' SIZE 1G AUTOEXTEND ON; #유저생성 CREATE USER PCW IDENTIFIED BY 'oracle1' DEFAULT TABLESPACE TABLESPACE TEMP; #권한부여 ALTER USER PCW DEFAULT TABLESPACE TEST QUOTA UNLIMITED ON TEST; GRANT CREATE SESSION TO PCW; GRANT CONNECT , RESOURCE TO PCW; #RANGE PARTITION TABLE 생성 CREATE TABLE PCW.ORDERS_PT (ORDER_ID NUMBER, ORDER_DAT.. 2022. 2. 16. Oracle Partition Table SPLIT (파티션 스플릿) Oracle Partition Table SPLIT (파티션 스플릿) #Partition Table 기본 생성 #Partition Range CREATE TABLE PCW.ORDERS_PARTITION (ORDER_ID NUMBER, ORDER_DATE DATE, ORDER_MODE VARCHAR2(10), CUSTOMER_ID VARCHAR2(10), EMPLOYEE_ID VARCHAR2(10), ORDER_STATUS NUMBER, ORDER_TOTAL NUMBER) PARTITION BY RANGE(ORDER_DATE) ( PARTITION PCW_201701 VALUES LESS THAN(TO_DATE('20170201', 'YYYYMMDD'))TABLESPACE USERS_DATA, PARTIT.. 2021. 12. 17. 이전 1 다음 반응형