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');