Copying a table space (datafiles) from file system to ASM
Hi
We have a 2 node 9i RAC (9.2.0.7) database on windows 32 bit O/S. It has a table space 'APPS_DATA' which is on OCFS2
The table space is appx 80 GB in size
We have a requirement to copy that table space to a remote location where we have a 11g R2 2 node RAC database (running on Windows 2003 x64) on +DATA ASM disk group
What we are looking for is the fastest way to copy the contents of APPS_DATA table space from 9i database (file system is OCFS) to 11g database on ASM file system
Can someone please identify the instructions on how to do that?
We have a 2 node 9i RAC (9.2.0.7) database on windows 32 bit O/S. It has a table space 'APPS_DATA' which is on OCFS2
The table space is appx 80 GB in size
We have a requirement to copy that table space to a remote location where we have a 11g R2 2 node RAC database (running on Windows 2003 x64) on +DATA ASM disk group
What we are looking for is the fastest way to copy the contents of APPS_DATA table space from 9i database (file system is OCFS) to 11g database on ASM file system
Can someone please identify the instructions on how to do that?
0