Variation in space occupied in same TABLSPACE by equally populated tables.

5 pts.
Tags:
Oracle 10g
Oracle Table
I am inserting data in table T2 from T1(INSERT INTO T2..SELECT..FROM T1..). Both tables are in same tablespace. Even though records in T2 are less than T1,size occupied by T2(12 GB) is much higher than T1(440 MB). WHat may be the reason(s)?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Have you tried to create an empty T2 table based on T1?

create table t2 as select * from t1 where 1 = 2;

If T2 is still of a signficant size, then you need to explore your default table settings.

Devski777

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: