Search results for query: *

For the life of me I can't figure out how to do this. The set up is as follows: Database - Sitting on a unix box that has OS account oraxxx which belongs to the dba group. OEM Console - connected to a repository on a Windows PC. Logged on to Windows with a domain user that is not the same as the...

Hi there. I am oracle 8i OCP certified. I want to upgrade to 9i then probably to 10g. A couple of questions: 1) Is it only necessary to do a single "New Features" exam to upgrade? viz there is no practical component? 2) Info on the best study guide is pretty sketchy. Does anyone have any...

Hi there. I'm a bit stumped. I'm trying to create a Stored Proc that will create some temporary tables on the fly. The thing is that the data that populates those tables has selection criteria where one of the values comes from a parameter passed into the proc. For Example: Create Procedure...

Hi there, I have been given the task of upgrading our only iSeries (which is a production machine) from v5r2 to v5r3. By the way Ihave only been working with AS400 for about 3 months. I an following the IBM upgrade/install manual but have a question. It talks about checking system values...

Hi there, I am trying to find a qry400 query on an iSeries running v5R2 that someone else wrote. Is there a system table that I can query that will show object names, user descriptions/text etc? Thanks in advance, Jason

Does anyone have the above guide? I have all the others barring this one if anyone cares to swap. Email me at darkman0101_at_hotmail.com

Hey there, we wish to create a testing database from our production DB. We use rman without a recovery catalog to do daily hot backups. My question is... if I want to create the duplicate database on a different host do the platforms and Operation Systems need to be the same? Eg if the Prod...

Hey there, we wish to create a testing database from our production DB. We use rman without a recovery catalog to do daily hot backups. My question is... if I want to create the duplicate database on a different host do the platforms and Operation Systems need to be the same? Eg if the Prod...

I have taken for Oracle 8i DBA: Sql PL/Sql, Architecture & Administration and passed Backup & Recovery this afternoon. What should I study for next? Performance Tuning or Network Administration? Which one is more interesting/easier? I don't suppose it matters as I will have to take both but if...

I have been studying for the PL/SQL exam for 8i. Just about ready to sit the exam I think. I don't generally use SQLPlus much though as there are better products for writing queries/procedures. Will the Exam have any questions on formatting output/SQLPlus environment variables? Cheers in...

I need the developr.hlp file for the crystal control for VB. Can't lay my hands on the CD at the moment. Could someone tell me where to get my hands on it online? Thanks in advance Jas

I need the developr.hlp file for the crystal control for VB. Can't lay my hands on the CD at the moment. Could someone tell me where to get my hands on it online? Thanks in advance Jas

The boss has supplied me with a professional subscription to OLN as it is cheeper than sending me on a course. I am in the process of working through the eLearning classes on Architecture and Administration in the hope of sitting the exam at the end. I have little DBA experience but find that...

OK, I have a question regarding server manager (svrmgrl). On Unix you set which database you are working with by using the ORACLE_SID environment variable. How do you do this in windows? How do you specify which DB you are starting up and shutting down etc? Cheers in advance

Hey there all... It's been a while. Today's question is... how can I find Files of a given type? For example.. lets say I want to search the n/w for mpeg files... I want to be able to search the file header or something to tell me if a file is indeed an mpeg. Lookng at the file extension is not...

I know that this has been done to death and I know about the SetWindowsHookEx function and pointing it to a call back in a Win32 dll. I am sure that I read other posting a different ways to do it. Now that I want to print out these threads I can't remember what they were. Help Cheers Jas

Does anyone know how to hide an exe created in VB6 from NT Task manager. There is nothing sinister about this. I have an application that has a WaitForSingleObject call and in this wait state the application is deemed as Not Responding by Task Manager (applications tab). This should be...

This may sound like a strange question, but, assuming that you have assigned an icon to a forms icon property how the blazes do you revert it bact to the vd befault icon for forms? I can see no .ico or .cur file that looks like the default. I thought that the information would be in the form's...

I have an application that uses a system Tray control that I have written (very similar to the one that MS give as an example) to put an icon in the system tray. On the form that this control is attached to is a menu structure (created with the menu editor tool). When the systray icon is...

This is not the standard GetUserName question. As far as I can tell that API will not work for me here. You see I am running this application from Win 2000 scheduler. In scheduler you specify what user account you want to fire the application as, (much like the startup of a service) In this...