Transportable tablespace

[ganesh]

What is the advantage of transport tablespace?

[uday]

http://www.dbasupport.com/oracle/ora8/page9.shtml

post any questions you have after you read this article

[padmam]

Hi, 17th May 2001 19:11 hrs *******

Thanks Udai for the link good information for the day.

Look more info from Indiana University on the same

http://www.indiana.edu/~iars/tablespace.html


http://www.certcities.com/certs/orac...ditorialsID=32

======from Udai link article=====
The tablespace can not have any FUNCTION BASED INDEXES. I have not found this in any Oracle documentation, but when I run the check on my tablespace, I get the error " Domain/Functional Index VERTEXID.RATECITY in tablespace VERTEX not allowed in transportable set". The index specified does a DESC sort in the index. Just thought other users may benefit from this information.
====================Visit this link ====

http://www.oracle.com/oramag/oracle/...ml?o40dba.html
===============
Currently, the transport set cannot contain snapshots, function-based indexes, domain indexes, scoped REFs, and advanced queues.

=============

Cheers

Padmam