Oracle 9i

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

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

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??

BACKUP & RECOVERY for Oracle 9i

How can i take a backup of my database through OEM ? PLZ reply ASAP

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, any...

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

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.

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

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

Plz tell something about FILE AUTHENTICATION

How can we set up a file authentication in oracle9i?

rep-002

I am getting error "rep-002:Unable to retrieve a string from the report builder message file " while opening a existing report in Reports 9i...How to solve this?

Oracle9i Performance Issue

I got Oracle9i R2 database running on windows 2003. On a very busy day I got very bad performance with Average Disk Queue Length very high on the performance monitor. There is heaps of free RAM and I am running Raid 10. I am still new to Oracle, so I need some help. Thanks and regards.

Database Oracle

hi please answer the question how to create database in oracle9 and link the database in sqlserver 2000 table in oracle and table in sql

Oracle 9iAS Components

I have a Oracle9i AS release 1 server. how can I find out what components installed on this server? it was installed by someone ages ago. thanks and regards.

Linking sqlserver to oracle

How do I create a link to oracle 9i form sqlserver I can tnsping oracle, I can connect via sqlplus, I can connect in odbc admin, I can connect via a udl, I can connect via ssis but I get ORA-12154: TNS:could not resolve the connect identifier specified when I try to set up a link in the management...

Insert superscript text into Oracle database

how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object

when i am migrating data from oracle9i to SQL2005 i am getting the error Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object how should i solve the problem

Monitoring Object changes in Oracle

I have to find out who modified objects in dba_objects each week for those changed during that week for SOX perspective. Right now i check with deveplopers for each one, which they don't like. I question is how to find out who modified an object in 9i or 10g (and 11i)?

oracle 9i instalation

hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal oracle7 I installed and used to do my practice...but now I have heard that you can install 9i on...

how i will find the duplicate rows count from employee table in oracle9i.

how i will find the duplicate rows count from employee table in oracle9i.