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... Continue Reading →


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 →

Create a free website or blog at

Up ↑