Solved

Re-Map Tablespaces in Oracle Enterprise manager 11g

Posted on 2014-11-15
8
388 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
  • 4
  • 3
8 Comments
 
LVL 76

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
 
LVL 34

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 34

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 34

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now