Uncompress a table

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pkomalla
Premium Member
Premium Member
Posts: 44
Joined: Tue Mar 21, 2006 6:18 pm

Uncompress a table

Post by pkomalla »

Hi All,

Can anyone tell me the format to uncompress a oracle table
in a sql query.

thanks
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post by kcbland »

What do you mean by uncompress? I have never heard of this with respect to Oracle.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Top
sb_akarmarkar
Participant
Posts: 232
Joined: Fri Sep 30, 2005 4:52 am
Contact:
Contact sb_akarmarkar

Post by sb_akarmarkar »

ALTER TABLE TABLENAME MOVE NOCOMPRESS;

Thanks
Anupam
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”