Re: Interview question

> I had an interview with Director of Technology of an internet company. He
> showed me an error message, something like the maximum extents (121) reached
> when insert into a table. He asked me how to solve the problem. My solutions
> were:
> 1). alter tablespace coalease .......

This first answer will not solve the problem. The maximum extents of the has been reached. Coalescing a tablespace will not change the fact that the table has reached maxextents.

> 2). alter table ...change the max_extents to a bigger number.

This answer is the most correct, but it depends on the exact message. If the message was that maxextents has been reached, then this is correct.

> He didn't agree on those. His solution was to alter tablespace add datafile

If the message was that the table could not extend, then this would be the most correct solution.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================