Migrating Oracle Data Objects

Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server includes a set of SQL scripts that create Oracle tables and other data objects in your testing, staging, or production environment. After creating the data objects, you can use Oracle commands to export data from the source environment and import it into a destination environment.

The Oracle commands export and import all Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server data including any document metadata that is part of the default content management implementation. The commands do not move the following:

To export Oracle data objects to a destination environment, complete the following tasks:

Step 1: Create the Destination Environment

For more information about Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server database schemas, refer to the following documents:

Step 2: Review Parameter Files

Complete this step only if you use a third-party solution (such as Interwoven or Documentum) for content management.

If your Oracle user account contains data objects that Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server does not create and maintain (such as Interwoven and Documentum objects), you must use parameter files to establish user identity and determine the tables for which you want to export and import data.

Reviewing the parameter files involves the following tasks:

Review the List of Tables

Complete this procedure only if you use a third-party solution (such as Interwoven or Documentum) for content management.

Note: In this document, WL_COMMERCE_HOME refers to the directory into which you installed WebLogic Commerce Server and/or WebLogic Personalization Server.

Review the list of tables in the parameter files and, if necessary, modify them to match your environment:

Note: If you are using the reference implementation (BulkLoader) for content management, you must leave these table names in the files.

Add FROMUSER to the Import Parameter File

Complete this procedure only if you use a third-party solution (such as Interwoven or Documentum) for content management.

To specify the user account that owns the schema you want to import, do the following:

Step 4: Delete Sample Data (Optional)

Caution: Before you delete sample data, back up your database.

If you loaded sample data and you do not plan to it in the destination environment, we recommend that you delete it before you export data. Do not delete the administrator users or administrator group.

Your database might contain samples for the following types of data:

You can use the Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server Administration Tool to delete sample data. To access the Administration Tool, start the server and enter the following URL in a Web browser:
http://localhost:7501/tools/index.jsp

For example, to delete sample users from the Administration Tool:

Step 5: Remove Orphaned Records

Note: In this document, WL_COMMERCE_HOME refers to the directory into which you installed WebLogic Commerce Server and/or WebLogic Personalization Server.

To verify that there are no orphaned records in your database, do the following:

Step 6: Export the Data

To export data, complete one of the following tasks:

Export All Tables in the User Account

If you are using the reference implementation for content management and the Oracle user account in the destination environment contains only Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server data objects, do the following to export data:

Note: You can use a username and password for any account with DBA privileges. ORACLE_SID must specify the database in which the Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server schema resides. If you changed the WEBLOGIC user account name, change the value for owner.

When the exp command finishes exporting data, it prints the following message:
Export terminated successfully without warnings

Export Specific Tables from the User Account

Complete this procedure only if you use a third-party solution (such as Interwoven or Documentum) for content management.

If your Oracle accounts contain data objects that Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server does not create and maintain (such as Interwoven and Documentum objects), do the following to export data:

Note: You can use a username and password for any account with DBA privileges. ORACLE_SID must specify the database in which the Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server schema resides. If you changed the WEBLOGIC user account name, change the value for owner.

When the exp command finishes exporting data, it prints the following message:
Export terminated successfully without warnings

Step 7: Stop the Server in the
Destination Environment

Before importing data, you must stop Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server by entering Ctrl+C in the shell that is running the server.

Step 8: Import the Data

Caution: Before you import data, back up your database in the destination environment.

To import data, complete one of the following tasks:

Import to All Tables in the User Account

If the Oracle user account in the destination environment contains only Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server data objects, do the following to import data:

Note: You can use a username and password for any account with DBA privileges. ORACLE_SID must specify the database in which the Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server schema resides. If you changed the WEBLOGIC user account name, change the value for fromuser and touser.

Import to Specific Tables in the User Account

Complete this procedure only if you use a third-party solution (such as Interwoven or Documentum) for content management.

If your Oracle accounts contain data objects that Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server does not create and maintain (such as Interwoven and Documentum objects), do the following to import data:

Note: You can use a username and password for any account with DBA privileges. ORACLE_SID must specify the database in which the Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server schema resides.

Step 9: Start the Server in the
Destination Environment

To start WebLogic Commerce Server and/or WebLogic Personalization Server on UNIX, enter the following command from a Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server host:
WL_COMMERCE_HOME/StartCommerce.sh

To start WebLogic Commerce Server and/or WebLogic Personalization Server on Windows, on a Campaign Manager for WebLogic, WebLogic Commerce Server, and WebLogic Personalization Server host, do one of the following: