SQL Server Commands to Oracle Counterpart

• Get table size
• answer sp_spaceused T_CLMaster;
• from studio choose table and then press F7
• How to import and export tables in sql server
• export. msdb>choose db>rt clck >task >export data>Date Source:'SQL Server Native Client 11.0' > choose DB > Destination:'SQL Server Native Client 11.0' >Choose server destination > Choose DB Destination> Copy data from one or more tables or views > choose tables> run immediately
• Select into

select  * into y_clmaster from T_CLMaster where CLID in ('LDP00000000002957187',

• 'LDP00000000003649120',
• 'LDP00000000003652388',
• 'LDP00000000003652389',
• 'LDP00000000003654044',
• 'LDP00000000003654045',
• 'LG000000000000000996',
• 'LG000000000000000998',
• 'LG000000000000000999');

Find Large Files in Unix

du -a /home | sort -n -r | head -n 10

find . -ls | sort -nrk7 | head -10

du -hsx * | sort -rh | head -10

How to attach an Oracle Home

./runInstaller.sh -attachhome ORACLE_HOME=/upgrade/R12_R12D2/fs1/EBSapps/10.1.2  ORACLE_HOME_NAME='test_TOOLS__test_applmgr_fs1_EBSapps_10_1_2'