Print Thread
USER DEFINED FOLDER
#65568 03/23/24 02:12 PM
Joined: Sep 2022
Posts: 3
S
Member
OP Offline
Member
S
Joined: Sep 2022
Posts: 3
I've defined my own folder in the Browser - a list of tables - but - is it possible to order these by size (extents)? If I understand the documentation correctly, then ordering can only be done on columns in the all_objects view .....

Re: USER DEFINED FOLDER
Stephen Young #65573 03/25/24 10:07 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
You can indeed only use columns from the all_objects view in your folder. You can however create a stored function that returns the table size based on the table owner and name, an use that function in the order by clause of your folder.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.021s Queries: 15 (0.007s) Memory: 2.4960 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-04-27 09:06:23 UTC
Valid HTML 5 and Valid CSS