Request: External Table DDL

[hbar]

What are the chances we could get "external tables" as a folder item in the browser? Especially with right click access to the *real* ddl, with the file location, delimiters...all that good stuff.

It may have already been suggested, but maybe the motion needed a second in order to be carried (does this forum follow parliamentary procedure?).

 

[rbrooker]

this was requested as early as nov 2003.
hopefully it will make it soon...

 

[hbar]

Well now it's been requested as late as apr 2005.

 

[William Robertson]

Shouldn't be too hard since the access parameters are stored in one big VARCHAR2(4000) in ALL_EXTERNAL_TABLES, and the rest should be in ALL_EXTERNAL_LOCATIONS. The work of a moment I would think.