Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. joeythelips

    Crontab job not running?

    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?
  2. joeythelips

    Creating Sequences in Oracle

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

    Creating a Sequence in Oracle

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

    standby databases

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

    changing a text string in file

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

    copy database wizard fails

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

    DATABASE Maintenance Plans

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

    recovery options

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

    trigger not firing?

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

    fbackup problems

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

    error 22022

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

    IZO 001

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

    stored procedures

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

    lost password for sa

    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!!
  15. joeythelips

    sql server agent won't start

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

    rolling a databse back

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

    granting access to multiple tables.

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

    xml file into oracle

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

    ftp file to a windows shared drive

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

    deleting vs de-taching

    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?

Part and Inventory Search

Back
Top