• Role Maintenance

    Background: oracle 9.2.0 running on win2k I got 2 logical userids A) OPTELADMIN --given RESOURCE, CONNECT roles and owned all the user created objects such as tables, indexes, sequences, etc. This userid is shared by 3 physical developers B) OPTEL --given CONNECT,CREATE SYNONYM roles and physically...

    Mayleong0 pointsBadges:
  • Network neigbhorhood

    Sir, I have a windows 2K advanced server running on HP Proliant ML350 G3. The problem is my network neighborhood does not open quickly. Same problem with control panel. It take a long time to open maybe 45 mins to 1 hour. I have uninstalled all the HP tools but installation takes place only through...

    Msat18750 pointsBadges:
  • Mainframe Testing Tools

    My shop is currently looking for testing packages for batch (mostly cobol, some assembler) applications as well as our online CICS applications. We are z/OS shop using IMS and a very limited amount of DB2. We are looking at CA-InterTest, Xpediter, and SmartTest. In addition to the usual testing and...

    Girlnerd0 pointsBadges:
  • Oracle

    Dear all i am new to Oracle and never used please let me inform what is the best one out of the products of Oracle to learn first Thanks R. Rathnayake

    SriLankaArmyDPO0 pointsBadges:
  • 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;...

    Techanalyst100 pointsBadges:
  • 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...

    Avishek0 pointsBadges:
  • 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...

    Dannyl0 pointsBadges:
  • 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...

    Fitzdp0 pointsBadges:
  • 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

    Mnm1870 pointsBadges:
  • 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...

    Bkr0963c0 pointsBadges:
  • 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 my log groups (each w 3 mbrs) are as...

    Mayleong0 pointsBadges:
  • 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 i...

    Mayleong0 pointsBadges:
  • 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...

    Jeffer0 pointsBadges:
  • 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 HWY 407 RAMP & 410 HWY 6 407 RAMP AIRPORT RD 407...

    RPandya0 pointsBadges:
  • 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?

    MartyP0 pointsBadges:
  • Extracting SAP R3 data in custom DW

    We are in the process of building a custom data warehouse (SQL with Business Objects Universe for reporting) - this is continuing the existing company strategy. The difference this time is that we need to extract data from SAP R3 to feed into the warehouse. What I'm not sure about is the best...

    Jroth730 pointsBadges:
  • ASE Trigger

    select @command = 'INSERT INTO tablename SELECT * FROM inserted' execute(@command) Hi all, i am building a dynamic SQL Command inside a trigger, i received an error message that table inserted is not found. (i am using ASE 12.5.1) thanks,

    Ghassanhaith0 pointsBadges:
  • Unable to create new records in other database using local form (writing background agent)

    Hi, I am trying to create an agent in a database that creates a new document in the local address book using its local form (Person). Debug shows that all is fine except that it does not save (the flag value is -1). What am I missing? Here is my code: Sub Initialize Dim s As NotesSession Dim...

    Arnaud660 pointsBadges:
  • Should you ever consider creating a fresh database for a user’s e-mail?

    On our Domino server, there is one mailbox that keeps generating errors. It is flagged in STATREP.nsf daily because documents can't be created or mail rules are problematic. I am unable to view the Rules in the database, and in Domino Administrator, it's the only mail file that doesn't show a...

    DKoch675 pointsBadges:
  • Secure File Transfer for Mainframe systems

    I would like to transfer files from Unix machine to Mainframe system (using Unix machine as client). The transfer process need to be secure (ie. data sent thro network should be encrypted using 128-bit encryption algorithm). I came to understand that SFTP server is not available for Mainframe...

    Tsdnesh0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following