Hi,
I have designed a job to pull the data from Oracle table and load into Teradata table.
As the source table has around 3 millions records, I have used BULK as access method in TD connector which is throwing the below error:
RDBMS code 3621: Cannot load table plan_demand_WT unless secondary indexes and join indexes are removed.
I'm able to load the data if I use immediate as access method which takes longer time for execution.
For analysis, I ran the below query and found no secondary/join index present in the work table
sel * from dbc.indices where databasename='Dev' and tablename='XX';
but there is a partitioned index present on a particular date column!!
Could anyone help me to resolve this issue? Am I getting this error because of petitioned index?
Bulk load into Teradata
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Wed Feb 27, 2013 1:02 am
Bulk load into Teradata
Pratheeksha
-
- Participant
- Posts: 35
- Joined: Mon Nov 15, 2004 9:46 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: