temporary to permanant

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 <> TEMPORARY;
but this does not work

any help would be greatly appeciated

thanks,
scotta

Hi there scotta

You can simply use the command

ALTER TABLESPACE ts_name PERMANENT;

Hope this helps

Alison

Hi,
Can u send me the script which u wrote inorder to create the temporary tablespace.Please send me the entire command for that tablespace at rohitsn@altavista.com

Regards,
Rohit Nirkhe,Oracle DBA,OCP
rohitsn@altavista.com

Quote:

---

Originally posted by scotta
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 <> TEMPORARY;
but this does not work

any help would be greatly appeciated

thanks,
scotta

---

There are Restriction in Changing the TS. It should not have Permanent Objects if Turning to Temp and the Status should be Offline before Changing from Temp to Perm or Vice Versa.

Thanks

here is the script I used in making this tablespace

CREATE TABLESPACE y2001 DATAFILE 'E:\ORANT\DBS\y2001.DBS' SIZE 500M;
GRANT DBA,CONNECT,RESOURCE TO y2001 IDENTIFIED BY y2001;
ALTER USER y2001 DEFAULT TABLESPACE y2001 TEMPORARY TABLESPACE TEMPORARY_DATA;