Home » SQL & PL/SQL » SQL & PL/SQL » How to set/change the maximum size of an existing table?
How to set/change the maximum size of an existing table? [message #254055] Wed, 25 July 2007 11:46 Go to next message
biz_me
Messages: 8
Registered: July 2007
Location: singapore
Junior Member
Hi,
i have create a table 'employee' into the database. I like to set the employee to a max size of 3M.
What do i type in sql plus?

Is it using Alter table employee....

Thanks for your help...
Re: How to set/change the maximum size of an existing table? [message #254059 is a reply to message #254055] Wed, 25 July 2007 12:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Afaik, there is no max size for a table (above all if you use locally managed tablespace) but you can set a maximum quota for its owner on the tablespace containing the table.

Regards
Michel
Re: How to set/change the maximum size of an existing table? [message #254070 is a reply to message #254055] Wed, 25 July 2007 12:25 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>3M
3M what? rows, bytes, etc?
What do you expect should happen when the limit is reached?
You could always create a trigger on INSERT or UPDATE & handle this any way you desire.
Re: How to set/change the maximum size of an existing table? [message #254145 is a reply to message #254070] Wed, 25 July 2007 22:07 Go to previous messageGo to next message
biz_me
Messages: 8
Registered: July 2007
Location: singapore
Junior Member
3M i refer to 3MB.
thanks
Re: How to set/change the maximum size of an existing table? [message #254147 is a reply to message #254059] Wed, 25 July 2007 22:17 Go to previous message
biz_me
Messages: 8
Registered: July 2007
Location: singapore
Junior Member
oh ok.. thaanks for your advice..
i will try it again
Previous Topic: Bulk delete
Next Topic: How to set the the user so that he cant access other tablespace?
Goto Forum:
  


Current Time: Fri Dec 02 20:49:20 CST 2016

Total time taken to generate the page: 0.15506 seconds