Migrating data from 10g 32-Bit to 11g 64-Bit
Hi all,
I have an Oracle database 10gR2 Release 10.2.0.4.0 on RHEL 4 (32-Bit). This is a consolidated database and is used for reporting purpose only i.e. no insertion, updating or deletion. I get new server and want to shift all data of a schema to new server where Oracle database 11gR2 Release 11.2.0.3.0 (64-Bit) is installed on RHEL 5 (64-Bit). I also have BLOBs in one table. Estimated size of them is:
select sum(bytes / (1024*1024)) "DB Size in MB" from dba_data_files where TABLESPACE_NAME like '<blob_tablespace>';
DB Size in MB
-------------
2221300
and size of remaining data files is:
I have an Oracle database 10gR2 Release 10.2.0.4.0 on RHEL 4 (32-Bit). This is a consolidated database and is used for reporting purpose only i.e. no insertion, updating or deletion. I get new server and want to shift all data of a schema to new server where Oracle database 11gR2 Release 11.2.0.3.0 (64-Bit) is installed on RHEL 5 (64-Bit). I also have BLOBs in one table. Estimated size of them is:
select sum(bytes / (1024*1024)) "DB Size in MB" from dba_data_files where TABLESPACE_NAME like '<blob_tablespace>';
DB Size in MB
-------------
2221300
and size of remaining data files is:
0