Oracle allows you rename existing columns in a table. Use the RENAME COLUMN clause of the ALTER TABLE statement to rename a column i,e alter table rename column in oracle Syntax ALTER TABLE table_name RENAME COLUMN old_name to new_name; Lets see this example SQL> CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL, […]
27 oracle dba scripts for Oracle Database for Administration and Monitoring
We often need to monitor the oracle database session for performance reason, check for locks,get location of datafiles, redo files , get the information about db_links .Here are Top oracle dba scripts for Oracle Database for Administrative and Monitoring purpose Script to find the sid of the session you are logged in as select distinct(sid) […]
How to rebuild the table in oracle using alter table move
Today in this post, I will explain how to rebuild the oracle tables or move the different type of oracle tables using alter table move command. we may want to rebuild the table for various reason like fragmentation removal ,moving to different tablespace etc. General tables for rebuilding the oracle table is Rebuild the table […]
CPU vs Core Vs Socket
We often get confused between CPU vs Core Vs Socket and How to find that in Windows. Here is my attempt at explaining those terms and how we can find them in Windows Physical CPU It is the physical Processor on the server.Each CPU is assigned to one socket Core Each Physical CPU consist of […]
Difference between v$system_parameter and v$parameter
In this post, we will discuss the Difference between v$system_parameter and v$parameter and other parameter view available in Oracle database. Lets first start with the definition of each of them V$PARAMETERIt displays the information about initialization parameters that are currently in effect for the session. V$SYSTEM_PARAMETERis the view which shows instance level parameters (and these are […]
alter system switch logfile v/s archive log current
Oracle Redo and archive log files are two important pieces in Oracle database environment. They both are used for recovering the database from failure.I would be explaining two important command alter system switch logfile and alter system archive log current about them ,their difference and what they command actually performs in the oracle database ALTER SYSTEM […]
