Restoring patch from 8.1.7.4 to 8.1.7.2. Verify steps
Hi all, just need to verify if restore is required after a successful patch upgrade from 8172 to 8174, what are the steps? 1. restore the old oracle binaries 8.1.7.2 only. Will this work? Does the patch upgrade change header information, and oracle dictionary. If this is the case, then binary restore will not be [...]

Answer Question   |  September 9, 2005  1:14 PM
Database, DB2, Oracle

A Way to have multiple “Views” (permissions) to the same directory data
Basically, we would like to reorganize our data repository (right now just a hierarchical directory structure) in such a way that we can present fully permissions ?views? to various levels within our company. So if I have a directory structure something like the following: ———– | | – Customer | | – Proposals | | [...]

Answer Question   |  September 8, 2005  11:51 AM
Data analysis, Data warehousing applications, Desktops, E-business, Management, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server, Storage, Storage management, Storage products and equipment

How to disable export option in 11.5.9 thru applications.
As a security feature,we need to disable export option so that the data cannot be exported to Excel sheet directly . Is there any profile option to do so. Pls advice.

Answer Question   |  September 25, 2005  8:02 AM
Database, DB2, E-business, Oracle, Security, Windows

sqlloader problem while loading from a huge csv file
Hi all, I am new to this community. Hope to have a great learning experience here. The error I am receiving while loading a huge file is: SQL*Loader-510: Physical record in data file is longer than the maximum(1048576) Actually the csv file I am loading from is huge, has 9lac+ records. Increasing the readsize doesnt [...]

Answer Question   |  September 14, 2005  2:12 AM
Database, DB2, Oracle

tutorials-2
hi all. i have sent before a message about this subject but i didnt really had real replies that helped me. i am searching of tutorials of programming (delphi, linux, perl, python, c#, java ……) i have search in google, altavista, westciv, whatis, w3school,… So if anyone now how to get pdf files for free [...]

Answer Question   |  September 14, 2010  3:06 AM
C#, Delphi, Java, Java programming, Linux, Perl, Python, Tutorials

SqlDumpExceptionHandler Error Message In MS SQL Server 7.0
I am trying to restore a database in MS SQL Server 7.0. I keep getting the following error message. Backup or restore operation terminating abnormally. SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. I searched on google and on Microsoft’s Knowledge Base. Any reference to this above error states [...]

Answer Question   |  September 1, 2005  6:48 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Updates from SearchSQLServer.com staff

Creation of a new schema in Oracle
My DBA insists that there isn’t a role or privillige for create schema, from the research gathered so far there’s clear indication that there should. What is the snytax for creating a new schema? The DBA isn’t that he can only create a user not a schema

Answer Question   |  September 1, 2005  5:16 AM
Database, DB2, Oracle

Moving Log Files in Oracle 9.2.0
Hi there i have 5 log groups in oracle 9.2.0. (running on win2k) my 3 log groups are all created under D: drive as i used oui to install my db. i had 16 hard disks,and the senior dba had asked me to move the 2 log groups to other hard disk. the configuration for [...]

Answer Question   |  September 1, 2005  8:32 PM
Database, DB2, Oracle

tuning
I have a program which is run on an ad-hoc basis….the database is mainly a read only dB, i.e. not much inserts/updates/deletes. The process basically reads tables, then creates temporary oracle tables, creates indices on these tables and then does some inserts. The temporary oracle tables are then dropped when the process in run the [...]

Answer Question   |  September 2, 2005  3:53 PM
Billing and customer care, Billing Support Systems, Data analysis, Database, DB2, Oracle

Help
What does “DOU” mean?

Answer Question   |  August 31, 2005  3:51 PM
AS/400, Avaya, Business Objects, Call Centers, Career development, Certifications, Cognos, Crystal Reports, Data analysis, Data Junction, Data mining/analysis, Database, DataCenter, Hyperion, IBM, Informatica, Information Builders, Microsoft Windows, NCR, Oracle, PeopleSoft, Sales force automation applications, Salesforce.com, SalesLogix, SAP, Siebel, Training

MS Access – AS400 file transfer
I am trying to move data from a .dbf file to the AS400. I have tried several differnet methods from access and none of them worked. I tried setting up an ODBC table pointing to the as400 and doing an update query and also an export. I could not get either of these to work. [...]

Answer Question   |  June 29, 2010  8:46 AM
Database, DB2, Oracle

Passing PL/SQL Table As Parameter.
Hi, I want to call the procedure returning PL/SQL table from java. What is the relevant datatype that can be used in java? Following is the code for the PL/SQL table procedure created – CREATE OR REPLACE PACKAGE test_plsqltable AS TYPE EmpTabTyp IS TABLE OF emp.empno%TYPE INDEX BY BINARY_INTEGER; PROCEDURE test_proc(t_no IN NUMBER, emp_tab OUT [...]

Answer Question   |  September 15, 2005  3:08 AM
Database, DB2, Development, Oracle

The UNIX Idiot
Hi everybody i’ll be attending the Oracle10g upgrade course @ Oracle Corporation next week. I need some help with UNIX commands that a DBA could use(i was trained in Win mode for Oracle). Just abt 5-10 will do, coz i just need to survive the 5-day course. The Senior DBA at my company suggest that [...]

Answer Question   |  August 29, 2005  9:45 PM
Database, DB2, Oracle

Convert cpu time into MIPS
How to convert cpu time into MIPS ? I would like to convert cpu time of A address space into MIPS. Thanks

Answer Question   |  November 17, 2010  2:54 AM
390, DB2, Mainframe

IT Security
Hi all, Thanks to all those who answered to my question”FTP sites” Can anyone of you let me know about the available products that we can use for our organisations IT security..Also let me know what products are available to find out vulnerabilities in a network. Appreciate your response. Thanks Tarang

Answer Question   |  August 27, 2005  6:03 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Certifications, Compliance, configuration, CRM, Current threats, Database, Desktops, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, OS, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

cics internet web interface question
Good day, We are in the process of changing the CICS internet login protocol from basic to form based authentication. This requires placing a token inside the HTML referencing the item ‘&QUERY_STRING’ as defined on page 80 of the CICS Internet Guide. Nothing is mentioned concerning the format of this. In searching the internet, I [...]

Answer Question   |  August 24, 2005  8:50 AM
390, DB2, HTML, Mainframe, zSeries

Implementing and configuring VPN Server
Hello, Shiraz, I want to implement n configure VPN Server, so that my mobiles users and employee can access there file and network through Securely VPN Connection. Can any body help me out of this.. I need complete n detailed about VPN Configurations. What Hardware n software do i need to have sucessfull VPN Configuration. [...]

Answer Question   |  August 22, 2005  12:49 PM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support

Installing Seperate Internet Connection for Managers
Hello, Myself shiraz, I got one problem. There are Five Floor in one Office which has Switches COnneted to each floor. They are getting LAN and WAN Connection through Centralized Wireless Server Room. Also We have access point to get connectivity from Head Office, which is just near to us. And that access point connected [...]

Answer Question   |  August 22, 2005  12:46 PM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support

Querying GIS Data
I have GIS dataset which i want to query for finding intersections. The data goes like this: ID Street1 Street2 Intersection 1 407 HWY 407 RAMP 407 HWY & 407 RAMP 2 407 HWY 410 HWY 407 HWY & 410 HWY 3 407 HWY 427 HWY 407 HWY & 427 HWY 5 407 RAMP 410 [...]

Answer Question   |  August 19, 2005  10:12 AM
Data analysis, Database, DB2, Development, Oracle, Software

CICS transaction paramter for lower case
Can you please tell me what parameter to set in order to allow a CICS transaction the use of lower-case letters?

Answer Question   |  August 18, 2005  2:12 PM
390, DB2, Development, Mainframe