-
Hi all,
I have my TEMP tablespace created in locally extents, so I ran our of space the TEMP tablespace, what I did was to add another datafile with the intial extent =10m and autoextend with the max is 3000M. The additional file was created so when I look into the data files the auto extend was off.
1. Can someone tell me what happened ???
2. If I won't be able to shrink the TEMP tablesapce????
Thanks
-
dear sir
which version of ORACLE are u using.
If using 9i then no problems
viraj
----------------
9i OCA
A Wise Man Knows How much he doesn't know !!!
-
Can you post you script to add datafile. And also the view you are looking into.
Sanjay
-
Originally posted by ashley75
2. If I won't be able to shrink the TEMP tablesapce????
I don't think it's possible to shrink it.
Create fresh temporary tablespace, set users to have it as their temporary tablespace, offline the old one, drop it, delete files.
That's way I "shrink" the temporary LMT. I don't say it's the only or the best way but it works.
Ales The whole difference between a little boy and an adult man is the price of toys
-
you cannot shrink temp tablespace in 9i
-
ALTER TABLESPACE TEMP ADD TEMPFILE 'd:\oradata\test\temp_01.dbf' SIZE 10240K AUTOEXTEND ON NEXT 25600K MAXSIZE 3072000K
/
We have DBArtisan and I look into the TEMP tablespace and I saw the auto extend was off. It only add 10M to my TEMP.
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
|