반응형 ORACLE PARTITION SPLIT1 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 다음 반응형