add tablespace

[sunilvmahanti]

Hi,

thanq 4 the help, giv me one example to add tablespace in one db to another db(either tronsportable or import export).

plz help,

regards

sunil

[davey23uk]

look up transportable tablespaces in the documentation

[gtcol]

You can use TTS method or impdp/expdp to achieve this. Lots of documents available online, just need to google them.

[shonymt]

PROCEDURE TO SHARE TABLESPACE
-----------------------------

The procedure to share the tablespace between two databases, the owner
database and the target database, is to use the transportable tablespace
feature in Oracle 8i. Both tablespaces must always be READ ONLY.

a. In the source database, make the tablespace READ ONLY

b. Export the tablespace from the source database using the transportable
tablespace option

c. Take the tablespace OFFLINE in the source database.

d. Physically copy the datafile(s) associated with this tablespce to the destination
database.

e. Import the tablespace into the destination database using the transportable
tablespace option.

f. Put the tablespace ONLINE in the source database.


PROCEDURE TO UPDATE THE SHARE TABLESPACE
----------------------------------------

a. In the destination database, drop the tablespace.

b. In the source database, change the tablespace to READ WRITE.

c. In the source database, update the data / structure of the tablespace.

d. In the source database change the tablespace to READ ONLY.

e. Export the tablespace from the source database using the transportable
tablespace option.

f. Take the tablespace OFFLINE in the source database.

g. Physically copy the datafile(s) associated with this tablespace to the destination
database.

g. Import the tablespace into the destination database using the transportable
tablespace option.

h. Put the tablespace ONLINE in the source database.