No David, it's not the questions, it is the...

oh boy 😀

1- the statement that reads "only managers can manage a department" does not holds true in the real world. In the real world you are going to...

Welcome to the Oracle world... there is not such a thing as Temp DB in Oracle but we do have Temp tablespaces sitting on the same Oracle instance.

In regards to...

oh yes! very interesting indeed.

I found the article as interesting as the theory that Grand Cannyon was an alien mining operation is 😀 which everybody knows is true,...

David Portas (1/20/2010)

What is...

Too litle and vague information to support any serious advise.

What does your DBA says about it?

David Portas (1/20/2010)

Why?

It is true that such...

ORA-01652 does not signals timeout but the inability to extend a temporary segment a.k.a. tablespace full 🙂

Oracle error stack is certainly pointing to affected tablespace, it could be either...

Question is... which recovery model is in place?

Is it Full or Bulk-logged?... in the affirmative case Lynn's suggestion e.g. taking a tail-log backup - would...

Yes, cast() it.

May I ask what is the rationale behind such a consolidation project?

The most active/queried to-be-consolidated table represents less than 10% of total data volume... why would somebody add to this...

A dimension table should describe a single attribute in a fact table - is this the case?

Two thoughts...

1) A design that ends up with two or more tables having a 1-1 relationship most of the time means something is wrong.

2) No physical design should include n-n...

This is home work, isn't it? - nothing wrong about that.

If you really want to get a grasp of it do this...

Entity-Relationships

- Identify your entities - draw it!

- Identify...

I would start by gathering fresh performance statistics on affected tables and indexes ... it is not unseen that new RDBMS engines does not like performance stats gathered with previous...