This content has been marked as final. Show 20 replies
Joe - is this Application Express 2.2? If so, there is the APEXExport utility in the apex/utilities to export all applications from an instance.
Thanks, Joel. It's 2.2.1.00.04.
I know I am being dense but, for the life of me, I just can NOT find this option
Can you please help?
Shutdown database and put source database in RESTRICTED MODE
Export structure and data from existing database. tablespaces
Validate old and new database - checking for discrepancies
Disable foreign keys and triggers in tables owned by all new users
Run data import
Enable foreign keys and triggers
Compile any invalid objects
Modify the DATA_PUMP_DIR to point to new location
Analyze the database
Create data pump export job/initial export
Switch to archivelog mode
Take an RMAN backup
Verify database connectivity
Where you unzipped the Application Express 2.2.1 distribution, there should be a utilities directory.
If you navigate to this directory, you should be able to run this utility. I unzipped this distribution into my /tmp/oracle_temp directory in this example:
[oracle@commander utilities]$ pwdJoel
[oracle@commander utilities]$ java oracle.apex.APEXExport
Usage APEXExport -db -user -password -applicationid -workspaceid -instance -skipExportDate -debug
-db: Database connect url in JDBC format
-user: Database username
-password : Database password
-applicationid : ID for application to be exported
-workspaceid : Workspace ID for which all applications to be exported
-instance : Export all applications
-skipExportDate : Exclude export date from application export files
APEXExport -db candy.us.oracle.com:1521:ORCL -user scott -password tiger -applicationid 31500
APEXExport -db candy.us.oracle.com:1521:ORCL -user scott -password tiger -workspaceid 9999
APEXExport -db candy.us.oracle.com:1521:ORCL -user flows_020200 -password apex -instance
Nevermind, I found it.
Odd that this isn't incorporated into the GUI though. I mean why make folks do something with to command line?
At any rate, I should just be thankful that it can be done.
Thanks Again, Joel.
I was looking on the utilities tab within the web application before. I see it now. Thanks.
command-line = cron
While it would be nice to have something that ships all of this from the Web browser, command-line lets customers use this via other command line utilities.
That's a reason to provide both the GUI and the command line, which is a pretty common approach. It's presense as a command line option shouldn't preclude the ease of having it in the GUI. Why then even have the ability to export at all from the GUI, i.e. at the application level?
Plus, there's the "Give the People What They Want" principle. Eveybody asks for this. Everyone is stumped by it's absense.
BTW, the command line tools worked just fine.
Is there no way to IMport in batch?
Sure there is. It's called a SQL script which invokes your application import files in succession.
I can do that. Until now, I've used the GUI to import the applications.
Can I simply run the sql files that were generated by AppExExport against the target database? Is that all the GUI is doing when I import (other than loading the script I mean)?
I mean is that all there is too it? Just run these sql files against the DB as the apex user?
Joe - You can use this method if your are importing into the same workspace you exported from (identical workspace ID) and the application ID does not need to change.
What user do I need to connect as to execute the SQL? FLOWS_020200 ? APEX_PUBLIC_USER? Or the Schema associated with the workspace?