Autoextend failing

[mb]

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.

[Halo]

Is there a Maxsize limitation for the dbf, or have you, say reached the maxextents for the ts??

[goodhealth]

What error did you get? Do you have enough disk space where your datafile(s) are on?

[tompk]

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.

[Kishore]

Either you specified in the tablespace MAXSIZE or your disk is full.

[mb]

How do I determine the max size of the datafile?

[sreddy]

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.

[url]http://www.dbasupport.com/forums/showthread.php?threadid=5209[/url]

[url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=62427.1[/url]

[Edited by sreddy on 01-12-2001 at 09:29 AM]

[mb]

Many Thanks