Moving the FACT table records
Before you perform this task, make sure you have full access to the source and the destination databases (you need the database admin privileges).
- Create TNS entries.
- Connect to the source database.
- Move the data:
If a table does not exist, execute the following script:
COPY FROM <source_user_name>/<source_pwd>@<source_tnsname> TO <target_user_name>/<target_pwd>@<target_tnsname> CREATE PR_DATA_IH_FACT USING SELECT * FROM PR_DATA_IH_FACT;If a table exists with the exact same columns:
- Make sure there are no primary key (PK) constraints on the PXFACTID column in the destination database and do not move any constraints.
Execute the following script:
COPY FROM <source_user_name>/<source_pwd>@<source_tnsname> TO <target_user_name>/<target_pwd>@<target_tnsname> INSERT PR_DATA_IH_FACT USING SELECT * FROM PR_DATA_IH_FACT;
Previous topic Applying interaction history scripts in Oracle databases Next topic Merging the dimension records