Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to copy a tablespace?

Re: How to copy a tablespace?

From: <frank.van.bortel_at_gmail.com>
Date: 30 Mar 2006 01:58:45 -0800
Message-ID: <1143712725.482359.98230@g10g2000cwb.googlegroups.com>


You cannot move tablespaces, as a tablespace is a logical unit. It comprises of datafiles - the physical implementation of tablespace. And users do not own tablespaces, so moving a tablespace from user to user is nonsense. You Grant users the prvilege to access objects, possibly stored in that tablespace.

Look at transportable tablespaces - yet you cannot rename them. Transportable ts uses exp/imp for the metadata only; you physically copy the datafile(s), belonging to the tablespace. As you indicate you are new in this field, I'd like to advise you call in your DBA to archieve this.
Using exp/imp without transportable tablespaces reuires to find out what objects are stored in that tablespace, and name them all in the tables=(...) section of your export command. Then use imp fromuser=a touser=b

Next time, just (have 'em) name the ts user_data on both instances... Received on Thu Mar 30 2006 - 03:58:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US