Hi,
ODI 12.2.1
I have problem with creating mappings and run ODIAgent with this mapping.
I have connection to postreSQL database and it has table: plot with 30mln records.
I must import this table to oracle on STAGE.
When I created mappings 1:1 and when I running mappings by ODIAgent I get error:
java.lang.OutOfMemoryError: Java heap space
I increased parameters:
product.conf
Add lines:
AddVMOption -Xms140000m
AddVMOption -Xmx250000m
odi.conf
Lines:
AddVMOption -Xms140000m
AddVMOption -Xmx250000m
But i stll get the same error.
When I tried runing mapping by Local (No agent) I get different error:
ORA-01653: unable to extend table .... by 8192 in tablespace ...
But i created three files for tablespace like:
Can someone have suggest to resolve my problem?
I have two question:
1. How to resolve under problem for heap size / tablespace for 30mln records table?
2. How can I create different mapping to import this table to oracle?
TBS_DWH_STG