How to insert data to EHCC table in Exadata?
For example,
My original table with no compress is 'TE_EVT_AGENT_201105':
SQL> insert /*+parallel(t,4) */ into ODSE.TE_EVT_AGENT_201105 t
2 select * from ODSE.TE_EVT_AGENT_201105@ODSDB1;
6684017 rows created.
SQL> commit;
Commit complete.
SQL> select sum(g.bytes / 1024 / 1024 / 1024) sum,
2 g.segment_name,
3 g.tablespace_name
4 from dba_segments g
5 where g.segment_name = 'TE_EVT_AGENT_201105'
6 group by tablespace_name, segment_name;
SUM SEGMENT_NAME TABLESPACE_NAME
---------------------------------------------------------------------
2.34161376 TE_EVT_AGENT_201105 TS_EVT7_DATA