Exadata General (MOSC)

MOSC Banner

How to insert data to EHCC table in Exadata?

edited Jun 13, 2013 5:55PM in Exadata General (MOSC) 8 commentsAnswered
I want to insert data from original table to EHCC table, but after inserting, I found the EHCC table did not compress the data.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center