Hi guys, just wondering if:
1. Can Sql Server do logon triggers?
2. Can I store session variables e.g. when a user logs on, select a value from a table and store that somewhere in memory so i can use it in other select statements...
3) Do dynamic sql within a view?
thanks for any help.
Hi all,
I have a site where intermittenly the AIX 4.3 box reports back:
write_data: write failure. Error = Not enough space
there is plenty of free disk and when I create any file of any size, this message comes up in a samba log.
Any advice appreciated!
Cheers,
Neil
Hi All,
I need to maintain a remote copy of a source directory tree, includind all its sub-directories. I am considering using rdist, but am unsure if this does the latter need. Does anyone have any experience in this or can prescribe an alternative method?
Cheers,
Neil
Why not tabluate the output of the df command to a text file and then use an SP to load into your appropriate table (effectivly SQL loader). Even better, kick this off from withn Oracle by using External procedures.
N.
Wongyc2k,
there are a few things that you may first wish to check regarding your usages:
1) Use direct, non-recoverable load
2) Load from a file locate local to the server - ie not across your network
3) Consider the frequency of your commits, and/or if this a the only batch job, switch off...
Hey all,
I am stuck with a problem, in that I require to mount some drives from a remote network device and add these as a resource share. I will then write to these shares via Oracle External Procedures, so thats why theyt have to be mounted from upon the live node in the cluster. I am unsure...
Also try to get put of the habit of using internal as the user - oracle have now desupported this "shortcut". Just use:
sqlplus "/ as sysdba"
instead - note that svrmgrl also desupported.
It is the "sysdba" privilege which gives you highest admin rights eg...
As analternative you may wish to work on a copy of yoru crontab, and then when finished, input that back into crontab.
ie
#crontab -l > mycron
#vi mycron
*make changes* and then save, exit
now update the current cron schedule for this user by:
#crontab mycron
#rm mycron
br,
N.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.