Oracle : Cloning user in Database

 

Oracle : Setting up glogin.sql

Setting up glogin.sql : cd $ORACLE_HOME/sqlplus/admincp glogin.sql glogin.sql.bkp vi glogin.sqlSET termout offDEFINE myv = ‘Not connected’COLUMN myc new_value myvselect user || ‘@QA@’ || global_name myc from global_name;SET sqlprompt ‘&myv:SQL> ‘ Execution : $ sqlplus scott/PW SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 27 21:56:19 2017… Read More