Hi all

I'm still studying Oracle, so I could still be considered a beginner, I found that if we were to use data pump in Oracle, there's a "query" option, which if we add "order by" to it, the data will be sorted according to the referred column

I also found that the regular export (exp) and redefinition also share the similar function. Is there any defragmentation method which will automatically result a sorted table ?