Export current IA project Use IAAdmin.sh command line tool to export current IA project. The tool is located under your local installation of Information Server client or on server: <IIS install path>/ASBNode/bin The command to export given project content is: …
Question: How to connect to sqlplus? Answer: Launch cmd window and enter: sqlplus user/password@server Question: How do I execute a SQL script file in SQLPlus? Answer: To execute a script file in SQLPlus, type @ and then the file name. …
Built in package to pull out create statements. Can be used to copy a table along with indexes and constraints etc: http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_metada.htm
To enter the ^M character in unix enter the following: Control-V Control-M
find <ROOT_SEARCH_DIR> -name “<WILDCARD_FILNAME>” -mtime <DAYS SINCE LAST MODIFIED> -type f -exec rm -f {} \; e.g: find /home/users/svollett/test_purge -name “FILE_A*.txt” -mtime -1 -type f -exec rm -f {} \;
Use CUBE and ROLLUP to calculate aggregates at many levels in one statement: http://docs.oracle.com/cd/E11882_01/server.112/e25554/aggreg.htm#DWHSG8613 ROLLUP example ============== SELECT channel_desc, calendar_month_desc, countries.country_iso_code, TO_CHAR(SUM(amount_sold), ‘9,999,999,999’) SALES$ FROM sales, customers, times, channels, countries WHERE sales.time_id=times.time_id AND sales.cust_id=customers.cust_id AND customers.country_id = countries.country_id AND sales.channel_id= …
set serveroutput on; alter session enable parallel dml; –NB: not possible within partition or on non-partitioned table for delete/update/merge operations alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’; select sysdate as script_start from dual; <STUFF> select to_char(sysdate, ‘YYYY/MM/DD HH:mi:ss’) as script_end from dual;
Use insert append hint for fast inserts. Almost as fast as bulk load. alter session enable parallel dml; alter index <INDEX> unusable; INSERT /*+ append parallel (<ALIAS1>) */ INTO <TABLE1> <ALIAS1> ( COL1, COL2 ) SELECT /*+ parallel(ALIAS2) */ COL1, COL2 …
–USE ANALYTIC FUNCTION TO DELETE ALL BUT ORIGINAL delete from <TABLE_NAME> where (key1, ins_timestamp) in (select key1, ins_timestamp from ( select key1, ins_timestamp, upd_timestamp , row_number() over (partition by key1 order by ins_timestamp) as rownumber from <TABLE_NAME> ) t1 where …