rdbms and dbms
what is rdbms and dbms in oracle?

Answer Question   |  April 6, 2009  6:51 PM
DBMS, Oracle 9i, RDBMS

Oracle 9i: jrew.exe
while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows vista)

Answer Question   |  April 12, 2011  4:54 PM
Oracle 9i, Oracle error messages, Oracle installation, Windows XP

oracle9i
i want to learn the oracle9i for get the job of DBA .for that what website i have to go?

Answer Question   |  March 30, 2009  1:22 PM
DBA, DBA training, IT careers, Oracle 9i

How to connect Oracle 9i to Visual Basic by ODBC?
how to connect oracle9i to vb6 by odbc? plese provide me code also?

Answer Question   |  April 1, 2009  12:45 PM
ODBC, Open Database Connectivity, Oracle 9i, Oracle connectivity, VB 6, Visual Basic 6

NEED HELP to DETERMINE STEPS to TAKE when going from 9i to 10g in terms of plsql best practices as well as known issues to watchout for
Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3) known issues with plsql 4) [...]

Answer Question   |  March 25, 2009  4:06 PM
Oracle 10g, Oracle 9i, Oracle 9i to 10g Upgrade, PL/SQL

memory space
what queries for get the details of memory space in database?

Answer Question   |  March 23, 2009  12:56 PM
Oracle 9i, Oracle Database, Oracle Database Memory

ORA-01033: Oracle initialization or shutdown in progress
most of our databases are on Oracle 9i. Suddenly i’m not able to start oracle or use any application that uses oracle, though all related services are working. i’m getting the error : ora-01033 oracle initialization or shutdown in progress i tryed to connect as sysdba but the user i’ve been given the password has [...]

Answer Question   |  March 20, 2009  9:49 AM
ORA-01033, Oracle 9i, Oracle 9i error messages, SYSDBA

Oracle 9i to Oracle 10g Upgrade – Help needed for some PL/SQL errors
We are doing a Database server upgrade from Oracle 9i to Oracle 10g. As a part of this upgrade activity, I got in total three different PL-SQL Errors for which I had to make code changes in the database server. These errors were: (1) PLS-00371: at most one declaration for “string” is permitted. (2) PLS-00593: [...]

Answer Question   |  March 18, 2009  7:51 PM
Oracle 10g, Oracle 9i, Oracle 9i to 10g Upgrade, Oracle upgrades

What am I doing wrong. Please Help
An unhandled exception of type ‘Oracle.DataAccess.Client.OracleException’ occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _ OracleConnection(“User Id=system;Password=dax856;Data Source=DMS”) Dim objDataAdapter As New OracleDataAdapter Dim objDataSet As DataSet = New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles [...]

Answer Question   |  March 10, 2009  1:45 PM
Oracle 9i, Oracle Data Access, Oracle Database, Oracle error messages

.NET connecting to Oracle 9i
Please Help. I am new to .Net. Using .Net 2003 Oracle 9i Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _ OracleConnection(“User Id=system;Password=dax856;Data Source=DMS”) Dim objDataAdapter As New OracleDataAdapter Dim objDataSet As DataSet = New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ‘ Set [...]

Answer Question   |  March 9, 2009  12:57 AM
.NET, .NET development, Oracle 9i, Oracle 9i Enterprise Edition 9.2.0.7.0, Oracle connectivity, Oracle development, Visual Studio 2003

Hiding a stacked canvas in Oracle 9i
how to hide the stacked cancas using a code in the oracle9i? i call the stacked using the form so the problem now is what code am i going to use to hide it in runtime! so that the user input will be on the content canvas and the stacked canvas will not be visible [...]

Answer Question   |  March 12, 2009  4:55 PM
Oracle 9i, Oracle 9i Canvas, Oracle development, Oracle Forms Canvas, Stacked Canvas

Finding the number of rows of all tables of a user/schema in Oracle
how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ……

Answer Question   |  February 23, 2009  7:16 PM
Oracle 9i, Oracle SQL, ROWCOUNT statement, SQL, SQL queries

ProC under Oracle 10g
Hi! I have a piece of code in Pro-C that’s been running under Oracle 9i for several years. I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty [...]

Answer Question   |  February 26, 2009  2:31 PM
Oracle 10g, Oracle 9i, ProC, SQLPlus

concatenating rows of a column in oracle 9i sql
how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

Answer Question   |  February 16, 2009  10:17 PM
Concatenate, Oracle 9i, Oracle SQL

BACKUP & RECOVERY for Oracle 9i
How can i take a backup of my database through OEM ? PLZ reply ASAP

Answer Question   |  January 8, 2009  1:20 PM
Backup, Backup & recovery, Oracle 9i, Oracle backup

VC++: int keyword gives different results in Oracle 9i and 10g
In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, [...]

Answer Question   |  December 24, 2008  9:09 AM
Data Type behaviour, int keyword, Integer variable, NUMBER datatype, Oracle 10g, Oracle 9i, Oracle development, Variables, VC++, Visual C++, Visual C++ 6.0

How do I connect Developer 2000 on one computer to Oracle 9i personal addition on another XP machine
how to connect d2k with 9i from other machine

Answer Question   |  December 18, 2008  10:11 AM
Developer 2000, Oracle 9i, Oracle 9i Personal Edition, Oracle Developer 2000, Oracle Developer Suite, Oracle interoperability, Windows XP

oraoledb non working WHERE clause character comparison
Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

Answer Question   |  December 11, 2008  1:47 PM
Oracle 10g, Oracle 9i, OraOLEDB, OraOLEDB.Oracle, SUBSTR, WHERE statement

run oracle 9i with Windows Server 2003 Domain Controller
sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL. what [...]

Answer Question   |  December 4, 2008  5:58 AM
Domain Controller, Oracle 9i, Oracle 9i installation, Oracle installation, Oracle SQL, SQL, Windows Server 2003, Windows Server 2003 Domain Controller, Windows XP

Oracle ERP single signon using Active Directory
We are on Oracle 9i and will like to implement a solution to allow Oracle ERP users to signon using Microsoft Active Directory. Thanks Thanks

Answer Question   |  December 3, 2008  9:46 AM
Access control, Active Directory, Authentication, Oracle 9i, Oracle applications, Oracle ERP, Single sign-on, User authentication