| bookmark review | bottom | top |
temporary tablespace september 03, 2004 reviewer: nazmul hoque from bangladesh
my tablespace list as below : ================================ tablespace initial_extent next_extent min_extents max_extents pct_increase min_extlen status ---------- -------------- ----------- ----------- ----------- ------------ ------------------ system 65536 65536 1 2.147e+09 50 65536 online rbs 524288 524288 8 4096 50 524288 online users 131072 131072 1 4096 0 131072 online temp 65536 65536 1 0 65536 online tools 32768 32768 1 4096 0 32768 online indx 131072 131072 1 4096 0 131072 online drsys 65536 65536 1 2.147e+09 50 65536 online dhaka 40960 40960 1 505 50 0 online ssldata 40960 40960 1 505 50 0 online ================================ normaly we use below command from sql to create a tablespace (path mentioned as per our server location) : create tablespace test datafile 'd:\oracle\oradata\ntserver\data1.dat' size 100m autoextend on next 10m shall i use below for temporary tablespace ========================================== create temporary tablespace temp datafile 'd:\oracle\oradata\ntserver\temp01.dbf' size 100m autoextend on next 5m to drop tabelspace : drop tablespace test; for temporary tablespace: ======================== drop temporary tablespace temp; dear tom, please advise me, i am doing wrong or right. if wrong than please write only two lines to correct me. thanks namzul hoque
| followup: |
create temporary tablespace temp tempfile '.......' ..... ^^^^^^^^ tempfile, not datafile. documentation is very useful for this stuffhttp://download-west.oracle.com/docs/cd/a87860_01/doc/server.817/a85397/statem5e.htm#2063472 (hint, hit the shiftlock key...) |
