EXPORT of SYS.EXA_DBA_DEPENDENCIES_RECURSIVE fails
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5131 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, EXASOL 6.0.3 |
| Fix Versions | EXASOL 6.0.4 |
| Resolution Date | 2017-09-29 |
Problem
The query
EXPORT SYS."EXA_DBA_DEPENDENCIES_RECURSIVE" INTO LOCAL CSV FILE 'filename';
with following error message:
[0A000] Feature not supported: CONNECT BY on non materialized table
Workaround
Put the table in a subselect:
EXPORT (select * from SYS."EXA_DBA_DEPENDENCIES_RECURSIVE") INTO LOCAL CSV FILE 'filename';
