Enterprise Data Manager Guide

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Select Clause for Partitioned and Non-Partitioned Source Tables

If the interim tables include a combination of partitioned tables and non-partitioned tables, the archive job uses a union of the ALL_TAB_PARTITIONS and ALL_TABLES Oracle views to populate the interim table values.

Use the following syntax to form the select clause for the partition name:

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>' 
UNION 
SELECT B.owner, B.table_name,null,'Y',null,null 
FROM all_tables B 
WHERE B.owner='<table owner>' AND B.table_name IN ('<table name>')

For example, you want to add the following values in the interim table:

Table Owner	Table Name	Partition Name
XLA	XLA_AE_HEADERS XLA_AE_LINES	CST
GL	GL_IMPORT_REFERENCES GL_JE_LINES	(None)

Use the following syntax:

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','XLA_AE_LINES') AND partition_name='CST' 
UNION 
SELECT B.owner, B.table_name,null,'Y',null,null 
FROM all_tables B 
WHERE B.owner='GL' AND B.table_name IN ('GL_IMPORT_REFERENCES','GL_JE_LINES')

Rename Saved Search

Table of Contents

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Select Clause for Partitioned and Non-Partitioned Source Tables

Select Clause for Partitioned and Non-Partitioned Source Tables