One can make Oracle suspend a session if it runs out a free space by enabling resumable timeout. This can be set by as follows and the value is in seconds: -- Set a session timeout to be 1800 SQL> alter session enable resumable timeout 1800; Session altered. -- Example: Set system wide resuamble timeout … Continue reading Resumable timeout explained
Category: tablespace
How to set/find default tablespace in 10g?
-- Set default tablespace for all users, so when users are created without specifying default tablespace it will be user's default tablespace SQL> ALTER DATABASE DEFAULT TABLESPACE abc; Database altered. -- To find the default tablespace name for the database is SQL> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE'; PROPERTY_VALUE ------------------ ABC Once when … Continue reading How to set/find default tablespace in 10g?
alexlima.com 