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 Rhinorhino 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: *

  • Users: Ed75
  • Content: Threads
  • Order by date
  1. Ed75

    Trouble starting Oracle enterprise manager

    When I try to start enterprise manager I get the following emctl start dbconsole /app/oracle/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_fchap525_train not found. Any ideas?
  2. Ed75

    Problem with updating statistics

    I am using the following script to update the stats on my dataabses DECLARE @table_name varchar(1000),@sql nvarchar(4000) declare c1 cursor for SELECT name FROM sysobjects WHERE xtype = 'U' open c1 fetch next from c1 into @table_name while @@Fetch_Status = 0 begin...
  3. Ed75

    PEOpenPrintJob error

    When trying to run a crystal report from within Peoplesoft we are getting the following error. Does anyone have any ideas?? PEOpenPrintJob error Trace File Results PeopleTools 8.45.11 Client Trace - 2008-05-01 PID-Line Time Elapsed Trace Data... -------- -------- -------...
  4. Ed75

    Exporting a database

    I'm fairly new to Oracle so if this is a stupid question be patient with me :) What I'm trying to do it export a 9i database from an AIX enviroment to import to 9i on a windows platform. What I've done in the past is just run exp and move the dmp file to the windows machine drop the sysadm...
  5. Ed75

    Update Stats Question

    I am currently using the following script to update stats on all of my databases. DECLARE @table_name varchar(1000),@sql nvarchar(4000) declare c1 cursor for SELECT name FROM sysobjects WHERE xtype = 'U' open c1 fetch next from c1 into @table_name while @@Fetch_Status = 0...
  6. Ed75

    Time Elapsed

    This should be easy but I'm having a tough time with it. What I need is to find out how much time has elapsed since a certain user last executed a process on the server and return the number of minutes. SELECT last_batch from sysprocesses where hostname = 'Server1' and loginame = 'johndoe'...
  7. Ed75

    Check Recovery Mode

    Is there an easy way to Check the recovery mode of all databases on a server?
  8. Ed75

    Date Formatting

    One more question here folks.. I have a varchar(10) field that is storing a date as YYYY-MM-DD and I need the output to be MM-DD-YYYY is there an easy way to accomplish this? Thanks
  9. Ed75

    Searching a text field

    Sorry if this is a dumb question but I've never had it come up before. I need to search a text(10) field where the field is not empty. I assume I need to check the field for the first char to no be null but I'm at a loss. Any help would be appreciated. Ed
  10. Ed75

    Current Activity

    I'm looking for a script that will show the current activity on my server similar to sp_who2 but I need to see if users are connecting with named pipes or TCP/IP.
  11. Ed75

    Two Log Files

    I recently inherited a database which I am in the process of cleaning up. The database currently has two transaction logs, one to the same drive as the data and one pointed to the root of the C:\ drive. It looks like the one on the C:\ drive was added later for some reason. Is it possible to...
  12. Ed75

    Help with a Date Query

    I need to select everything from a table between two dates but only need one result per person. I can use SSN to identify an individual. Help me out please, this is not something i'm used to.. Thanks
  13. Ed75

    Add a character to a field

    I'm sure this is a stupid question but I've never done it before. What I want to do is add a leading zero to all of the items in a field that start with a 9. Can anyone lend me a hand please?
  14. Ed75

    Cannot connect to the Citrix Server

    I am having a problem with my clients getting the following message. Cannot connect to the Citrix Server: The Citrix Server you have selected can not be located. If I reboot the server they are then able to log back on. This has been an ongoing problem for quite a while now but now it is...

Part and Inventory Search

Back
Top