Please turn JavaScript on
header-image

Alter-database

Get updates from Alter-database via email, on your phone or read them on follow.it on your own custom news page.

You can filter the news from Alter-database that get delivered to you using tags or topics or you can opt for all of them. Unsubscription is also very simple.

See the latest news from Alter-database below.

Site title: Database Technology

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  3 / week

Message History

 ################################################################################################

# purpose     :script used to collect PROD  Redshift super user list for audit

# Author      : Bala P

# Developed   :19-sep-2022 V1

##########################################################################...

Read full story

 Here is the shell script to monitor the Long running session details in AWS redshift, we can schedule it .

##################################################################################################

### purpose     :script used to collect Redshift long running session details             ...

Read full story

 Here is the shell script to do de-fragmentation activities for a table in Oracle database. 

You can feed the table name and schema name and run this script in back ground 


#!/bin/ksh


export ORACLE_HOME=/oracle/TESTDB5/1924

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=TESTDB5

Read full story

 Here is the full  script which will get few input and build the oracle database and configure the listener,tnsnames.ora.pfile/spfile and convert the database to archive log 

#########################################################################################################

#purpose       : Script used to build oracle DB,pa...

Read full story
Read full story