Oracle 10g

upgrading oracle 8i to 10gR2 with 3.5TB database size

sirs, what is the best way to migrate a 3.5TB database from oracle 8i to 10gR2 on the same machine? the OS is AIX L5, with 10TB storage size

Help with new installation of SAP CRM and supporting software

We are going to Install SAP CRM 5.0 with Microsoft SQL Server 2005 and ECC 6.0 with Oracle 10g and integrate these with each other and also with QAS (Third Party tool). My question are: 1. Can we install all three applications on one single server as database is different or will there be issues...

10g App Srvr vs. SOA

If I have Oracle 10g App Srvr why would I really need SOA? Doesn't the App Srvr provide some of the same features SOA does?

data from oracle 10g to oracle 8i

Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object

table storing in oracle 10g

where does create table get stored in oracle 10g

Conversion or Migration from Oracle 9i to Oracle 10g database on Windows 2003 64 bit

Hi, Currently, I am using Oracle 9i (version 9.0.1.1) database now as per my business requirement, I need to upgrade it to Oracle 10g database. It has several database procedures and triggers stored with it. Operating System : Windows 2003 Server, 64 Bit I am looking for some help on this, what...

Oracle 10g Clone Database

Can anybody please give detail steps how to clone a database(created in Oracle 10g)by hot backup?

Oracle 10g Certification

I am interested in pursuing my Oracle certification, but I'm not sure of the best way to proceed. For those of you who have recently completed your OCP, could you help me by answering the following questions? Is it better to get my 10g OCP now and take the upgrade exam for 11g later, or begin...

Using Oracle 10g Stored proc in SSRS 2005

I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run...

Oracle 10g Standby Database not opening readonly

Hiii, I have created Oracle 10g Primary database where control file locations are as follows: *control_files='P:\oracle\product\10.1.0\oradata\tceng\control01.ctl','C:\oradata\tceng\control02.ct l','E:\oradata\tceng\control03.ctl' Then I have created standby database in standby server where the...

Not able to set preferred credentials on OEM console

using Oracle 10gR2 on Windows 2003 server. I can't setup the preferred credentials on the Job scheduler screen on the console. I also have the email issue. I tried to use DBCA and clicked on database options and everything is greyed out and I cant seem to proceed. How can I configure to receive...

VB.NET ans ORACLE database

Hi all. I know, that there is a big risk of asking a silly question, but I try to connect to a ORACLE 10g database witch MS Visual Basic 2005 Express Edition and all programming examples I found do not work. Is this a configuration that does not work? Or what software do I need exactly? What should...

Oracle 11g RAC on HP C3000 blade with Bl460c servers using SB40c as storage

Has anyone built a oracle 11g or 10g RAC on HP Blade C3000. A typical setup could be 4 X Bl460c blade servers using 4 X SB40c storage blade ( giving 24 X 146 GB SAS drives ). Both the blade servers and storage will fit in the same blade enclosure. OS could be oracle enterprise Linux The advantages...

Is it possible to install multiple Oracle 10g instances from one installation?

I would like to know if it is possible to install multiple Oracle 10g instances from one installation, or if we have to run the installer every time to create a new instance. If it is possible, how is it done?

BLOB Data move from Oracle 9i to Oracle 10g

I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

i need help urgently

hello fellow IT friends,i just installed oracle10g on window xp, and i cant seem to open my enterprise manager.am a new user of this software can someone help me?

trying to install oracle 10g

I'M TRYING TO INSTALL ORACLE 1OG ON AN ACER 5520-5334 COMPUTER AND IT HAS BEEN GIVING ME A PARTICULAR ERROR 'NO VALID DEVICES FOUND ....... etc. from my research it seemed like the versions of red hat os ( rhel 3.0,4.0) were not compatible with my computer. pls can any one give me advice on what...

How to import .doc files into Oracle 10g

I am using Oracle 10g, and i have around 500 tables sitting in .doc file. How can i import those tables into Oracle 10g. Please help me out with this issue.

What more do I need to do to get instant client working with IIS?

I have installed instant client on my XP computer and am able to connect to a remote Oracle 10g server with SQL plus using this string: sqlplus myid/mypassword@//server:port/svc I have also been able to make a DSN file that connects, and have been able to connect with Visual Basic. I HAVE NOT...

About oracle editions

i would like to install oracle 10g in personal desktop,but i saw in oracle site 10g express edition,standard edition and enterprize edition.what was the differences between them and if i want to install which one better?