Export User Objects follows user preferences

[Stew Stryker]

I'm using Export User Objects to extract objects such as materialized views, tables and views.

I've chosen for it to extract as a File per Object. I'd like the file extensions for these to all be .sql, as I have my preferences set. But the extensions end up as .mv, .tab and .vw respectively.

I've checked my setting for Preferences->Files->Extensions, and the setting for Other in the Program Files, SQL Scripts and Command files sections are set to sql. I played with this setting for functions and that used my preferred extension.

Am I missing something here?

Thanks,

 

[Marco Kalter]

For tables, views and materialized views the extension is indeed hard-coded as described. You can only define the extension for the object types available in the preferences.

 

[Stew Stryker]

My mistake. I figured these would fall into the catch-all "Others" extention option under either the Program Files or the SQL Scripts sections in Preferences.

Could you please add this to the (undoubtedly long) list of enhancement requests?

Thanks,

 

[Marco Kalter]

Okay, I have added this to the list of enhancement requests.