Recent content by Dudek

Hi there.. We have a couple of filesystems that have been converted from UFS to VXFS. I was wondering whether there is any way to convert the VXFS filesystems back to UFS without having to copy out all the files in the VXFS filesystem and copying them back into a UFS filesystem. Is there any...

>>Restart the ntp daemon at the ntp client side and sync >>the date.. Does that mean that every time i change the date on the server i need to restart the daemon at the client? I need to know this cos i am planning to have 20 other clients to sync with the server.. and it defeats the purpose if...

Hi there, I have configured 2 servers running on Solaris 2.6, one as a ntp server and one as an ntp client pointing to the server. The thing is, when i first started up the ntp daemons on the server and then the client, the time on the client server synced with the time of the my ntp server...

hi there.. thanks for the reply. Nope. not talking about my boot disk. Its just another filesystem. I was thinking that creating a new filesystem and copying out the files from the converted (vxfs) to the new filesystem would do it. But are there any other way? And would the vxunroot work for...

Hi there, I have a filesystem that was converted from ufs to vxfs using the veritas file system converter vxfsconvert. How do i undo the conversion to convert back from vxfs to ufs file system? Thanks JD

Hi there.. Sorry for the late reply again. The reason why i dont want to use import export is because the database is huge 10TB and to do and import export would cause a too long down time. Actually i have read somewhere that if you have the contorlfiles, datafiles and all (from the 815), you...

Thanks for the reply... Yeah.. import/export would be able to do it. But is there any other way to do it wihtout using imp/exp. That is why I am wondering whether the steps i mention would work or not and if it *could* work, how do i go about doing it and what are the main points / issues i...

Hi there.. Sorry for the late reply. But actually what i really need to know is, If i have 2 different oracle instances running on the same server, basically one is oracle 816 32 bit and the other is oracle 817 64bit (64 bit OS obviuosly). Currently i have the database with the data running...

Hi there. I have a one instance running Oracle 816 32 bit and one disk with all the data in it. I also have another instance on another server running 817 64 bit. Both the databases are the same (table spaces/ tables etc etc). So i was wondering whether i can just take the disk form the 816 32...

Hi there... I currently have a perl script. I was wondering whether it was possible for me to include into the script the environment variables in my unix .profile file into the Perl script. The reason for this is, i need the cron job to run the script automatically every day. But when the cron...

Hi there, How can i compare the number of rows in two files (UNIX)? Basically what i need to do is: if (compare number of rows ('file1', 'file2')==0) { do something; } so is there any way to do the comparison of the two files to see whether they have the same number of rows? TIA JD

Hi there again.. Another question I have a script that runs 3 seperate scripts like below: script1.sh & script2.sh & script3.sh & it pushes it all to the background. I need to run a script script4.sh that would start after ALL THREE scripts script1.sh script2.sh and script3.sh has been...

Hi there.. I was wondering whether anyone can help me here.. I have ten files which is divided into two groups IN and OUT the format of the files are rraIN, rraOUT, rrkIN, rrkOUT, szrIN, szrOUT..... where the first 3 letters are in a list in another file list.txt which lists rra rrk szr...

Hi there.. ANybody knows how to select a random row from a table? The table has a key, but the key's number jumps occasionally so i couldnt use like below: select convert (int, max(key) * rand()) for a random key, as it will sometimes give out a null number So anybody can help me here...

Hey there.. Basically, as the subject says, my cursors in my stored procedures return the last row of its resultset twice. I was wondering why this is happening. Heres a basic structure of my cursors. Am i doing anything wrong here? create proc check_no_letter_type as begin declare @ltr_type...