alter table <table name> move compress in oracle 9i
587854Aug 1 2007 — edited Aug 2 2007Hi
Im having a table which is around 25GB size, I want to compress the table, While issuing alter table move compress the table size reduced nearly 40% of the total size. After that i took the export of the table and imported in the DR database, the size of the table remains same which is the actual size before compress i.e. 25GB.
Can anyone please assist me how to keep the compressed size of the table in DR also?