![]() ![]() The APEXExport utility produced regular SQL files, so you don't need a specific tool to import them. split: Split applications into multiple filesĪPEXExport -db localhost:1521:ORCL -user scott -password scotts_password -applicationid 31500ĪPEXExport -db localhost:1521:ORCL -user scott -password scotts_password -workspaceid 9999ĪPEXExport -db localhost:1521:ORCL -user system -password systems_password -instanceĪPEXExport -db localhost:1521:ORCL -user scott -password scotts_password -applicationid 31500 -expComponents PAGE:1 PAGE:2 AUTHORIZATION:12345678ĪPEXExport -db localhost:1521:ORCL -user scott -password scotts_password -workspaceid 9999 -list -changesSince ĪPEXExport -db localhost:1521:ORCL -user scott -password scotts_password -applicationid 31500 -list -changesBy EXAMPLE_USERĪPEXExport -db localhost:1521:ORCL -user system -password systems_password -expWorkspaceĮxport Feedback to development environment:ĪPEXExport -db localhost:1521:ORCL -user scott -password scotts_password -workspaceid 9999 -expFeedbackĮxport Feedback to deployment environment EA2 since 20100308:ĪPEXExport -db localhost:1521:ORCL -user scott -password scotts_password -workspaceid 9999 -expFeedback -deploymentSystem EA2 -expFeedbackSince 20100308 nochecksum: Overwrite existing files even if the contents have not changed All remaining parameters must be of form TYPE:ID expComponents: Export application components. Limit -list values to changes by the given user Limit -list values to changes since the given date changesSince: Expects date parameter (yyyy-mm-dd). list: List all changed applications in the workspace or components in the application dir: Save all files in the given directory, e.g. expACLAssignments: Export ACL User Role Assignments expSupportingObjects: Pass (Y)es, (N)o or (I)nstall to override the default expNoSubscriptions: Do not export references to subscribed components ![]() expOriginalIds: If specified, the application export will emit ids as they were when the application was imported expFeedbackSince: Export team development feedback since date in the format YYYYMMDD deploymentSystem: Deployment system for exported feedback expTeamdevdata: Export team development data for all workspaces or identified by -workspaceid expFeedback: Export team development feedback for all workspaces or identified by -workspaceid to development or deployment expTranslations: Export the translation mappings and all text from the translation repository expIRNotif: Export all interactive report notifications expSavedReports: Export all user saved interactive reports expPubReports: Export all user saved public interactive reports skipExportDate: Exclude export date from application export files expFiles: Export all workspace files identified by -workspaceid expMinimal: Only export workspace definition, users, and groups ![]() expWorkspace: Export workspace identified by -workspaceid or all workspaces if -workspaceid not specified workspaceid: Workspace ID for which all applications to be exported or the workspace to be exported applicationid: ID for application to be exported In this example we will use the "/tmp" directory.Įxport CLASSPATH=$/bin/java -h SECURITYSPY APEX FUSION SOFTWAREPlace the software into a directory of your choice. Run the APEXExport utility to extract the SQL representation of the applications or workspace. Set CLASSPATH=%APEX_BASE%\utilities\ojdbc8.jar %APEX_BASE%\utilities SECURITYSPY APEX FUSION HOW TOSet the environment variables to allow the APEXExport utility to function, and the settings to tell it how to connect to the relevant database to capture the application or workspace of interest. Unzip the APEX software and copy the "ojdbc8.jar" file to the utilities directory. In this example we will use the "C:\temp" directory. WORKSPACE WORKSPACE_ID APPLICATION_ID APPLICATION_NAM The APEX_APPLICATIONS view displays information about the APEX applications.ĬOLUMN workspace_id FORMAT 99999999999999999999 SECURITYSPY APEX FUSION DOWNLOADYou can download ojdbc8.jar, or copy it from an existing product such as SQL Developer. You will need the APEX software and a copy of the "ojdbc8.jar" file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |