Schedule shell script for tablespace report in oracle database

March 5, 2014 by Sajid Quamer

In this article we will explain ‘how to generate Tablespace reprot’ in oracle database and automate alert on mail using mailx. To pull out tablespace report in oracle database . We will prepare the shell script as below and schedule it using crontab.Step 1:-copy the below scripts in shell scripts as tablespacerpt.sh and grant the … Read more

How to manage Temporary Table space in Oracle Database

February 26, 2014 by Sajid Quamer

Temporary tablespace are providing temporary space for database sort operations and for storing global temporary tables. To Create user with default tablespace and temporary tablespace.SQL> CREATE USER scott DEFAULT TABLESPACE data TEMPORARY TABLESPACE temp;SQL> ALTER USER scott TEMPORARY TABLESPACE … Read more