Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
RADDBDIF WRITE_FAILED error (4.6C/Oracle817)
Dear all I have been trying to get a test environment setup so that a few of us at work can learn the basics before our live system, goes live !!! I am having some real problems! During the installation of 4.6C I got the RADDBDIF error. I checked the SAP OSS and found that the program could...- OLAPer
- Thread
- Replies: 1
- Forum: SAP ERP Solutions
-
Intelligent Agent....not so !
Dear All I am having problems with an Oracle installation that I have recently undertaken. I have done a created two instances of a database on the one Windows 2000 Advanced Server box. The problem I am having is that only one Intelligent Agent/Data Gather will come online at a time. Please...- OLAPer
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
How to list directory contents?
Hello What I want to do is retrieve the contents of a directory, from which I will import data. The reason I want to do a listing is that the number of files may vary, although all of them will be CSV format. I want to then loop round and import each one. I know that I can use...- OLAPer
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Nucleus Database from SAND
Hi people! I am starting a new role where the company has implemented SANDs Nucleus database. I was wondering whether anyone reading this might be able to give me an insight into the workings of Nucleus. Most importantly the database uses Bit-Map Vector Indexing, which I believe is not really...- OLAPer
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
-
Indexes....Update !
Hi everyone ! I have a quick question regarding Index usage. I am wanting to speed up an update, the columns that I am using to link the relevant tables are not indexed. I was wondering how the UPDATE command uses the INDEX created on a column? Any assistance appreciated. OLAPer ::-> -
Performance enhancing of correlated query?
In a correlated sub query is it better to use EXISTS or IN? Is it dependent on whether or not an index exists? Here is an example: UPDATE TABLE1 A SET A.COL1 = (SELECT B.COL2 FROM TABLE2 B WHERE... -
Why does this SQL not work !?
Hey gurus ! I am trying to run this SQL statement, but it won't run ! Please tell me why ! UPDATE S_CONTACT A SET A.CREATED_BY = (SELECT B.S_Employee_ROW_ID FROM TEMP.UP_S_CONTACT B... -
Update of table using joined tables !?
Hi everyone I have a query that is boggling me ! I have three tables, e.g. S_CONTACT, EIM_CONTACT and S_EMPLOYEE. ============== S_CONTACT - Created_by - Row_id =============== EIM_CONTACT - Created_by - T_Contact__RID =============== S_EMPLOYEE - Row_id - Login =============== The... -
LOAD FROM error HELP !
I am in desperate need of some assistance please. Whilst attempting to LOAD FROM a CSV file to a table in DB2 I get errors. The database falls over. Please please help, the load command is too long to post here, so if you e-mail me I will forward the details to you..... Here is the error... -
Aggregate Fact Tables ?
Hi, this is my first ever thread.....<br><br>I'm probably going about this in the wrong way, your assistance will be greatly appreciated, let's see if I can explain :<br><br>I am currently in the process of developing a Performance Monitoring/reporting ROLAP solution. I have a number...
