Partition By Reference

[ranro]

1. table B was created with "of object" syntax
2. table A is range partitioned and is referenced by B
3. need to: add partition by reference of B-to-A

is it possible to do?
what would be the syntax?

alter table B add partition by reference (B_to_A_fk);

Thanks
Ranro

[Tim...]

Hi.

if B was not a partitioned table originally, you can't just make it one. You will either have to use exchange partition or use DBMS_REDEFINITION to partition it.

http://www.oracle-base.com/articles/mis ... tition.php
http://www.oracle-base.com/articles/mis ... -table.php

Cheers

Tim...

[ranro]

thanks a lot

[Tim...]