Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter tablspace TEMP add datafile

happy10319Apr 26 2007 — edited Apr 26 2007

Hi,
I'm in 8i on WinXP
I try to add a file to temporary tablespace TEMP :

SQL> alter tablspace TEMP add datafile 'C:\ORACLE\ORADATA\REPRMAN\TEMP01.dbf' SIZE 20M;
alter tablspace TEMP add datafile 'C:\ORACLE\ORADATA\REPRMAN\TEMP01.dbf' SIZE 20M
*
ORA-00940: Commande ALTER non valide
How should I do ?
Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2007

Added on Apr 26 2007

#general-database-discussions

24 comments

1,521 views