Oracle 11g

Flash Recovery Area in Oracle 11g

What is the easiest way to handle the flash recovery area in Oracle? I'm having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind after the...

MERGE using DECODE logic to control UPDATE

MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...

Oracle Report 6i and Oracle 11g database

I have oracle 6i report under oracle 9i database.Now database is upgraded from 9i to 11g. So if I try to compile a report 6i under oracle 11g database then which kind of error might raised?

ORA-31672 in oracle 11g

Getting Oracle Database Error Code ORA-31672 Worker process string died unexpectedly. Any quick fixes Software/Hardware used: Oracle 11g

Oracle Migration 9 to 11g grants missing

a user get the 'table or view does not exist' error after migration from Oracle 9 to 11g - even though in the DD I can see owner grants select on the tables to role -> role is granted to the user (only grants direct to user are working fine) Software/Hardware used: Oracle 11g

connect remote oracle 11g server in VB6.0

how to connect remote oracle 11g server in vb6.0 without installing oracle client in local machine Software/Hardware used: Oracle 11g, VB6

SQL loader

Like to hear best practices to be followed to increase performance of SQL loader. Software/Hardware used: Oracle Datbase 11G

Benefits of Oracle database 10g vs. 11g editions?

benefits of oracle 11 g edition over oracle 10 g express edition????

Is there any compatibility in migrating from Delphi 6.0 to Oracle 11g?

When migrating from Delphi 6.0 to Oracle 11g, are there any compatibility? If yes, what are they?

How to Migrate Oracle 10g forms in Oracle 11g

How to Migrate Oracle 10g forms in Oracle 11g

TableAdapterManager contains no connection information. Set each TableAdapterManager TableAdapter property to a valid TableAdapter instance.

I am very new to oracle. I was able to install it and was trying the tutorial: Building .NET Applications Using Oracle Developer Tools for Visual Studio. I am using Windows XP sp3 and Visual Studio 2008 Professional. I was working on the tutorial that came with the Oracle Data Access Components...

I am not getting source of oracle.I searched a lot but was not able to get it from anywhere.Plz help me.

And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only

"Oracle Client 11.1.0.6.0" Installation stuck at 33%

While installing oracle 11g client version of 11.1.0.6.0, I am unable to proceed. In "Oracle Universal Installer Window", the status of installation is stuck at 33% for many hours, it is not proceeding. Please Help

How to connect Visual Basic 6 to Oracle 11g

how to connect vb6.0 to oracle11g ?? what are the steps??

Oracle Communication between 11g and 8i

We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is...

Oracle Forms 6i and Oracle 11g database - Multilingual I18N

HI, We have Forms 6i, we are going for Multilingual, and it has Oracle 11g db. We are updating the database with one more column in an exiting table with NVarchar2. The approach we are going for Column level Character set Updates. One more approach is Full Database level Character Set. I...

Oracle OLAP degenerate dimension

HI, HI, Say, I want to create a data mart for sales Dimension: region,products Degenerate dimension: Order Number Measures: price,quantity Qyery: cross product A region B show order numbers where total quantity sold is more than 100000 How to achive this Oracle(11g) AWM or any other tool? How...

Error when running any program in Oracle JDeveloper 11g

Error occurred during initialization of VM Could not reserve enough space for object heap kindly give me an idea to solve this problem. thanks in advance

ADO connection fails after upgrading from Oracle 10g to Oracle 11g

I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property 'SERVER' returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

Oracle Enterprise Manager login password error

We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on "google", solution was "ocijdbc10 file has...