We're going to have a window where you can go from 21c to 23c instance - you will not lose your DB. Stay tuned for an update from the Cloud team. Tom Lieber

For your apex instance, you can run a plsql block of code to run a data pump export job, from say Database Actions SQL worksheet. You can download the dmp files from the Data Pump page.

Thanks Sandra! It's fun when the customer who spends the most $$$ wants a 20% use case feature :)

5 or 6 steps, either way, it's quick :)

Great question, complicated answer. I taught a 90 minute class on the subject earlier this year. A 'version' of that lecture I did previously and had recorded is here, plus slides: https://www.thatjeffsmith.com/archive/2020/09/dba-masterclass-week-1-data-modeling/ I suggest also looking at this book if you want to use our free Oracle tool to build a model https://www.amazon.com/Oracle-Developer-Modeler-Database-Mastery/dp/0071850090 Karen Lopez has some great posts on data modeling in general, esp on things to avoid. Follow her on twitter @datachick

When paginating the results of a query in Oracle REST APIs...we don't actually do that. We take the query...and rewrite it to have the 'page' returned as a singular resultset. So each time the user/app follows the link for the next or previous page, the query is executed again. So instead of SELECT * FROM my_table We run SELECT * FROM ( SELECT Q_.*, ROW_NUMBER() OVER ( ORDER BY 1 ) RN___ FROM ( SELECT * FROM my_table ) Q_ ) WHERE RN___ BETWEEN : 1 AND : 2 The API dev can of course override this and build their own logic, or even disable paging...