Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OLTP compression: uncompress tables

jhallApr 28 2011 — edited Sep 12 2012
I have read the Oracle whitepaper and the metalink technical note about advanced compression, and neither of these covered the procedure to uncompress OLTP tables after they have been compressed. We are running an SAP system, and there is a canned procedure to uncompress tables, but I think there are better ways to do this.

Anyone who has had experience uncompressing OLTP tables, would you mind sharing your procedure/experience on how you have done this? I have some large tables I will need to uncompress, and want to do this the fastest and most efficient way. Any input is appreciated.

Thanks.
This post has been answered by Hemant K Chitale on Apr 28 2011
Jump to Answer

Comments

DecaXD
HI,

change your varchar2( X BYTE) to varchar2(X CHAR). This is a characterset issue.

Let us know
zoran_2000
Hello,

if you click on the A column in the target pane, you see the mapping implementation in the Property Inspector.
For example TABLE.A change this in RTRIM(TABLE.A,' ')
Rtrim delete extra blank space .
you can use others SQL function.

Let us know
SVAR
Hi,

Thanks for that.It works if i change it to NVARCHAR2,The only thing is, if target database team in case if they are not willing to change the data type, it it anyway can i do this nvarchar2 to varchar2 conversion?
i.e i can load it into temp table which will have NVARCHAR2 Type and then anyway can it conver it to VARCHAR2 when i load using ODI?

I do not not want to Apply TRIM because if we reach max lenth we will fail when the text strings get closer to the 100 Byte(current length of the column) limit in this case.

Any ideas of converting from NVARCHAR2 TO VARCHAR2?

Cheers
DecaXD
Hi,

here a description

2523159

the issue is due that some char occupy more bytes than another. If you are not working on a Worldwide application usually is sufficient to set a correct charset in your loading procedure.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 28 2011
Added on Apr 28 2011
3 comments
35,840 views