Data Archive
- Data Archive 6.5
- 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>' 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>')
Table Owner | Table Name | Partition Name |
---|---|---|
XLA | XLA_AE_HEADERS XLA_AE_LINES | CST |
GL | GL_IMPORT_REFERENCES GL_JE_LINES | (None) |
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')