Author Archives: Ahmed Tawfik

Unknown's avatar

About Ahmed Tawfik

Cybersecurity Professional, Systems Engineer, OSS & Linux Geek

How to switch from one user to another in sqlplus

Posted on May 29, 2013 by Ahmed Tawfik

for example, you’re connected as sysdba using “sqlplus / as sysdba”, all you have to do is type “connect”, then enter the desired username and password, and there you go!

Posted in Uncategorized | Tagged , , , | 2 Comments

How to get current logged-in user in sqlplus

Posted on May 29, 2013 by Ahmed Tawfik

select user from dual;

Posted in Uncategorized | Tagged , , | 2 Comments

How to create missing table S_ETL_PRD_REL from ddlimp utility

Posted on May 28, 2013 by Ahmed Tawfik

– Login to the server with the Oracle BI Applications installed – Run the following command (in this case it’s a windows server): D:\instance_name\mwh\Oracle_BI1\biapps\dwrep\Bin\DDLIMP /U siebel /P ***** /a SIEBEL /C tp4u12 /G SSE_ROLE /W Y /B SIEBELDATA /X SIEBELINDEX … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 1 Comment

Increasing size of ASM-based bigfile tablespace

Posted on May 27, 2013 by Ahmed Tawfik

Firstly few commands to get you up & running: – Get names of tablespaces: “select name from v$tablespace;” – Get names of disk groups: “select name from v$asm_diskgroup;” – Get names of data files: “select name from v$datafile;” In my … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment