I have heard of Trimble; we interface with them through a Message Queue. We have some customers who use it. I've also have heard of Systech being bounced around here in our office. I've been working here for about a year. I think that the biggest growth in this market is going to be...
Hi,
I work for a company called Command Alkon, which use to be Command Data. We create a product called COMMANDseries. www.commandalkon.com. He have more than 80% of the market.
Thank-you for replying,
I agree with your statement that most business consider IT as a business tool and at least as a value-added part of doing business.
I am in the construction materials business. We also have issues where if our customer's servers were to go down, they could still...
..."Sql Developer" that Oracle has been distributing (www.Oracle.com).
I typically just edit my scripts in any ascii text editor. When you run SQL*PLUS in 10g you refer to the file as such
SQL>@C:\ORACLE_HOME\PRODUCTS\10.2.0\ORCL\MYSCRIPTS\SCRIPT.SQL
The entire script will store into the...
Anything from Oracle Press is good. Beware of those books with the funny looking animals on the cover. Also, find an Oracle DBA who has access to metalink and see if they can send you something. All Oracle CDs have pretty comprehensive instructions in its docs directory.
Take Care.
...database (i.e. catpatch.sql, etc.)
4) Check the install manifest (installed products) through the Universal Installer and make sure that the SQL*net versions 10.2.0.1 have been updated to 10.2.0.3
5) Make sure any anti-v irus software is disabled.
6) You can also try reapplying the...
If you have read Nicholas Carr’s article in the Harvard Business Review or his book called “IT doesn’t Matter” you will get an idea of how important business processes are to technology. I do not use the term “Information Technology” any longer because the idea is that business exists to serve...
Hello Group,
This feature appears to be in SQL-Server 2005 Transact-SQL.
It is the pass-through feature. Here is how it would work:
Execute a pass-through command against a linked server
{ EXEC | EXECUTE }
( { @string_variable | [ N ] 'command_string [ ? ] ' } [ + ...n ]
[ { ...
Hello group,
I know probably the first response to this message will be "Why would you want to do that?" But trust me, we have a good reason.
We are trying to create a distributed database system that will allow us to execute create table... and alter table... commands from a master server to...
Thank-you for the response.
Rather, here is the senario:
You have approximately 100 users who have citrix clients that connect to one citrix server. That server in turn has one set of database credentials that makes multiple connections (same user/password/database serial#) to an Oracle...
Hello Group,
I would like retrieve the information from a Citrix Server in reqards to who is connecting through a Citrix Client (ID number, Computer name, username). Is it possible to retrieve this information from Citrix so that I can pass the information to an Oracle database using...
Hello,
I desperately need help on this Microsoft problem. We have a web application that uses session variables that records when a user is logged in to our ASP web page. It contains things such as how long a user is logged in, variable values, etc.
Problem is the application maintains its...
I just build a transaction replication at a customer site because I felt that it would give them the kind of fail-over that they required. Unfortunately, I never realized how difficult it would be to simply drop tables, change columns, or do other DDL.
If you want to drop a column, then...
Hi,
Actually, it works this way:
Making sure that you have stored procedure properties option is set on file/options -> database tab
Using report -> report expert, you would select the database though ODBC or another connector -> Choose stored procedures. The stored procedures must have...
In order to move data from a table with CHAR(1978) into a blob field with datatype BYTE, I'm using the load and unload commands. But, when I try to load the data into the table with the BYTE datatype field, I get the error:
32405: Incorrectly formed hexadecimal value.
Please Help!
I am an Oracle Certified DBA. I'm currently certified in Oracle 8, and will be certified in 8i and 9i by years end. I first learned Oracle the hard way, by hands-on experience, back in 1994. My advise to anyone wanting to become certified is the following:
Never pay for Oracle Course...
You can try this:
J:\>exp system/manager@mdb file=test.dmp owner=scott
If you do not change the system password often.
Dmooreora.
Also, look into using SQL*LOADER. It is good for batch loading and unloading of data.
Can someone get me a sample of 4GL to move Char(1978) to BYTE. Currently, this is what I am doing.
In order to move data from a table with CHAR(1978) into a blob field, I'm using the load command. But, when I try to load the data into the table with the BYTE datatype field, I get the error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.