Search results for query: *

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

As far as I know noting has ever been entered into the field but when I run SELECT FieldName FROM YourTable WHERE FieldName IS NOT NULL I am getting better than 400k results and all of them are apparently empty, nothing visible in the field

SQL is not seeing the field as empty so not null is not working, I assume this is because it is a text field, but I could be wrong.

SQL

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

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.