Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

How to install SSH on Ubuntu

SSH is nice tool to connect to the server. it encrypts all traffic to eliminate eavesdropping, connection hijacking, and other attacks. I will be giving the steps for installing that on Ubuntu OS Step 1: First check if it is already running ps -ef |grep -i SSH Step 2:  Now install the SSH using the command sudo apt-get install openssh-server -y Here are some issue … Continue reading How to install SSH on Ubuntu »

35 Useful command to help you manage the VPS or Dedicated Server

These are 35 Most Useful command to help you manage the VPS (Virtual Private server) or Dedicated Server. This should help you in daily work on  the server.  I have included command for all major Linux distribution like CentOS ,Ubuntu 1)How to connect to Server using putty Download Putty here a)Provide Hostname or IP address of the VPS or dedicated server b) Choose SSH or telnet … Continue reading 35 Useful command to help you manage the VPS or Dedicated Server »

how to start and stop httpd service

Apache is the HTTP server which is freely available over internet. it is widely used on Linux distribution to host websites.  Apache configuration is managed by the configuration file httpd.conf. You can use locate command to find the configuration  file $ locate httpd.conf /etc/httpd/conf/httpd.conf After making the change , you need to restart the Apache services to make it effective Command for  Linux version 4.x/5.x/6.x … Continue reading how to start and stop httpd service »

How to start and stop mysql on Linux

MySQL is a open source database widely used in Industry. If the MySQL. is hosted on Linux platform,here are the steps to stop and start the MySQL. /etc/init.d/mysqld  status The above gives the status of the mysql service /etc/init.d/mysqld  stop The above gives the stop of the mysql service /etc/init.d/mysqld  start The above gives the start of the mysql service /etc/init.d/mysqld  restart The above gives … Continue reading How to start and stop mysql on Linux »

Useful information about INSERT statement in Oracle

INSERT statement  is a DML ( Data Manipulation Language) command . It is use to insert new rows into the tables Syntax INSERT INTO <table_name> (col1, col2, … column_n ) VALUES (value1, value2, … value_n ); Here table_name: Table where new records need to be inserted col1,col2 : are the column in the tables value1,value2….: are the values corresponding to col1,col2 …in the table Only … Continue reading Useful information about INSERT statement in Oracle »

ORA-01652: unable to extend temp segment: Solutions

We receive this error while inserting data,creating index, table when we don’t have enough space in tablespace. Solution is to add sufficient space in the tablespace identified in the error. There are three ways to do  it Add datafile Resize the existing datafile autoextent the datafile Each one is explained below with example below we  can use ALTER TABLESPACE to add datafile in tablespace like Default Tablespace Syntax … Continue reading ORA-01652: unable to extend temp segment: Solutions »

How to check tablespace in Oracle Database

How to check tablespace in Oracle To list the names and various other of all tablespaces in a database, use the following query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME “TABLESPACE”,   EXTENT_MANAGEMENT,FORCE_LOGGING,BLOCK_SIZE,SEGMENT_SPACE_MANAGEMENT   FROM DBA_TABLESPACES; To list the Datafiles and Associated Tablespaces of a Database To list the names, sizes, and associated tablespaces of a database, enter the following query on the DBA_DATA_FILES view SELECT  FILE_NAME, BLOCKS, … Continue reading How to check tablespace in Oracle Database »

How to Alter Table in Oracle

-You alter or modify  a table using the ALTER TABLE statement. -The table must be contained in your schema To alter a table, or you should either have  ALTER object privilege for the table or the ALTER ANY TABLE system privilege. -If a view, materialized view, trigger,  function-based index, check constraint, function, procedure of package depends on a base table, the alteration of the base table or its columns … Continue reading How to Alter Table in Oracle »

Creating a Global Temporary Table in Oracle

-Oracle allows us  create a temporary table. -The definition of a temporary table is visible to all sessions, but the data in a temporary table is visible only to the session that inserts the data into the table. -We have to use the CREATE GLOBAL TEMPORARY TABLE statement to create a temporary table. -The ON COMMIT clause indicates if the data in the table is transaction-specific (the default) or session-specific DELETE ROWS … Continue reading Creating a Global Temporary Table in Oracle »