Data Archive
- Data Archive 6.4.4
- All Products
SELECT A.table_owner, A.table_name, A.partition_name FROM all_tab_partitions A WHERE table_owner='<table owner>' AND table_name IN ('<table name>') AND partition_name='<partition name>'
Table Owner | Table Name | Table Partition |
---|---|---|
XLA | XLA_AE_HEADERS | CST |
SELECT A.table_owner, A.table_name, A.partition_name FROM all_tab_partitions A WHERE table_owner='XLA' AND table_name IN ('XLA_AE_HEADERS') AND partition_name='CST'
SELECT A.table_owner, A.table_name, A.partition_name FROM all_tab_partitions A WHERE table_owner='<table owner>' AND table_name IN ('<table name>') AND partition_name IN ('<partition name>','<partition name>')
Table Owner | Table Name | Table Partition |
---|---|---|
XLA | XLA_AE_HEADERS | CST |
XLA | XLA_AE_HEADERS | AR |
SELECT A.table_owner, A.table_name, A.partition_name FROM all_tab_partitions A WHERE table_owner='XLA' AND table_name IN ('XLA_AE_HEADERS') AND partition_name IN ('CST','AR')
SELECT A.table_owner, A.table_name, A.partition_name FROM all_tab_partitions A WHERE A.table_owner='<table owner 1>' AND A.table_name IN ('<table name>') AND A.partition_name='<partition name>' UNION SELECT B.table_owner, B.table_name, B.partition_name, 'Y', null, null FROM all_tab_partitions B WHERE B.table_owner='<table owner 2>' AND B.table_name IN ('<table name>') AND B.partition_name='<partition name>' UNION SELECT C.table_owner, C.table_name, C.partition_name, 'Y', null, null FROM all_tab_partitions C WHERE C.table_owner='<table owner 3>' AND C.table_name IN ('<table name>') and C.partition_name='<partition name>'
Table Owner | Table Name | Table Partition |
---|---|---|
XLA | XLA_AE_LINES | CST |
APPLSYS | WF_ITEM_ACTIVITY_STATUSES | WF_ITEM45 |
PA | PA_SUMM_BALANCES | PA_SUMM_BALANCES_PAR11 |
SELECT A.table_owner, A.table_name, A.partition_name FROM all_tab_partitions A WHERE A.table_owner='XLA' AND A.table_name IN ('XLA_AE_LINES') AND A.partition_name='CST' UNION SELECT B.table_owner, B.table_name, B.partition_name, 'Y', null, null FROM all_tab_partitions B WHERE B.table_owner='APPLSYS' AND B.table_name IN ('WF_ITEM_ACTIVITY_STATUSES') AND B.partition_name='WF_ITEM45' UNION SELECT C.table_owner, C.table_name, C.partition_name, 'Y', null, null FROM all_tab_partitions C WHERE C.table_owner='PA' AND C.table_name IN ('PA_SUMM_BALANCES') AND C.partition_name='PA_SUMM_BALANCES_PAR11'