How to copy a tablespace?

From: "Einar" <einar.dahle@xxxxxxxxxxxxxxxxxxx>
Date: Thu, 30 Mar 2006 11:30:28 +0200

Hi!

I want to move a tablespace from one instance to another, they have
different names.

Ex: user test_user with tablespace test_user_data, want to move this to user
prod_user with tablespace prod_user_data.
Is it possible with exp - imp ?

Have in mind that I'm a newbie, maybe this is a stupid question ;-)

Thanks for all help!

Einar

.

Follow-Ups:
- Re: How to copy a tablespace?
  - From: frank.van.bortel@xxxxxxxxx

Prev by Date: Re: inexpensive SAN for Linux 10gR2 RAC
Next by Date: Re: How to copy a tablespace?
Previous by thread: how to know contents of blob column
Next by thread: Re: How to copy a tablespace?
Index(es):
- Date
- Thread

Relevant Pages

Re: What is different b/w exp tablespace and exp user
... If I export full tablespace with the command ... and then imp in other database ... exp userid=system/manage tablespaces=users ...
(comp.databases.oracle.server)
Re: What is different b/w exp tablespace and exp user
... If I export full tablespace with the command ... and then imp in other database ... exp userid=system/manage tablespaces=users ...
(comp.databases.oracle.server)
What is different b/w exp tablespace and exp user
... If I export full tablespace with the command ... and then imp in other database ... exp userid=system/manage tablespaces=users ...
(comp.databases.oracle.server)
Re: What is different b/w exp tablespace and exp user
... If I export full tablespace with the command ... and then imp in other database ... exp userid=system/manage tablespaces=users ...
(comp.databases.oracle.server)
Re: EXP/IMP to a different tablespace: has anyone been able to solve this?
... go back to the src_tablepace (original user's tablespace data was ... all tablespaces before imp and then renaming them back after imp? ... Senior Oracle DBA- Hide quoted text - ... The show or indexfile options of imp can be used to generate table and ...
(comp.databases.oracle.server)