Solved

Can I clone a Tablespace from one Database into another without using Import?

Posted on 2006-11-17
3
257 Views
Last Modified: 2013-12-11
Hi All, this should be easy. I've know about cloning Databases, but can you clone a Tablespace from one Database to another? The reason I ask is that I have a critical path that requires us to Import a 100+ million row table and Index rebuilds that take over 3 hours.

If cloning this physical Datafile(Tablespace) is possible and both Databases use the same Schema name and Db object name what are the steps so that I can create an environment to test this out.

Again thanks,
7Souls
0
Comment
Question by:7Souls
[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
3 Comments
 
LVL 18

Accepted Solution

by:
rbrooker earned 500 total points
ID: 17981320
Hi,

investigate transportable tablespaces.  using oracle exp, you can export the metadata about a tablespace and import that metadata into another database.
steps :

1. mark tablespace as readonly
2. export the tablespace as a transportable tablespace
3. copy the tablespace to the destination database
4. mark the original tablespace read/write
5. import the tablespace into the destination database

this will be a quicker transfer of the objects than using dblinks / copy command and import / export.

good luck :)
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

622 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