Oracle Migration

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

oracle 10g database migration

Hi Exprts, we migrated a database in terabytes in size in Oracle 10 g using data pump it took 10 hrs for export and 46 hrs to import i am sure this is not the efficient method can you please suggest wat possiblities there to improve the export/import to happen fast for such huge sized databases

Oracle installation and migration between versions in Linux

Hi Experts, I need some useful doc links or step by step procedure to perform oracle installation and migration in Linux environment I surfed thru net ,cud not find any good docs or pdf on this As i am new to explore this role,can any one provide me some useful related links

Oracle 9i migration

How to migrate Oracle 9i from Windows 2000 server to Solaris and vice-versa?

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

How can we migrate Oracle database to Microsoft Access?

oracle to ms access

Best practices for migrating Oracle 6i to Oracle 10g

my company need to migrate oracle 6i to oracle 10g i need to know what is the steps and the recommendation to do that

Oracle 10g Reports not running

Hi Gurus, We are trying to migrate from form and reports 4.5 to 10g and while migrating them we were able to find the way to work with forms 10g but not with reports 10g from within forms. can any one give me the procedure to make reports 10g to work within forms . with example please.

DB2/400 to Oracle 10g

I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle...

migration How to migrate from oracle 10g to Hp unix?

How to migrate from oracle 10g to Hp unix?

Oracle Upgrade

I want to upgrade oracle 8i to 11g on solaris10. What will be the best way to do it. I really appreciate your help.

Migrating from Sybase to Oracle 10g

I know the a little more than the basics of DBing but not as much as an OCA or OCP. I need to know how to migrate data over from Sybase to Oracle 10g on a very large scale! Please help! I do not want to use a conversion software because there are many updates to the Oracle architechture already....

Transfer Oracle database

hi,i wanna transfer my oracle database like tables from one server to another server using export and import command.

Error when translating execute immediate from Oracle to SQL

SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* ...

Oracle to SQL Server Migration - User Defined data types

Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

ORA-27101 error when migrating Oracle 9i to AD domain

We are running Oracle 9 on a Windows 2003 box. We moved the server from a Windows domain to an AD domain. We then get an error messages looking like this: ORACLE not available ORA-27101 When we back out of the changes, everything works fine again. Any ideas? Thank you.

Migration from Oracle 8 to Oracle 10g

I have a database of 80MB in Oracle 8 and want to migate to 10g. OS is Solaris. Pl guide ?

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

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

What's the best way to import an Oracle database?

I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each...