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

Answer Question   |  September 15, 2005  1:11 AM
Database, DB2, Oracle

blocking session
hi i am new to oracle and i have a question that if a user session that is blocking other sessions and processes from accessing the oracle database so how we can overcome this problem?Could you please explain with example by using a sql command if you can. Would really appreciate. Regards Obaid

Answer Question   |  October 12, 2005  4:28 PM
Oracle

Locally-managed tablespaces (LMTS) in SAP
Hi, I am working towards reorganizing most of my Production system tablespaces and I’m facing some issues due to the move from sapdba to brtools/brspace. SAP is recommending the use of BRSPACE for most of the DB admin tasks. While testing some reorganizations in my test box I noticed that BRSPACE is pushing me to [...]

Answer Question   |  December 13, 2010  4:08 PM
Basis, Oracle

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.

Answer Question   |  September 12, 2005  9:55 AM
Oracle

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

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
hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

Answer Question   |  September 10, 2010  3:39 PM
ABAP, ActiveX, ADA, AppleScript, ASP, ASP.NET, BASIC, Billing and customer care, Billing Support Systems, C, CGI, COBOL, ColdFusion, Computer Associates, Delphi, Development, Distribution/logistics applications, Enterprise Desktop, Forth, Fortran, HTML, J#, J2EE, Java, JavaScript, JSP, Linux, Lotus Domino, LotusScript, Microsoft Windows, MySQL, Networking, Oracle, Pascal, Perl, PHP, Platform Issues, PowerBuilder, Programming Languages, Python, REXX, RPG, Ruby, Smalltalk, Software Quality Assurance, Software testing, SQL, T-SQL, Tcl-Tkl, VB.NET, VBA, VBScript, Visual Basic, XML

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 [...]

Answer Question   |  September 3, 2005  7:59 AM
Oracle

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

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

Answer Question   |  August 31, 2005  8:31 AM
Oracle

oracle cold backup 8.1.7.4 restore to oracle8.1.7.4 Can it be done.
Please advise if I can take a cold backup from oracle 8.1.7.2 and restore onto oracle 8.1.7.4 binaries thanks

Answer Question   |  February 3, 2009  4:03 PM
Oracle 8, Oracle backup, Oracle Cold Backup

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

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 [...]

Answer Question   |  August 31, 2005  12:00 PM
Oracle

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

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

Answer Question   |  August 31, 2005  3:45 AM
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