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 /F D:\instance_name\mwh\Oracle_BI1\biapps\dwrep\DDL_OLTP.CTL /L D:\instance_name\mwh\Oracle_BI1\biapps\dwrep\DDL_OLTP_instance_name.log

where /C is the ODBC data source name, so take care that you have to create an ODBC system data source first and of course to create it you must have the tnsnames entry first.

Sources:

https://forums.oracle.com/forums/thread.jspa?threadID=2249621

Click to access AnyAppUpgr.pdf

https://cn.forums.oracle.com/forums/thread.jspa?threadID=2257034

Felice Fusada from Oracle

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 case it was a big file tablespace, which only option is to resize, not to add more data files, so I did the following:

ALTER TABLESPACE tablespace_name RESIZE 40G;

To check for the size, run the following query:

SELECT tablespace_name,file_name, bytes/1024/1024 SIZE_MBYTES
FROM dba_data_files
WHERE tablespace_name IN (‘SIEBELDATA’, ‘SIEBELINDEX’)
ORDER BY tablespace_name

Posted in Uncategorized | Tagged , , | Leave a comment