Delete files older than X days

Posted on August 27, 2013 by Ahmed Tawfik

find /path/to/folder -mtime +14 -exec rm {} \;

This finds all files within that folder that are older than 14 days, then executes rm on them

Posted in Uncategorized | Tagged , , , , | Leave a comment

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