Posted by Mir Sayeed Hassan on 4th February 2019
How to take the Online Fulldb backup using Backup Script in Oracle 11gR2 Database Status sys@TESTDB> select instance_name,status,version from v$instance; INSTANCE_NAME STATUS VERSION —————- ———— —————– testdb OPEN 11.2.0.4.0 Create the script… Read more..
Posted in DBA Scripts | Comments Off on How to take the Online Fulldb backup using Backup Script in Oracle 11gR2
Posted by Mir Sayeed Hassan on 4th February 2019
Query to delete all Objects from specific user in Oracle database 11gR2 Database Status sys@TESTDB>select instance_name,status,version from V$instance; INSTANCE_NAME STATUS VERSION —————- ———— —————– testdb OPEN 11.2.0.4.0 Connect to specific user “MIR” sys@TESTDB>connect… Read more..
Posted in Oracle SQL | Comments Off on Query to delete all Objects from specific user in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 4th February 2019
How to kill all the Oracle Session for specific user in Oracle Database 11gR2 Database Status: sys@TESTDB> select instance_name,status, version from V$instance; INSTANCE_NAME STATUS VERSION —————- ———— —————– testdb OPEN 11.2.0.4.0 Check the… Read more..
Posted in DBA Administration | Comments Off on How to kill all the Oracle Session for specific user in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on 4th February 2019
How to create directory in Oracle database 11gR2 The directories must be created if any of the external tables are used in database for any operation as example for expdp/impdp etc & this directory should be granted the object privilege as read & write, data dictionary view are all_directories/dba_directories. Database Status: sys@TESTDB>… Read more..
Posted in DBA Administration | Comments Off on How to create directory in Oracle database 11gR2