Narayana Tutorial Blog

Just another Narayana Tutorial site

How to get the Tablespace details in 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 […]

SVN Commands in Linux

This article helps you to understand various SVN commands and its usage in Linux environment.   How To get the location of SVN: $ whereis svn svn: /opt/CollabNet_Subversion/bin/svn (or) $ which svn svn: /opt/CollabNet_Subversion/bin/svn   How to get the SVN help $ svn help usage: svn <subcommand> [options] [args] Subversion command-line client, version 1.8.14. Type […]

Most Useful Git Commands

In this article I am sharing a list of most useful git commands which are used in day to day activity in every project.   Getting & Creating Projects Command Description git init Initialize a local Git repository git clone ssh://[email protected]/[username]/[repository-name].git Create a local copy of a remote repository Basic Snapshotting Command Description git status […]

How to Disable and Enable triggers in 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 […]

ORA-28040: No matching authentication protocol Oracle 12c

ORA-28040: No matching authentication protocol after upgrade to 12c. From oracle 12.X, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. It defines the minimum version of authentication protocol permitted to access the database. Prior to version 12c the default setting for SQLNET.ALLOWED_LOGON_VERSION (the equivalent parameter prior to 12c) was 8. In 12c the default […]

Narayana Tutorial Blog © 2016 Frontier Theme