Oracle Partioning information
SELECT table_name, partitioning_type, ref_ptn_constraint_name FROM user_part_tables WHERE table_name IN ('PROJECT','PROJECT_CUSTOMER','PROJ_CUST_ADDRESS'); SELECT table_name, partition_name, high_value FROM user_tab_partitions WHERE table_name in ('PROJECT','PROJECT_CUSTOMER’) ORDER BY table_name, partition_position; ALTER TABLE project_cust_address DROP PARTITION pd; CREATE TABLE EVENTS( sensor_type VARCHAR2(50), channel VARCHAR2(50), …) PARTITION BY LIST (sensor_type, channel) ( partition p1 values (‘GYRO’,’CH1’), partition p2 values (‘GYRO’,’CH2’), partition p3 values (‘CAMERA’,’CH4’), … partition p44 values ((‘THERMO’,’CH8’), (‘THERMO’,’CH14’)), partition p45 values (DEFAULT) ); CREATE TABLE orders ( order_id number, order_date DATE, … ) ORGANIZATION EXTERNAL ( TYPE oracle_loader DEFAULT DIRECTORY data_dir ACCESS PARAMETERS (..) ) REJECT LIMIT unlimited PARTITION BY RANGE(order_date) ( partition q1_...