Wednesday, June 26, 2013

toad connection not open in windows 7 64bit

install toad in something like c:\temp  instead of  c:\program file(x86)

Friday, June 14, 2013

datapump export from multiple schemas

DUMPFILE=bck_dir:t1.dmp
logfile=bck_dir:t1.log
schemas='scott','order'
include=TABLE:"IN('BLT_CTL','BRPT_LOG','ATLAS')"

in above case if a table is in both schema then it will export both the table from both schemas.

Saturday, June 8, 2013

utl_recomp hanging

check the shared pool size

add sqlnet.outbound_connect_timeout=10 ( if single task message wait coming)
flush shared pool

Tuesday, June 4, 2013

oraenv in 11.2.0.3 on hp-ux itanium issue sh: @: Parameter not set.

$ . oraenv
sh: @: Parameter not set.


Our unix administratos have set user profiles with:
set -u

which will exit any script if you try to use an uninitialised variable.