Search results for query: *

Hi I am trying to add a cronjob which will zip log files at the end of the day. I have added the following command 15 00 * * 0-6 find /opt/gtx/common/logs/testcompress -mtime +1 -exec gzip -f {} \; I can't seem to get it to work, has anyone any suggestions?

Start Your Own Group on Tek-Tips! Click Here! My Threadminder Activity since last visit Remove forum(s) from list MIS/IT Lotus/IBM: Notes Microsoft: Office Andrew Tridgell: Samba -General UNIX discussion HP: HP-UX Microsoft: Internet Information Server Programmers Microsoft SQL Server...

I am try to creata a sequence starting with a value from another table CREATE SEQUENCE CALL_PRODUCT_SEQ START WITH (SELECT CURR_VALUE FROM snap_counter where name ='AIB_CALL_PRODUCT_SEQ') INCREMENT BY 1 however it won't allow it, I have also tried to create the sequence starting with 1 and...

Hi, i am running the following script on my HP-UX server connect / as sysdba spool /u01/backup/ROIMOP/logs/recoverstdby.log startup nomount alter database mount standby database; alter database recover automatic standby database; shutdown immediate; spool off exit , but keep getting the message...

Hi, I have a query which i imagine is pretty easy to do but i need the help of someone: i have a script file whcih contains references to directories eg /u01/backup/ISCUST/ftpfiles.sh I want to change the script using vi to /u01/backup/ROIMOP/ftpfiles.sh How can i change the word ISCUST to...

Hi, i am trying to copy a db from one server to another using the copy database wizard. No matter what options i select, the job keeps failing with the following error message: Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Unspecified error...

Hi, i have a database maintenance plan which i cannot get to work. I back up master, model, msdb and one user database as part of the plan. I have none of the optimisations or integrity options checked. I back up the data files and transaction logs at the same time. However, the plan fails...

Hi, I have an oracle 8i database which contains 4 different schemas each with its own tablespace and datafiles. A request from the business is that one schema is refreshed every night to be the same as its original starting position. my plan was to do a full truncate of all the tables in the...

Hi i have created the following trigger to write out a line of text after an insert or update: However, although the trigger gets created without any problems, the text does not write out after the commit? SQL> ed Wrote file afiedt.buf 1 create or replace trigger policy 2 after insert...

Hi, i have a hp-ux 9000 version 11.0 server which holds oracle databases and configuration files. I use fbackup to backup my files but my backups have been giving me the following errors lately fbackup(1601): could not access -i/-e file /nfsoracopy/oracle/export/moip fbackup(1601): could not...

Hi, i am trying to configure my sql server to email me when a maintenance plan finishes. I installed outlook client on the server, can open the mail box, but when i go to the properties of the operator i have setup and pick a name from out outlook list, and click test, i get the following...

Hi, can someone please tell me what the difference is between oracle 8i path exam IZ0 001 and oracle 9i exam Exam# 1Z0-007: Introduction to Oracle9i: SQL Is it the same exam ? Joe

Hi, I am pretty new to sql server. is there some advise i can get on the daily checks i should be doing on my servers and on how best to use stored procedures? Joe

Hi, is there anyway of resetting/retrieving an sa password? i have recently taken over the administartion of a db but no-one in the company has the password!!

Hi, when i try to start the sql server agent on my sql server i get a message saying that 'the service did not start due to a logon failure' i have rebooted the server but the problem persists. any ideas? i am new to sql server so i'm not sure where to start. Joe

Hi, I have an oracle 8i database which is being used for development purposes Every night i take an export of the database. I also take a cold backup of the database to tape. My developers have requested that i be able to roll the database back to the state it was in for example 3 days ago. I...

Hi, I am an oracle dba and i've recently had to start learning sql server. I have setup a user called BI on my sql server and i want to give access to certain tables owned by another user to BI. These table names can be seen by using the following sql: SELECT name FROM dbo.sysobjects where...

Hi, i have oracle 8i. I was wondering if someone could point me to some sample code on how to import an xml file into an oracle table using plsql. Thanks Joe

Hi i want to ftp a file from my hp-ux folder to a shared windows drive on our network The filename i want to ftp is winb.csv Can someone help me write the script for this. The windows shared drive is called data1 and the share drive is on s: hope this makes sense

Hi, i was wondering if there is a difference between detaching a database and deleting it? If so, how do i delete a detaached database?