Daily Archives: November 3, 2013
STEPS TO CREATE DATABASE MANUALLY ON LINUX
This article shows you steps to create a database manually on Linux. Step 1: First create all the necessary directories. Followings are my directories: bash$ ls admin backup archive bash$ ls adump bdump cdump udump Step 2: Next prepare the database creation script. Following is my script “anar1.sql” CREATE DATABASE “anar1” MAXLOGFILES 5 MAXLOGMEMBERS 5 […]
Shows the currently running SQL statements
set pagesize 60 set newpage 1 set linesize 125 COL sql_text FOR a100 wrap COL user_name FOR a12 SELECT u.sid, SUBSTR(u.username,1,12) user_name, s.sql_text FROM V$SQL s, V$SESSION u WHERE s.hash_value = u.sql_hash_value AND sql_text not like ‘%from v$sql s, v$session u%’ ORDER BY u.sid;
Disable olaraqdan Trigger olushdurma
Menim bildiyim qederiyle Oracle 11g den once gelen oracle versionlarda Trigger olushdurulduqdan sonra: ALTER TRIGGER trigger_name DISABLE; Komandasi ile yaratmish oldugumuz Triggeri disable ede bilirik. Amma Trigger yaratdigimiz zaman – o triggeri default olaraqdan DISABLE olaraqdan yara bilirikmi? Beli bilirik. Bu ozellik Oracle 11g ile birlikde gelmshdir. Misal uchun: CREATE OR REPLACE TRIGGER ANAR_TRG BEFORE […]
How to change varchar column data type to CLOB
Describe that we have a table and column varchar2 and data on that column is not null. So, what should we do? We should add column on table with CLOB type. Please look at below example: create table anar.test ( log_id number, log_date date, log_text varchar2(4000) […]
Oracle 9i -dan Oracle 10g – ye upgrade edilmesi
UPGRADE STEPS ================================================== ==> PRE_UPGRADE =============================== 1) Oracle 10g profile ile sisteme baglaniriq 2) cp $ORACLE_HOME/rdbms/admin/utlu102i.sql /tmp/utlu102i.sql 3) Daha sonra Oracle 9i profile ile sisteme baglaniriq. cd /tmp sqlplus “/as sysdba” SQL> SPOOL info.log SQL> @utlu102i.sql SQL> SPOOL OFF 4) /tmp/info.log dosyasi incelenir.Sirasiyla gerekli ishlemler edilir. 4.1 ) Oracle 10g de CONNECT role uchun sadece […]
anargodjaev.wordpress.com 