-
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
J.Scott Adams
-
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][i]Originally posted by scotta [/i]
[B]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
[/B][/QUOTE]
-
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;
J.Scott Adams
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
|