Can anyone tell me what causes autoextend to fail if it cant allocate another extent. It seems pointless having autoextend on if it doesnt really work.
Printable View
Can anyone tell me what causes autoextend to fail if it cant allocate another extent. It seems pointless having autoextend on if it doesnt really work.
Is there a Maxsize limitation for the dbf, or have you, say reached the maxextents for the ts??
What error did you get? Do you have enough disk space where your datafile(s) are on?
How much is the free space available ( look dba_free_space )
If free space is less , you will have to add a datafile or use larger datafiles.
Either you specified in the tablespace MAXSIZE or your disk is full.
How do I determine the max size of the datafile?
there is 10 days ago posting here which talks about the all OS and their Datafiles size limits. Let me find it and post it.
http://www.dbasupport.com/forums/sho...?threadid=5209
http://metalink.oracle.com/metalink/...T&p_id=62427.1
[Edited by sreddy on 01-12-2001 at 09:29 AM]
Many Thanks