Avatar of mrong
mrong
 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.
Oracle DatabaseLinux

Avatar of undefined
Last Comment
johnsone

8/22/2022 - Mon
SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.