Database - RAC/Scalability (MOSC)

MOSC Banner

Using Transportable Tablespace on 2 node 11g RAC

edited Jul 27, 2010 3:38AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered
Hi
 
we are trying to move a table space from db# 1 to db#2 using transportable table space option

db# 1 is Oracle 9i using the file system
Tablespace name is APPS
The datafile is "d:\oracle\oradata\orcl\apps01.dbf"

db#2 is using ASM. It is 2 node RAC 11g R2 on Windows X64

Now after we exported the meta data of APPS tablespace (using exp),we copied the
resultant export file (dmp file) to C drive on one of the nodes so that we can run the imp on the target database

Now the next step is to copy the "d:\oracle\oradata\orcl\apps01.dbf" file from the source database server

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center