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?

sorry asbout that

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...

...SET FILE_TYPE = 'LOG FILE' WHERE FILE_TYPE = '2' -- CONVERTING SPACE INFO INTO MB FROM 8K PAGES. UPDATE #DBSIZES SET SPACE_USED = (SPACE_USED*8)/1024 UPDATE #DBSIZES SET FREE_SPACE = (FREE_SPACE*8)/1024 -- RE-ARRANGING THE DATA INTO THE UTILITY..DATABASE_SIZINGS TABLE SELECT * FROM...

...ISCUST$more recoverstdby.log ORA-24323: value not allowed ORA-03113: end-of-file on communication channel alter database mount standby database * ERROR at line 1: ORA-03114: not connected to ORACLE alter database recover automatic standby database * ERROR at line 1: ORA-03114: not...

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 the job setup now to be run as sa. on another note, what are the implications/advantages of having full recovery mode versus simple?

also, the recovery mode is simple!

Hi, thanks for your help. i checked the job history and got the following: The job failed. The owner () of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not have server access. How do i check who the job runs as? I take it it is run by the user who my sql server...

thanks ken. looks like import/export is my best option? alex, i think transportable tablespaces are available in 8i. how would that work then?

alex, thanks for your help. unfortunately i don't think this would cover my needs as 1, i have a couple of tables with long datatypes. 2, i would also need to recreate some constraints. Joe

hi ken, that was kind of what i was thinking of, but would i not overwrite the entire database with that approach? i just want to 'refresh' one schema? Joe

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 Guys, spoke to HP on this issue: you cannot have an * in the included or excluded directories: fabackup looks for a file names * Thanks Joe

thanks alot Joe

...afiedt.buf 1 create or replace trigger policy 2 after insert or update 3 on emp 4 begin 5 dbms_output.put_line('howya head'); 6* end; SQL> / Trigger created. SQL> ed Wrote file afiedt.buf 1 insert into emp(empno,ename) 2* values(280,'tommy') SQL> / 1 row created...

Hi Dave. i log onto the sql server as administrator but have the outlook configured for my own email account. Is that what is causing the problem then? Joe