Export all tables, triggers, sequences, etc from hosted APEX application.
Hello,
I am sure this has been asked in many variations before, but the answers I keep seeing in the forums offer "alternatives" that are not applicable to what I need to accomplish. While I am a long-time Oracle employee, I am only recently come into APEX development and am encountering some annoyingly "newbie" situations. To wit:
I have created a rather complex application in the internal hosted APEX server. I now wish to take a backup of the all the schema objects related to my application. Most importantly, I wish to backup the data in the tables as I will be performing data manipulations on it prior to importing into the new schema/database.
I have to assume that there is some intelligent way to backup the data in a given application without having to:
a) manually export each table to an Excel or XML file.
b) manually having to write a script todo the same
c) having direct access to the database to use data pump or exp (not possible in hosted environment)
d) copying the application to another schema within the workspace as a substitute for backup.
There HAS to be a way to take an external backup/export of the data and related databasebase objects in APEX 4.0.2.00.07 that does not require the tedious manual methods or direct access to the internal hosted site's DB.
Can anyone suggest the best option to complete this task?