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.
mrongAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I'm not sure I understand what you are asking.

Tablespaces don't have a 'path'.

Tablespaces have one or more datafiles associated with them and the datafiles have a 'path' on the OS but you cannot specify which datafile the data goes into.

Tablespaces are database objects.  You just need to know the from and to tablespace.  You don't need to care about the data file when it comes to data in the tablespace.
0
mrongAuthor Commented:
I want to know how to get the path of the datafile. thanks.
0
mrongAuthor Commented:
like source table space(datafilepath): /oracle/oradata/MAX/ud1/dataMAX.dbf
where is it located on the linux server?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

johnsoneSenior Oracle DBACommented:
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.
0
mrongAuthor Commented:
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
0
johnsoneSenior Oracle DBACommented:
It is not asking for the path.  It is asking for the tablespace name.  A tablespace can have many datafiles.

Here is the documentation for that parameter -> https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#SUTIL929

Notice the example, it shows tablespace names, not data files.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mrongAuthor Commented:
Ok, so if both source and destination tablespace is MAX. Just put MAX in the box?
Thanks.
0
johnsoneSenior Oracle DBACommented:
If the tablespace name is the same, you should be able to leave both boxes empty.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.