Search results for query: *

dhookum, Yes, that's exactly what I was trying to do. Your way is much more succinct. I've implemented and tested it and it looks good. Thank you!

...Number]. This look right? '1.3 Run insert into into tblHardwareNoDups to set columns Set qd = db.CreateQueryDef("", "SELECT * INTO tblHardwareNoDups" _ & " from tblHardware;") qd.Execute '1.4 Now that its...

Hey everyone. Complicated reason why we're wanting this, so I won't go there... I leave it at there are Hardware servers with some VMs on them, each therefore having the same Serial Number. Basically, I have a field (Serial Number) that contains some duplicate values. I want to delete the...

...'1.3 Run insert into into tblHardwareNoDups to set columns. This creates tblHardwareNoDups Set qd = db.CreateQueryDef("", "SELECT * INTO tblHardwareNoDups" _ & " from tblHardware;") qd.Execute '1.4 Now that its columns are...

In case anyone is interested in the solution: https://community.oracle.com/thread/3549566

Questions: 1. When does utlpwdmg.sql run? (Other than when a DBA manually runs it) - When a user changes his own PWD? - What about when a DBA changes a users's PWD? - When a user with a profile assigned a password verify function signs in? - Other times? 2. Can you put...

Well, I skipped right to step 9 and ran the following command: @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql I can now run the SQL select statement I was initially trying on dba_users. Only the OUTLN, SYS, and SYSTEM users are present. Should I be good to go or do you suggest...

I think I'm on to the root of the problem (thanks to yelworcm!). I initially created the 'oracle10' database using the DBCA, launched by the Oracle Universal Installer during install. Not knowing what I was doing, I later issued the CREATE DATABASE command. I'm fairly sure I just used "CREATE...

Thanks, LK, Is is possible I'm not using the correct db or something? I'm used to MySQL and the USE DATABASE command, but am learning that's not the way Oracle works. What are the startup steps I should take on a newly installed DB on Oracle Linux 5 to make sure my db is started correctly, I...

...and I'm trying to get off the ground. Although I can see dba_users exists in Enterprise Manager, I can't query it in SQL_Plus. I get: SQL> select * from dba_users; select * from dba_users * ERROR at line 1: ORA-00942: table or view does not exist I'm logging into SQL Plus...

I've browsed related threads and found nothing of help. Could someone please suggest a way to import a large, fairly complex XML file to MySQL? By large I mean about 19000 lines, and by complex I mean nesting about 15-20 levels deep. I'd prefer this solution not cost me money, if possible...

Update: I've tried uninstalling the 'Sony Picture Utility' software that came with the camcorder and reinstalling from the disk that came with it in an effort to rule out any automatic software updates. I've decided not to update the bios as the camcorder was working with this version of the...

Well, the funny thing is that after lunch the Device Manager no longer showed a Code 10, and said the device was working properly, but when I tried to capture video it didn't recognize that the camera was plugged in. I may try the linux disk to see if it is Vista's problem. I will probably...

...that came w/ MOBO but I never installed, it acts the same way as the integrated firewire. Downloaded files (newest is v1.7) to update MOBO bios. *Haven't flashed BIOS because I don't have a floppy drive.* *Thought that it could just be a bad firewire cord, but haven't had chance to confirm*...

Have to be online to access the site, which I can't do without a working network adapter :) I may pull it out and put in it the "old" XP machine, but that probably wouldn't help because it'd see that I have the 32 bit drivers I need for XP. I guess I could go buy one of the adapters that's...

I sure have seen that link, linney. A few of the members there have had luck getting their adapters to work. Unfortunately they're using a WMP54G V4 with a Ralink 2500 chipset, whereas I have a WMP54G V2 with a Broadcom 4300 chipset.

It's a PCI adapter, not a router.

Has anyone had any luck getting a Linksys WMP54G v2 with the Broadcom Chipset working on Vista 64bit? I found drivers that say they should work and I've heard testimonials of others online saying they got theirs working but I keep getting a 'code 10 - device cannot start' error. Any help?

The cost aspect really isn't an issue. We have other DBs running on Oracle 9i, and have servers already setup. This DB was built with a small targeted scope of users and because of Access' RAD abilities and small user base was built on Access. It's grown and we want to migrate it using...

After doing some research on the subject, it appears that the major performance gains that Oracle provides will only be realized after ensuring that the Microsoft Jet DB engine doesn't handle any of the data requests. There is a great Oracle paper (chapter 5) on the subject at...