-
i created a temporary tablespace without setup autoextent to one.
later on, i
alter database tempfile 'mytempfile' autoextend on ;
i query dba_temp_file.
it tells me increment_by is 1.
what does that mean? why 1?
then i
alter database tempfile 'mytempfile' autoextend on next 10m.
and query dba_temp_files again.
it gives me 1280 for increment_by.
if increment by is the number temp file will extend.
then what will happen if i didn't give the value for next,
how much will oracle extend, 1*8k?
guru is on the way!!!!
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
|