ALTER TABLESPACE

Merry Christmas to all -

My outfit has recently won the contract to support a customer's Oracle database. They then turned around and pointed to ME and said, "Oh, by the way, you're the new DBA."

We didn't design, build, or populate this database. I'm still discovering unpopulated tables that appear to be legacies from the database' original application.

Now it appears that heavy user activity has increased the size of the tables beyond original expectations. Queries do not run and error messages to the effect that TEMP TABLESPACE cannot ?extend? are returned. It appears I need to increase the TEMP TABLESPACE.

My informal contact with the previous custodians of this database says, "We just did an ALTER TABLESPACE and gave it a new file name." My cursory review of the tech manuals indicate that the problem may be more involved than that.

My confidence level is low. Can someone please list the actions the well-read DBA would take to increase TEMP TABLESPACE? Or better yet, would the group cite the manual/chapter in the shelves of Oracle documentation that will give me the background and walk me through this process?

Oracle 7.1.6.2 on DEC Alpha 2000 4/200 running DEC/OSF1.

I truly appreciate any assistance. E-mail response preferred, I will summarize and repost to the group.

Gus

gus@ Received on Fri Dec 20 1996 - 00:00:00 CST