DSXchange

who can help me for this case?

When I was used ee job in oracle enterprise or se job in oci stage, tried to use the user-defined sql " insert / * + append * / into...", can not play the effect of compressed form, as shown below: Table has been compressed SQL>select table_name,compression from user_table where table_name...

Hello,
I'd like to know what is the best way to load data into a Oracle Compressed Table.
if a Oracle table is compressed,then i can use "insert /*+append*/... " to compress data,but when i use it by used-defined sql in oracle enterprise stage,it's not effect,who can tell me the reason?TKS

This issue happened for Information Server v8.1 on Red Hat Linux 4. Code: Sequential file -----------------------> Oracle_OCI The job is very simple. But when Oracle OCI Stage was used as target,the job just abort with warning. warning:Abnormal termination of stage test1..Oracle_OCI_0.IDENT1 detecte...