Does anybody know how to make a temporary
tablespace in Oracle 8.1.6 to permanant using
the command line?
I would have thougt to change it, it would be:
ALTER TABLESPACE <<name>> TEMPORARY;
but this does not work

any help would be greatly appeciated

thanks,
scotta