Database DataWarehousing (MOSC)

MOSC Banner

dbms_tabcomp_temp_uncmp and cmp tables in user's schema's 11.2.0.1

edited Aug 13, 2012 6:14PM in Database DataWarehousing (MOSC) 5 commentsAnswered
 Automated job 'Segment Advisor' creating and dropping dbms_tabcomp_temp_uncmp and cmp tables in user's schema's 11.2.0.1. Apparently it is doing the following,
Step 1 : create a temp table dbms_tabcomp_temp_uncmp  as select  *From from real_table1;
Step 2:  create a temp table dbms_tabcomp_temp_cmp
            organization heap
            compress for query high
            as select  * from dbms_tabcomp_temp_uncmp  ;

Step 3:  drop table dbms_ tabcomp_temp_uncmp;
Step 4:  drop table dbms_tabcomp_temp_cmp ;

Is this something expected ?
If so, does it do this for all the tables in the database ? IS there any worry about table spaces being filled up ?

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