| Navi |
Posted: Sep 02, 2007 10:32:39 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I created a temporary tablespace "test02".
SQL> create temporary tablespace test02
2 tempfile 'C:\oracle\oradata\Venkat\testdbf2.dbf' size 3m;
Tablespace created.
After that when i am trying to convert from Temporary tablespace to Permanent tablespace i am getting following error:-
SQL> alter tablespace test02 permanent;
alter tablespace test02 permanent
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
Please giude me.
Regards,
Naveen
|
|
|
 Mohammed Taj |
| Posted: Sep 02, 2007 10:51:00 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
YOu can't change.
Regards
Taj
|
|
|
|
|
| Navi |
| Posted: Sep 03, 2007 05:59:01 AM | |
|
Total Post: 60
Joined: Jun, 2007
|
Hi,
I am using 9.0.1 version.
Dictionary Managed Tablespace
SQL> create tablespace testDic
2 datafile 'C:\oracle\oradata\Venkat\t1.dbf' size 2m
3 default storage
4 (
5 initial 200k
6 next 200k
7 pctincrease 0
8 )
9 temporary;
Tablespace created.
SQL> alter tablespace testDic permanent;
Tablespace altered
Locally Managed Tablespace
SQL> create tablespace testLoc
2 datafile 'C:\oracle\oradata\Venkat\t2.dbf' size 2m;
Tablespace created.
SQL> alter tablespace testLoc temporary;
alter tablespace testLoc temporary
*
ERROR at line 1:
ORA-03218: invalid option for CREATE/ALTER TABLESPACE
When searching net i saw the following statement
"You can also change a tablespace from PERMANENT to TEMPORARY or vice versa by using the ALTER TABLESPACE command for any temporary tablespace (either locally managed or dictionary-managed)."
But when i tried this i was able to convert a Dictionary Managed Tablespace which was Temporary to Permanent. But when i tried to convert Locally Managed Tablespace which was Permanent to Temporary i got error.
Please guide me.
Regards,
Naveen
|
|
|
|
|
| nick |
| Posted: Sep 11, 2007 11:49:51 AM | |
|
Total Post: 30
Joined: Sep, 2007
|
i don't think that converting a permanent tablespace to temporary is possible.
|
|
|
|
|
| Mohammed Taj |
| Posted: Sep 11, 2007 12:33:51 PM | |
|
Total Post: 694
Joined: Jul, 2007
|
i don't think that converting a permanent tablespace to temporary is possible.
Yes, it is not possible.
Regards
Mohammed Taj
http://dbataj.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
