Temporary Tablespaces

Hi,

  A few questions on TEMP tablespaces: ( Oracle 7.3.2.1 )

  (1) The DBA_TABLESPACES has a column called CONTENTS - in our default

      settings it shows PERMANENT for all the tablespaces. It has 2 optins

     PERMANENT & TEMPORARY. Can I change this TYPE from PERMANENT to

     TEMPORARY when the Database is UP & RUNNNING. Do I need to take any

     SPECIAL steps/precautions. Please HELP.

(2) In the ALERT_SID.LOG , I keep seeing the message

    " ORA-01575: timeout waiting for space management resource "

      What should I do ?

(3) Can I add another TEMP tablespace - sounds STUPID but is it
possible?

      In other words can I make Oracle to do sorting in some tablespace

      other than (TEMP - created at installation ) ?

  Please reply by EMail also.

 Thanx.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet