Configuring Data Ship for Oracle
Data ship makes use of explain plans. If your Oracle database does not already have plan tables designated to hold that data, then for data ship to work, you must create them.
To configure data ship for Oracle
1. As a user with DBA rights for your Oracle databases involved with data ship, open your favorite tool to use to create tables.
2. Create one or more tables to hold explain plan data.
3. Make sure that the TDV users that are designing your data ship sources and targets has the following privileges:
— create plan tables
— execute explain plans
If this error occurs, permissions might still need adjusting:
An internal error has occurred.Cause: For input string: ""
If data is being moved between Oracle instances, performance is significantly better when database links are used instead of JDBC. Using Oracle database links allows the Oracle instance to take advantage of the proprietary channels for transferring large data tables from one Oracle instance to another.
The following steps are optional, but recommended.
To use database links for the data ship
1. Grant the TDV-Oracle database user privilege to execute the following query:
SELECT * FROM dba_db_links;
2. Create a database link in the Oracle client using syntax similar to the following on the Oracle instance:
CREATE DATABASE LINK oral2_dblink connect to devdata identified by password using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <host_name>)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <service_name>) ))';
3. Verify a connection with the new database, oral2_dblink, by executing a query like the following:
SELECT * FROM dual@oral2_dblink