Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2006-11-17
3
Medium Priority
?
259 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 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

715 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