-
9i DB - temp ts - invalid option
hi
I am trying to add a datafile to temp tablespace for 100MB it gives me this error
what would be the reason
SQL> ALTER TABLESPACE TEMP ADD DATAFILE '/u01/app/oracle/oradata/HNS/temp02.dbf' size 100m;
ALTER TABLESPACE TEMP ADD DATAFILE '/u01/app/oracle/oradata/HNS/temp02.dbf' size 100m
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
Gajanan
-
add TEMPFILE and not DATAFILE
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|