Search results for query: *

I am working on large project with quite of number of Access databases located at remote sites where their Access databases are in an MBE format. These files are being sent to me and, I suspect, are in a variety of MS Access versions. What are the steps needed to convert these MBE back into...

Explicit join between an Xml Table and Path_View I have an xml table(content is immaterial at this point) holding a fair number of documents(100000+), but the doc contents do not explicitly have an element for "file Name" or "Path". (Which is just as well as documents can be copied from one...

I recently had a PC upgrade that went from Win2k to Xp with a similar upgrade in Access 2000 to Access 2002. I have a form for retriving various tips and techniques that I use by doing a string search within a Microsoft Rich Textbox Control, version 6. After the PC upgrade, string searchs no...

Sharing folders between Win2k, sp 2, and WinNt, sp6a. In a simple home network, 2 PCs, I am trying to set sharing so that both PC can read a folder of a similar name on both C drives. I can ping both ways between the PCs. After much work (and luck) I have got Winnt to map to a folder on Win2k...

Reading a book (Oracle Performance Tuning [an O'Reilly book], pg 427) tells of a sql script called Sync.sql. It explain on running this make little sense. Sync.sql is a file that is wrapped or encrypted. Yet the book tell of doing a "EXECUTE SYNC.INIT" like it was a existing stored...

I need to disable USB for Suse 8.2. During my new installation on Suse 8.2 I missed the the point where I need to disable the USB probing during initial boot up. There is an environment variable called HOTPLUG_START_USB that by default is set to "yes". I need it to be...

I was writting an anonymous PLSQL block to re-synchronize Sequences, sometimes Sequences get out of wack with their target tables. Fine, so I want to simply increment the sequence. But, neither Native Dynamic Sql nor DBMS_SQL approaches is working for me. Are Sequences excluded from being...

I am new to Java and am trying to use Oracle's Java packages. I get not find the location of these relevant jar files in order to set up my class path. For the listed packages, what would be the path? Is there any documentation for where these jar files are, normal Oracle documentation is not...

I just received a tip about a query that explicitly lists a constraint with its underlying index. Very nice. One of the tables referenced in this query is CDEF$. This table has a column called TYPE# which has numbers that varies from 1 to 12, apparently categorizes the constraints into types...

I have a weird error on my Windows 2000 Professional PC. After using a graphic program (Maj Jong) once in a while my mouse pointer is transformed from an arrow to a diffused square about an inch on each side. Anyone every run across this error? I have recently load the newest service pack 2...

I have a Oracle 9i, Release 2 (9.2) database with the follwing table: BETA92XD> desc xs_table Name Type NULL ---------------- -------- -------- ID NUMBER NAME VARCHAR2(120) FILE_TYPE VARCHAR2(4) XML XMLTYPE A SELECT yield that...

I have installed an Oracle 9i client onto my WinPro 2k PC. I see that, I believe, that somehow the Oracle client is loading two copies of Apache.exe (and I suspect java.exe) into RAM upon boot up. I have searched my Startup folders under all my profiles and the registry to find out where...

I recently installed a Windows 2000 (Professional) OS onto my cobbled together system into the H partition. I still have Windows NT (Sp 6a) on another partition (C). All partitions are NTFS. I want to de-install Windows 2000 from the its partition so that I can upgrade the existing Windows NT...

We are using Oracle 9i with iFs loaded on a Windows NT server. We are trying to get Webdav up and running and can not seem to. We have http, smb, and ftp all are working. How do we tell if Webdav is configured properly? Any hints on Webdav you can give us will be greatly appreciated.

I have a Sql Server 7.0 and Oracle 8.1.5 databases. Both databases are separate NT 4.0 servers. I want to create a view in Oracle that references the tables found on the SqlServer database. What are the steps I need to take to get this done?

If one is to calculate the total memory allocated to an 8i Oracle instance on a UNIX Box from the V$parameter table, which values would you sum on? Also, in this table is a "Type" column. Can you give a brief desc on what these difference types are? Thank you.

I am fairly new to Access 2000. I want to timestamp a record anytime I make a change to it. I have tried looking thru the documenation, but to no available. I want my table to have something like a default value of Now() on my field, but it would be activated whenever a update was processed...

I was doing some queries using various V$ tables and found a column in V$SqlArea called "Command_Type". I have searched thru the web and Oracle on-line documentation and still can not find out what these numbers stand for. Does anyone have a list of Command_Type numbers and what they...

Hello. I have a requirement from a customer(and a Web programmer) that from a Web page that a supporting (can be a large Pdf or Word file) document is be inserted into the database as a Blob. Our environment here is a Windows NT client, an Windows NT Web Server using Asp, and a 8.1.5...