Category: Database

Start or Stop Oracle XE in Linux

Login to Linux Server as a Root user $sudo su – Root <Start Oracle XE Service> $service oracle-xe start <Stop Oracle XE service> $service oracle-xe stop Ramesh Kunamaneni (RK)Greetings!! This is Ramesh Kunamaneni (RK), I have a decade experience in IT and worked for various MNCs. I am happy to share my knowledge in this […]

How to get the Tablespace details in Oracle

oracle

This article helps you to get more information about Tablespace in Oracle along with a few commands which helps in your day to day activity. How to get the list of available Tablespaces SQL> select tablespace_name, sum(bytes)/power(1024,2), sum(maxbytes)/power(1024,2), AUTOEXTENSIBLE from dba_data_files group by tablespace_name, AUTOEXTENSIBLE; This list down all the tablespaces that are available in […]

How to Disable and Enable triggers in oracle

oracle

In this post, we are discussing on how to enable, disable and drop triggers in oracle.   Enable ONE Trigger in a table Syntax ALTER TRIGGER <trigger-name> ENABLE; Example ALTER TRIGGER NarayanaTutorial_Trigger ENABLE;   Enable ALL Triggers in a table Syntax ALTER TABLE <table-name> ENABLE ALL TRIGGERS; Example ALTER TABLE NarayanaTutorial_TABLE ENABLE ALL TRIGGERS;     Disable […]