3 Replies Latest reply: May 25, 2004 4:49 AM by The Human Fly RSS

    ALter tablespace temporary...

    misterimran

      Hi Guys, I am trying to alter one of my temporary tablespace with this command:

      alter temporary tablespace temp
      add datafile 'F:\ORACLE\ORADATA\BSSGLB\TEMPGLB.DBF'
      SIZE 50K AUTOEXTEND ON NEXT 10K MAXSIZE 100K;

      Its giving error :

      ERROR at line 1:
      ORA-00940: invalid ALTER command

      My tablespace is temporary and i haven't offline any tablespace.

      please help, imran baig