Recent content by Ed75

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?

Exact same error, good thought though

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

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

Thanks...

time(seconds) unlimited file(blocks) 2097151 data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000

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

Yes, the table exists

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

Perfect.... Thank You

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

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

I'd love to convert this and store tham the way they are supposed to be stored, but then the third party application that uses this database would bomb on me. I might just have to the the peices apart somehow.

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

Select * From Table Where DataLength(TextColumn) > 0 PERFECT.... I can't thank you guys enough !!!!