• 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:
  • Flashback query

    Background: Oracle 9.2.0 running on win2003 I have enabled UNTO_RETENTION = 36000 (10 hours). I executed the dbms package using userid = SYSTEM EXECUTE DBMS_FLASHBACK.ENABLE_AT_TIME(SYSDATE - 10/24); I got the error message "SYS.DBMS_FLASHBACK not enabled for user sys" Why is Oracle giving me this...

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

    OnlineTechSupport0 pointsBadges:
  • Library management system

    i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse

    Eduado0 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:
  • Oracle Foreign Keys to Drop

    I have a problem where I need to drop certain tables and Create replacements (schema additions/deletions to the tables). Because I have Grandfather-Father-Son table type relationships I have Foreign Keys between them. I need to drop the Foreign Keys but if I build a script to SELECT "ALTER TABLE...

    NigelT0 pointsBadges:
  • Fields indexing

    Topic: SQL Question: My question is regarding fields indexing. My table named' K5Details' contains about 200,000 records and the response time to access this table is quite slow. What is the best way to index this table in order to get better response time To this table, I've created few indexes....

    Azizah0 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:

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