asked on

Re-Map Tablespaces in Oracle Enterprise manager 11g

Greeting,
There is data import feature in Oracle em 11g. In Re-Map Tablespaces, You put Source Tablespace and Destination Tablespace. where to get the path for source and Destination Tablespace?
Thanks.

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mrong

ASKER

I want to know how to get the path of the datafile. thanks.

mrong

ASKER

like source table space(datafilepath): /oracle/oradata/MAX/ud1/dataMAX.dbf
where is it located on the linux server?

johnsone

The information that the import process is looking for is the tablespace name, not the data file path. I'm pretty sure that if you gave it the path name of a data file it would give you an error.

However, if you want to know what file(s) are within a tablespace, this should work:

select filename
from dba_data_files
where tablespace_name = 'TBS1';

Replace TBS1 with the name of your tablespace.

mrong

ASKER

The only reason I asked this is because the oem asks during import(re-map table space). Please see attached screenshot.

I tried your command and it gave me the path of datafile for the destination tablespace. what about the path of the datafile for source tablespace? Thanks.
remap-tablespace.JPG

ASKER CERTIFIED SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mrong

ASKER

Ok, so if both source and destination tablespace is MAX. Just put MAX in the box?
Thanks.

johnsone

If the tablespace name is the same, you should be able to leave both boxes empty.