Search results for query: *

Sem, i would agree with Niktips - the link doesnt expire until you delete it. Remember, you have private or public links available to you. br, N.

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.

u can convert it into a chr string, and format thus: select to_char(sysdate,'yyyy') from dual; br, Neil.

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

Thansk Stefan that helps a great deal. A question though, if I have sub directories, will it also copy their contents?

cheers, but can you give me some pointers into its operation and usages. ta, N.

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

exactly the same way - eg from DOS: set ORACLE_SID=my_sid or connect via Net8 svrmgrl user/passwd@sid br, N.

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.

Oracle provide such, and you can use DBartisian too I believe. The times when I have done this however is the same method as you prescribe. 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.

Ken, do remember that your backup controlfiles, is named by default with an extension of ".trc". br, N.