This content has been marked as final. Show 20 replies
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
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.
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?