-
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?
goodhealth
-
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.
Thanks
Kishore Kumar
-
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.
[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]
-
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
|