Solved

Re-Map Tablespaces in Oracle Enterprise manager 11g

Posted on 2014-11-15
8
411 Views
Last Modified: 2014-11-16
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.
0
Comment
Question by:mrong
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 200 total points
ID: 40445065
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
 

Author Comment

by:mrong
ID: 40445091
I want to know how to get the path of the datafile. thanks.
0
 

Author Comment

by:mrong
ID: 40445096
like source table space(datafilepath): /oracle/oradata/MAX/ud1/dataMAX.dbf
where is it located on the linux server?
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 35

Expert Comment

by:johnsone
ID: 40445629
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
 

Author Comment

by:mrong
ID: 40445681
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
 
LVL 35

Accepted Solution

by:
johnsone earned 300 total points
ID: 40445778
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
 

Author Comment

by:mrong
ID: 40445786
Ok, so if both source and destination tablespace is MAX. Just put MAX in the box?
Thanks.
0
 
LVL 35

Expert Comment

by:johnsone
ID: 40445834
If the tablespace name is the same, you should be able to leave both boxes empty.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Fine Tune your automatic Updates for Ubuntu / Debian
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question