create table customers
(
   cust_id   number primary key,
   cust_name varchar2(200),
   rating    varchar2(1) not null
)
partition by list (rating)
(
   partition pA values ('A'),
   partition pB values ('B')

);

create table sales
(
   sales_id    number primary key,
   cust_id     number not null,
   sales_amt   number,
   constraint  fk_sales_01
    foreign key (cust_id)
    references customers
)
partition by reference (fk_sales_01);

insert into customers values (1,'John','A');

insert into sales values (11,1,200);

create table sales
(
   sales_id    number primary key,
   cust_id     number not null,
   sales_amt   number,
   constraint  fk_sales_01
    foreign key (cust_id)
    references customers
)

 create table customers
(
   cust_id   number primary key,
   cust_name varchar2(200),
   rating    varchar2(1) not null,
   start_date        DATE not null
     )
  PARTITION BY RANGE (start_date) 
 (  
    PARTITION pos_data_p0 VALUES LESS THAN (TO_DATE('1-7-2007', 'DD-MM-YYYY')),
    PARTITION pos_data_p1 VALUES LESS THAN (TO_DATE('1-8-2007', 'DD-MM-YYYY'))
 ); 
 
 create table sales
(
   sales_id    number primary key,
   cust_id     number not null,
   sales_amt   number,
   constraint  fk_sales_01
    foreign key (cust_id)
    references customers
 )
partition by reference (fk_sales_01);


alter table customers set INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'));

SQL> create table customers
  2  (
  3     cust_id   number primary key,
  4     cust_name varchar2(200),
  5     rating    varchar2(1) not null,
  6     start_date        DATE not null
  7       )
  8    PARTITION BY RANGE (start_date)
  9   (
 10      PARTITION pos_data_p0 VALUES LESS THAN (TO_DATE('1-7-2007', 'DD-MM-YYYY')),
 11      PARTITION pos_data_p1 VALUES LESS THAN (TO_DATE('1-8-2007', 'DD-MM-YYYY'))
 12   );

Table created.

SQL>
SQL>  create table sales
  2  (
  3     sales_id    number primary key,
  4     cust_id     number not null,
  5     sales_amt   number,
  6     constraint  fk_sales_01
  7      foreign key (cust_id)
  8      references customers
  9   )
 10  partition by reference (fk_sales_01);

Table created.

SQL>
SQL>
SQL> alter table customers set INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'));

Table altered.

SQL>

 create table customers
(
   cust_id   number primary key,
   cust_name varchar2(200),
   rating    varchar2(1) not null,
   start_date        DATE not null
     )
  PARTITION BY RANGE (start_date) 
 (  
    PARTITION pos_data_p0 VALUES LESS THAN (TO_DATE('1-7-2007', 'DD-MM-YYYY')),
    PARTITION pos_data_p1 VALUES LESS THAN (TO_DATE('1-8-2007', 'DD-MM-YYYY'))
 ); 

alter table customers set INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'));

SQL> create table customers
  2  (
  3     cust_id   number primary key,
  4     cust_name varchar2(200),
  5     rating    varchar2(1) not null
  6  )
  7  partition by list (rating)
  8  (
  9     partition pA values ('A'),
 10     partition pB values ('B')
 11  
 12  );

Table created.

SQL> 
SQL> create table sales
  2  (
  3     sales_id    number primary key,
  4     cust_id     number not null,
  5     sales_amt   number,
  6     constraint  fk_sales_01
  7      foreign key (cust_id)
  8      references customers
  9  )
 10  partition by reference (fk_sales_01);

Table created.

SQL> 
SQL> select  a.owner child_table_owner,
  2          a.table_name child_table_name,
  3          c.owner parent_table_owner,
  4          c.table_name parent_table_name
  5    from  dba_part_tables a,
  6          dba_constraints b,
  7          dba_constraints c
  8    where a.owner = 'SCOTT'
  9      and b.table_name = 'SALES'
 10      and b.owner = a.owner
 11      and b.constraint_name = a.ref_ptn_constraint_name
 12      and c.owner = b.r_owner
 13      and c.constraint_name = b.r_constraint_name
 14  /

CHILD_TABL CHILD_TABL PARENT_TAB PARENT_TAB
---------- ---------- ---------- ----------
SCOTT      SALES      SCOTT      CUSTOMERS

SQL>