• 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:
  • 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:
  • About checkpoint

    What is incremental chekpoint , partial chekpoint and full checkpoint. Can u tell me the user of fast_start_Mttr target when chekpoint is occuring at each 3second.

    Rajukumar0 pointsBadges:
  • Restoring patch from to 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 only. Will this work? Does the patch upgrade change header information, and oracle dictionary. If this is the case, then binary...

    Dannyl0 pointsBadges:
  • Oracle optimizer cost based?

    Greetings, I am very new to Oracle and am having issues with Oracles cost based optimizer. To be honest from what I am seeing it is horrible. We are having to use way to many hints such a rule and index in order to get queries to run in a decent amount of time. I have updated the stats on all...

    Hayden10 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:
  • Allow users to kill their own Oracle Sessions

    I'm trying to find the best way to allow an Oracle 8i and 9i (running in True64 Unix) SQL Plus user who is not a DBA to kill his/her own session(s). I don't want to give the user the alter system privilege, just the ability to kill sessions running with his/her user id. I know how to find session...

    Stevewaltz0 pointsBadges:
  • Oracle / ccess

    How does one setup a link between oracle and acess database. I have been able to setup it up from acess to oracle using ODBC

    Mnm1870 pointsBadges:
  • Help

    What does "DOU" mean?

    Daniellem0 pointsBadges:
  • Utility for copying tables w/constraints and indexes?

    Hi, I think I read somewhere about a script for copying tables *with all constraints and indexes*. Does anyone know of such a thing? Thanks, Kai Quale University of Oslo

    ActorJack0 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:
  • IMP / EXP statements from DOS prompt

    Hello All, EXP / IMP commands cannot be run from DOS prompt. The error message says that the command is not valid. Checking with Microsoft's website says that this is by design for systems that were upgraded to Windows 2000 from NT or 95. Could you suggest a surefire workaround for that? It's not...

    Baburamkumar0 pointsBadges:
  • Export/Import schemas

    I had this issue. Everytime a user resigns, i had to export his schemas and import it into another user who is taking over his duties. Q1: Can i use import/export utilities to specify different schemas under oracle 9.2.0? How? Q2: Do i need to give authority/? to allow the new user, user2, to use...

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

    OnlineTechSupport0 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.