CREATE and DROP TEMPFILE from ORACLE Database

CREATE and DROP TEMPFILE from ORACLE Database
March 21, 2014 | No Comments »

In this section you will find how can we CREATE and DROP tempfiles from ORACLE database

For an example , what we can do if a TEMPFILE was deleted wrongly from the operating system level ?

Check Version Information of Oracle Database

Check Version Information of Oracle Database
March 19, 2014 | No Comments »

We can easly find our ORACLE database version via SAPGui like below ;

SAPGUI –> System –> Status

Oracle Database Backupmode Control

Oracle Database Backupmode Control
March 12, 2014 | No Comments »

We can check our database’s tablespace or datafile status is in BACKUPMODE or Not with the following sql syntax ;

Blogroll