Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to copy a tablespace?
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