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.
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
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:
which will exit any script if you try to use an uninitialised variable.
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.
Subscribe to:
Posts (Atom)