| Change System Tables... [message #55364] |
Mon, 20 January 2003 23:00  |
Eric Rodriguez
Messages: 5
Registered: January 2003
|
Junior Member |
|
|
I need to create a web interface to allow for external manipulation of tablespace parameters, namely: autoextend, and size. Is there anything wrong with changing the parameters like this? I currently read the parameters out of the DB with JSP, and would use JSP to update the tables.
- Thanks...
|
|
|
|
| Re: Change System Tables... [message #55365 is a reply to message #55364] |
Tue, 21 January 2003 03:51  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
you have to issue alter tablespace command from your application.
YOU CANNOT DIRECTLY CHANGE THE ENTRIES in system tables.
If your database is in production mode,
Make sure u take extreme caution in doing any thing with reference to tablesapces.
A few options may require to bring the tablespace offline or NO TRANSACTIONS USING IT.
CONSIDER ALL THESE IN YOUR APP.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
