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 to be 1800 sec SQL> ALTER SYSTEM SET RESUMABLE_TIMEOUT=1800; System … Continue reading Resumable timeout explained
— 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 default tablespace is set for the database it can’t be … Continue reading How to set/find default tablespace in 10g?
