Problem while loading Oracle Tables

[Munish]

Hi All,

I am loading target tables in Oracle.
Source is a sequential file.

seqFile >Oracle Enterprise Stage(TargetTable)

I am getting the following error.

Code: Select all

Oracle_Enterprise_0: Indexes on table 'OLB_ADJUSTMENT_FACT' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.

My table does not have any indexes so far.


Thanks and regards,
Munish
[/code]

[DSguru2B]

See if this post helps.

[Munish]

Thanks it worked.

But still unable to load.
This time

Code: Select all

Sequential_File_1,0: Field "ADJUSTMENT_KEY" has import error and no default value; data: {" 0 "}, at offset: 0

Code: Select all

Sequential_File_1,0: Import complete; 0 records imported successfully, 6 rejected.

I have checked the datatypes of source and target, they are in sync.

Am I missing out something here ?

Any comment would be highly appreciated.

Thanks,
Munish

[narasimha]

Check if this helps

An exact search on "has import error and no default value" gave similar posts.

[chulett]

So now you two are some kind of search for hire tag team?

[Munish]

Thanks Guys,
It really worked.

Closing the job.

Thanks and regards,
Munish

[DSguru2B]

Nah...just a friendly reminder for our dsxians that its "all" covered.

[narasimha]

That's a nice team name coined

[Munish]

Hi Champs,
I am using Oracle Load to load my fact table.
Volume: 280 mills per load.

The DB is partitioned by date.
We have 7 bitmap indexes on this table.

The problem starts after the data is loaded and when OCI stage tries to rebuild the indexes and it is failing there.

The error:
ORA-01502: index 'CBA_DBA.XIF1EDX_RPT_SDF_BMAP' or partition of such index is in unusable state

Any Guesses........

[I_Server_Whale]

Hi Champs,
I am using Oracle Load to load my fact table.
Volume: 280 mills per load.

The DB is partitioned by date.
We have 7 bitmap indexes on this table.

The problem starts after the data is loaded and when OCI stage tries to rebuild the indexes and it is failing there.

The error:
ORA-01502: index 'CBA_DBA.XIF1EDX_RPT_SDF_BMAP' or partition of such index is in unusable state

Any Guesses........

My guess is you need to open a new topic rather than appending a new question to an old discussion.

[narasimha]

I agree with Whale.
Contact your DBA's or if you can re-build the index.
Nothing can be done on the datastage side.

[chulett]

Bitmap indexes are notoriously picky and prone to going bad during a load. As people have said, have a chat with your DBAs but I'd bet you'll need to drop them before the load and then rebuild them post load.

[Munish]

Hi All,
I am closing this job and opening a new thread.
Thanks,
Munish