Resumable timeout explained

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…

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…