trying to get view ddl using python
Posted: Tue Apr 28, 2015 10:05 pm
We have a need to get the ddl for a view using python. However it comes back empty using select export_objects() since the view is apparently too large for the buffer. Thought about chunking thru the ddl using substr sections but cannot use substr on the meta function export_objects. Then thought perhaps use v_internal.vs_views the view_definition but it is truncated at 8192 bytes. Some where underlying the complete ddl is stored. Is there anyway to output that using an sql query that gets around the problems using export_objects()?