Home » RDBMS Server » Server Administration » how to set maxsize for datafile/tablespace
how to set maxsize for datafile/tablespace [message #61722] Thu, 20 May 2004 12:17 Go to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
using 8i, trying to set max file size for datafile for users tablespace, check the box, click apply, this does stay/stick, it reverts back to initial size, have on the priveliges and roles etc etc
Re: how to set maxsize for datafile/tablespace [message #61723 is a reply to message #61722] Thu, 20 May 2004 13:29 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You don't say what tool you are using. See if you can get the DDL from whatever tool you are using, and run that statement to see if it reports an error.
Re: how to set maxsize for datafile/tablespace [message #61728 is a reply to message #61722] Fri, 21 May 2004 02:34 Go to previous message
prashant
Messages: 122
Registered: September 2000
Senior Member
are you using size clause in the datafile , check in yours tools whether it asks for size of the datafile.
Thanks,
Prashant.
Previous Topic: error in renaming the datafile
Next Topic: rollback segment in 9i
Goto Forum:
  


Current Time: Wed Sep 24 16:31:24 CDT 2025